|
SELECT DISTINCT P.BUSINESS_UNIT , P.REQ_ID FROM PS_REQ_LN_DISTRIB P WHERE (EXISTS( SELECT 'X' FROM PS_KK_SOURCE_HDR A , PS_KK_SOURCE_LN B , PS_KK_ACTIVITY_LOG C , PS_BUL_CNTL_BUD D WHERE A.KK_TRAN_ID = B.KK_TRAN_ID AND A.KK_TRAN_DT = B.KK_TRAN_DT AND B.KK_TRAN_ID = C.KK_TRAN_ID AND B.KK_TRAN_DT = C.KK_TRAN_DT AND B.KK_TRAN_LN = C.KK_TRAN_LN AND A.REQ_ID <> ' ' AND A.BUSINESS_UNIT = P.BUSINESS_UNIT AND A.REQ_ID = P.REQ_ID AND C.EE_PROC_STATUS = 'N' AND C.ENTRY_EVENT <> ' ' AND D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.KK_LEDGER_GROUP = C.LEDGER_GROUP AND D.KK_DETAIL_LED = 'Y')) OR (P.ENTRY_EVENT <> ' ' AND EXISTS( SELECT 'X' FROM PS_KK_ACTIVITY_LOG AA , PS_KK_SOURCE_HDR BB , PS_KK_SOURCE_LN CC , PS_BU_LED_GRP_TBL DD , PS_BUL_CNTL_BUD EE , PS_KK_REFERENCED FF , PS_REQ_LN_DISTRIB GG WHERE BB.KK_TRAN_ID = FF.KK_REFD_ID AND BB.KK_TRAN_DT = FF.KK_REFD_DT AND FF.KK_REFD_ID = CC.KK_TRAN_ID AND FF.KK_REFD_DT = CC.KK_TRAN_DT AND FF.KK_REFD_LN = CC.KK_TRAN_LN AND FF.KK_TRAN_ID = AA.KK_TRAN_ID AND FF.KK_TRAN_DT = AA.KK_TRAN_DT AND FF.KK_TRAN_LN = AA.KK_TRAN_LN AND AA.BUSINESS_UNIT = DD.BUSINESS_UNIT AND AA.LEDGER_GROUP = DD.LEDGER_GROUP AND DD.BUSINESS_UNIT = EE.BUSINESS_UNIT AND DD.LEDGER_GROUP = EE.KK_LEDGER_GROUP AND EE.KK_DETAIL_LED = 'Y' AND AA.ENTRY_EVENT <> ' ' AND AA.EE_PROC_STATUS = 'N' AND BB.KK_SOURCE_TRAN = 'REQ_PREENC' AND AA.REFERENCED_BUDGET = 'Y' AND BB.BUSINESS_UNIT = P.BUSINESS_UNIT AND BB.REQ_ID = P.REQ_ID))
|
BUSINESS_UNIT