SELECT F.FIELDNAME ,R.LANGUAGE_CD ,R.LONGNAME FROM PSPNLFIELD F ,PSDBFLDLABLLANG R WHERE R.FIELDNAME=F.FIELDNAME AND R.LABEL_ID=F.LABEL_ID AND F.PNLNAME IN ('TR_WR_TEMPLATE_FR', 'TR_WR_TEMPLATE_TO', 'TR_WR_TO_SBP', 'TR_INTR_TBL_SEC', 'TR_EFT_OPT_SEC', 'TR_WR_DESC_SEC' , 'TR_WR_ALTC1_SEC', 'TR_WR_ALTC2_SEC', 'ADDRESS_SBP', 'BANK_ACCT_AC1_SEC', 'BANK_ACCT_AC2_SEC', 'BUSINESS_PHONE_SBP', 'STL_ADDENDA_SP', 'STL_ADDENDA2_SP', 'TRP_POOL_WR_SEC') AND F.FIELDUSE IN (0, 8, 8192, 8200) AND F.FIELDTYPE NOT IN (2, 11, 12) AND F.FIELDNAME NOT IN ('TMPL_EXPIRATION_DT', 'REPETITVE_TRNFR_SW', 'REPETITVE_TRNFR_CD', 'DRAWDOWN_FLG', 'ACTIVE_STATUS', 'DESCR', ' ', 'PRENOTE_FLAG')
|