|
SELECT A.SETCNTRLVALUE BUSINESS_UNIT , MAX(CASE WHEN A.RECNAME = 'GL_ACCOUNT_TBL' THEN SETID ELSE ' ' END) ACCOUNT_SETID , MAX(CASE WHEN A.RECNAME = 'ALTACCT_TBL' THEN SETID ELSE ' ' END) ALTACCT_SETID , MAX(CASE WHEN A.RECNAME = 'DEPT_TBL' THEN SETID ELSE ' ' END) DEPT_SETID , MAX(CASE WHEN D.ORIG_REC_NAME = 'OPER_UNIT_TBL' THEN SETID ELSE ' ' END) OPRUNT_SETID , MAX(CASE WHEN D.ORIG_REC_NAME = 'PRODUCT_TBL' THEN SETID ELSE ' ' END) PRODUCT_SETID , MAX(CASE WHEN D.ORIG_REC_NAME = 'FUND_TBL' THEN SETID ELSE ' ' END) FUNDCD_SETID , MAX(CASE WHEN D.ORIG_REC_NAME = 'CLASS_CF_TBL' THEN SETID ELSE ' ' END) CLASSFLD_SETID , MAX(CASE WHEN D.ORIG_REC_NAME = 'PROGRAM_TBL' THEN SETID ELSE ' ' END) PROGCD_SETID , MAX(CASE WHEN D.ORIG_REC_NAME = 'BUD_REF_TBL' THEN SETID ELSE ' ' END) BUDGREF_SETID , MAX(CASE WHEN D.ORIG_REC_NAME = 'AFFINTRA1_VW' THEN SETID ELSE ' ' END) AFFINTR1_SETID , MAX(CASE WHEN D.ORIG_REC_NAME = 'AFFINTRA2_VW' THEN SETID ELSE ' ' END) AFFINTR2_SETID , MAX(CASE WHEN A.RECNAME = 'PROJECT_FS' THEN SETID ELSE ' ' END) PROJECT_SETID , MAX(CASE WHEN A.RECNAME = 'BOOK_CODE_TBL' THEN SETID ELSE ' ' END) BOOKCD_SETID , MAX(CASE WHEN A.RECNAME = 'ADJUST_TYPE_TBL' THEN SETID ELSE ' ' END) ADJTYPE_SETID , MAX(CASE WHEN A.RECNAME = 'STAT_TBL' THEN SETID ELSE ' ' END) STATCD_SETID , MAX(CASE WHEN D.ORIG_REC_NAME = 'CHARTFIELD1_TBL' THEN SETID ELSE ' ' END) CF1_SETID , MAX(CASE WHEN D.ORIG_REC_NAME = 'CHARTFIELD2_TBL' THEN SETID ELSE ' ' END) CF2_SETID , MAX(CASE WHEN D.ORIG_REC_NAME = 'CHARTFIELD3_TBL' THEN SETID ELSE ' ' END) CF3_SETID , MAX(CASE WHEN A.RECNAME = 'LED_DEFN_TBL' THEN SETID ELSE ' ' END) LEDGER_SETID , MAX(CASE WHEN A.RECNAME = 'BD_SCENARIO_TBL' THEN SETID ELSE ' ' END) BD_SCEN_SETID , MAX(CASE WHEN A.RECNAME = 'LED_GRP_TBL' THEN SETID ELSE ' ' END) LEDGRP_SETID , MAX(CASE WHEN A.RECNAME = 'PROJ_RES_TYPE' THEN SETID ELSE ' ' END) PRJRESTYP_SETID , MAX(CASE WHEN A.RECNAME = 'PROJ_CATG_TBL' THEN SETID ELSE ' ' END) PRJCATG_SETID , MAX(CASE WHEN A.RECNAME = 'PROJ_CAT_SUB' THEN SETID ELSE ' ' END) PRJCATSUB_SETID , MAX(CASE WHEN A.RECNAME = 'PROJ_ANTYPE_TBL' THEN SETID ELSE ' ' END) PRJANTYP_SETID , MAX(CASE WHEN A.RECNAME = 'DOC_TYPE_TBL' THEN SETID ELSE ' ' END) DOCTYP_SETID , MAX(CASE WHEN A.RECNAME = 'VAT_TXN_CD' THEN SETID ELSE ' ' END) VATTXN_SETID , MAX(CASE WHEN A.RECNAME = 'VAT_USE_TBL' THEN SETID ELSE ' ' END) VATUSE_SETID , MAX(CASE WHEN A.RECNAME = 'TAX_HEADER_TBL' THEN SETID ELSE ' ' END) VATCDTAX_SETID , MAX(CASE WHEN A.RECNAME = 'EE_EVENT_HDR' THEN SETID ELSE ' ' END) ENTEVNT_SETID , MAX(CASE WHEN A.RECNAME = 'SPEEDTYP_TBL' THEN SETID ELSE ' ' END) SPDTYP_SETID , MAX(CASE WHEN A.RECNAME = 'SPEEDCHART_DTL' THEN SETID ELSE ' ' END) SPDCHRT_SETID , MAX(CASE WHEN A.RECNAME = 'CAL_DEFN_TBL' THEN SETID ELSE ' ' END) CALDEFN_SETID , MAX(CASE WHEN A.RECNAME = 'JRNL_CLASS_TBL' THEN SETID ELSE ' ' END) JRNLCLS_SETID , MAX(CASE WHEN A.RECNAME = 'SCHEDULE_TBL' THEN SETID ELSE ' ' END) JRNLSCH_SETID , MAX(CASE WHEN A.RECNAME = 'EVENTS_TBL' THEN SETID ELSE ' ' END) JRNLEVNT_SETID , MAX(CASE WHEN A.RECNAME = 'AGENCY_LOC_CD' THEN SETID ELSE ' ' END) AGNLOC_SETID , MAX(CASE WHEN A.RECNAME = 'SOURCE_TBL' THEN SETID ELSE ' ' END) SOURCE_SETID , ' ' TREE_SETID FROM PS_SET_CNTRL_REC A LEFT OUTER JOIN PS_FS_CF_TEMPLATE D ON A.RECNAME = D.ORIG_REC_NAME GROUP BY A.SETCNTRLVALUE
|