|
SELECT S.SOURCE_BUS_UNIT , S.ORDER_NO , S.ORDER_INT_LINE_NO , S.SCHED_LINE_NBR , S.DEMAND_LINE_NO , S.INV_ITEM_ID , S.DEMAND_SOURCE , S.SOURCE_BUS_UNIT , S.LOCATION , M.DESCR , J.DESTIN_GL_BU , S.BUSINESS_UNIT , S.PRODUCT_ID , J.QTY , J.QTY_BASE , %DatePart(S.SHIP_DTTM) , S.SHIP_ID , J.UNIT_OF_MEASURE , J.UNIT_MEASURE_STD , J.SERIAL_ID , J.INV_LOT_ID , J.TRANSFER_COST , J.DT_TIMESTAMP , J.SEQ_NBR , J.BUSINESS_UNIT , S.CURRENCY_CD , J.ACCOUNT , J.ALTACCT , J.DEPTID , J.PROJECT_ID , J.ACTIVITY_ID , J.RESOURCE_CATEGORY , J.RESOURCE_SUB_CAT , J.RESOURCE_TYPE , J.ANALYSIS_TYPE ,%subrec(CF16_AN_SBR, J) , J.STORAGE_AREA , J.STOR_LEVEL_1 , J.STOR_LEVEL_2 , J.STOR_LEVEL_3 , J.STOR_LEVEL_4 , J.CONTAINER_ID ,S.BUSINESS_UNIT_PC FROM PS_MASTER_ITEM_TBL M , PS_IN_DEMAND S , PS_ISSUE_HDR_INV H , PS_TRANSACTION_INV J WHERE H.REQUEST_TYPE = 'I' AND H.DEMAND_SOURCE IN ('IN', 'PO', 'PR') AND S.BUSINESS_UNIT = H.BUSINESS_UNIT AND S.DEMAND_SOURCE = H.DEMAND_SOURCE AND S.SOURCE_BUS_UNIT = H.SOURCE_BUS_UNIT AND S.ORDER_NO = H.ORDER_NO AND S.IN_FULFILL_STATE BETWEEN '60' AND '70' AND M.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE RECNAME = 'MASTER_ITEM_TBL' AND SETCNTRLVALUE = S.SOURCE_BUS_UNIT) AND M.INV_ITEM_ID = S.INV_ITEM_ID AND S.BUSINESS_UNIT = J.BUSINESS_UNIT AND S.INV_ITEM_ID= J.INV_ITEM_ID AND S.SOURCE_BUS_UNIT = J.SOURCE_BUS_UNIT AND S.ORDER_NO = J.ORDER_NO AND J.TRANSACTION_GROUP = '036' AND S.ORDER_NO = J.ORDER_NO AND S.ORDER_INT_LINE_NO = J.ORDER_INT_LINE_NO AND S.SCHED_LINE_NBR = J.SCHED_LINE_NBR AND S.DEMAND_LINE_NO = J.DEMAND_LINE_NO
|
BUSINESS_UNIT