Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT SHA.HEADER_ID
, SHA.ORDER_NUMBER PO_NUMBER
, SPLA.INVENTORY_ITEM_ID
, 11 ORDER_TYPE
, SPLA.ORDER_LINE_ID PURCH_LINE_NUM
, 2 FIRM_PLANNED_STATUS_TYPE
, SPLA.UNIT_CODE UOM_CODE
, SPLA.ORDER_LINE_ID LINE_ID
, SPLD.SHIPPED_QUANTITY NEW_ORDER_QUANTITY
, SPLD.WAREHOUSE_ID SOURCE_ORG_ID
, WD.PLANNED_DEPARTURE_DATE NEW_SCHEDULE_DATE
, WD.ACTUAL_DEPARTURE_DATE
, HOI.ORGANIZATION_ID
, SHA.CUSTOMER_ID
, SPHA.ARRIVED_FLAG
, WD.RN RN5
, SPLD.RN RN4
, SPHA.RN RN3
, MSI.RN RN2
, MP.RN RN1
FROM SO_HEADERS_ALL SHA
, MRP_AP_SO_PK_HDRS_SN SPHA
, MRP_AP_WSH_DEPAS_SN WD
, MRP_AP_SO_PK_DTLS_SN SPLD
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSI
, HR_ORGANIZATION_INFORMATION HOI
, SO_PICKING_LINES_ALL SPLA
WHERE MP.ORGANIZATION_ID= HOI.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID= SPLA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID= HOI.ORGANIZATION_ID
AND SHA.CUSTOMER_ID= TO_NUMBER( HOI.ORG_INFORMATION1)
AND SHA.HEADER_ID= SPHA.ORDER_HEADER_ID
AND SPHA.PICKING_HEADER_ID= SPLA.PICKING_HEADER_ID
AND SPLA.SHIP_TO_SITE_USE_ID= TO_NUMBER( HOI.ORG_INFORMATION2)
AND SPLD.PICKING_LINE_ID= SPLA.PICKING_LINE_ID
AND WD.DEPARTURE_ID= SPLD.DEPARTURE_ID
AND HOI.ORG_INFORMATION_CONTEXT= 'CUSTOMER/SUPPLIER ASSOCIATION'