SELECT DISTINCT A.PNLGRPNAME , B.LANGUAGE_CD , B.DESCR FROM PSPNLGRPDEFN A , PSPNLGDEFNLANG B WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND A.PNLGRPNAME NOT IN('RSFM_PARTNR','RD_PARTNER','RD_PARTNER_SRCH','RSEC_ML_PART_C','RSEC_PART_CON_SRCH','RSFM_PARTNRCNT','RD_PR_LEVEL','RD_PR_PROG_SRCH','RD_PR_PGM_BEN','RD_PR_PGM_FEE','RD_PR_PGM_REQ','RD_PR_PROG','RSFM_PARTNR_RATE','RX_REGISTERPARTNER','RSFM_PARTNR_ROLE','RSEC_PARTNER_SRCH','RSEC_ML_PARTNER','RSFM_PARTNR_STAT','RSFM_PARTNR_TYPE','RD_PR_TYPE','RBF_PARTNERSHIP_2','RBF_PARTNR_GSRCH')
|