|
SELECT FB.BUSINESS_UNIT , TB.BUSINESS_UNIT , A.DESCR , A.DESCRSHORT FROM PS_BUS_UNIT_TBL_FS A , PS_BUS_UNIT_TBL_GL FB , PS_SET_CNTRL_GROUP FS , PS_IU_INTER_TRAN FT , PS_BUS_UNIT_TBL_GL TB , PS_SET_CNTRL_GROUP TS , PS_IU_INTER_TRAN TT WHERE FS.SETCNTRLVALUE = FB.BUSINESS_UNIT AND FS.SETCNTRLVALUE = A.BUSINESS_UNIT AND FS.REC_GROUP_ID = 'FS_59' AND FT.SETID = FS.SETID AND FT.IU_INTER_TMPLT_CD = TB.IU_INTER_TMPLT_CD AND FT.IU_TRAN_CD IN ( SELECT DISTINCT IU_TRAN_CD FROM PS_IU_TRAN_MAP_TBL WHERE IU_SYS_TRAN_CD = 'BIIVC') AND TS.SETCNTRLVALUE = TB.BUSINESS_UNIT AND TS.REC_GROUP_ID = 'FS_59' AND TT.SETID = TS.SETID AND TT.IU_INTER_TMPLT_CD = FB.IU_INTER_TMPLT_CD AND TT.IU_TRAN_CD IN ( SELECT DISTINCT IU_TRAN_CD FROM PS_IU_TRAN_MAP_TBL WHERE IU_SYS_TRAN_CD = 'BIIVC')
|
BUSINESS_UNIT_GL