|
SELECT DISTINCT HDR.BUSINESS_UNIT , HDR.RECEIVER_ID FROM PS_SET_CNTRL_REC T , PS_CM_LC_COMPONENT C , PS_BUS_UNIT_INTFC G , PS_BUS_UNIT_TBL_PM B , PS_PO_HDR H , PS_PO_LINE_DISTRIB PD , PS_RECV_LN_DISTRIB D , PS_RECV_LN_SHIP A , PS_RECV_HDR HDR WHERE A.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND A.RECEIVER_ID = HDR.RECEIVER_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.RECEIVER_ID = D.RECEIVER_ID AND A.RECV_LN_NBR = D.RECV_LN_NBR AND A.RECV_SHIP_SEQ_NBR = D.RECV_SHIP_SEQ_NBR AND A.PROCESS_COMPLETE = 'N' AND A.RECV_SHIP_STATUS NOT IN ('C', 'X') AND D.RECV_DS_STATUS NOT IN ('C', 'X') AND D.QTY_DS_ACCPT_VUOM <> 0 AND D.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT_GL = G.BUSINESS_UNIT AND D.BUSINESS_UNIT_PO = H.BUSINESS_UNIT AND D.PO_ID = H.PO_ID AND D.BUSINESS_UNIT_PO = PD.BUSINESS_UNIT AND D.PO_ID = PD.PO_ID AND D.LINE_NBR = PD.LINE_NBR AND D.SCHED_NBR = PD.SCHED_NBR AND PD.DST_ACCT_TYPE = 'DST' AND D.PO_DIST_LINE_NUM = PD.DISTRIB_LINE_NUM AND PD.MERCHANDISE_AMT <> 0 AND A.BUSINESS_UNIT = T.SETCNTRLVALUE AND T.RECNAME = 'CM_LC_COMPONENT' AND T.SETID = C.SETID AND ((PD.SALETX_AMT_BSE > 0 AND G.SALETX_CHARGE_CODE <> ' ' AND G.SALETX_CHARGE_CODE = C.MISC_CHARGE_CODE) OR ( PD.USETAX_AMT_BSE > 0 AND G.USETAX_CHARGE_CODE <> ' ' AND G.USETAX_CHARGE_CODE = C.MISC_CHARGE_CODE) OR ( PD.VAT_RCVRY_AMT_BSE > 0 AND G.VAT_NRCVR_CHRG_CD <> ' ' AND G.VAT_NRCVR_CHRG_CD = C.MISC_CHARGE_CODE))
|
BUSINESS_UNIT