|
SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.DISTRIB_LINE_NUM , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.BUSINESS_UNIT_AM , B.BUSINESS_UNIT_AP , D.BUSINESS_UNIT_PO , A.ASSET_ID , A.COST , D.CURRENCY_CD , A.CUSTODIAN , %subrec(CF14_AN_SBR, D) , S.DESCR254_MIXED , A.DISTRIB_SEQ_NUM , D.FINANCIAL_ASSET_SW , S.INV_ITEM_ID , A.LOCATION , A.MANUFACTURER , A.MODEL , D.PO_DIST_LINE_NUM , D.PO_ID , D.LINE_NBR , A.PROFILE_ID , D.PROJECT_ID , D.DEPTID , A.QUANTITY , D.SCHED_NBR , A.SERIAL_ID , A.TAG_NUMBER , H.VENDOR_ID FROM PS_RECV_HDR H , PS_RECV_LN_SHIP S , PS_RECV_LN_DISTRIB D , PS_RECV_LN_ASSET A , PS_BUS_UNIT_TBL_PM B WHERE A.BUSINESS_UNIT_AM > ' ' AND A.PROFILE_ID > ' ' AND A.QUANTITY > 0 AND H.BUSINESS_UNIT = B.BUSINESS_UNIT AND H.BUSINESS_UNIT = A.BUSINESS_UNIT AND H.RECEIVER_ID = A.RECEIVER_ID AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.RECEIVER_ID = A.RECEIVER_ID AND D.RECV_LN_NBR = A.RECV_LN_NBR AND D.RECV_SHIP_SEQ_NBR = A.RECV_SHIP_SEQ_NBR AND D.DISTRIB_LINE_NUM = A.DISTRIB_LINE_NUM AND A.BUSINESS_UNIT = S.BUSINESS_UNIT AND A.RECEIVER_ID = S.RECEIVER_ID AND A.RECV_LN_NBR = S.RECV_LN_NBR AND A.RECV_SHIP_SEQ_NBR = S.RECV_SHIP_SEQ_NBR AND A.RECV_AM_STATUS IN ('O', 'R')
|
BUSINESS_UNIT_RECV