Product: | WIP - Work in Process |
---|---|
Description: | Foreign-key data for WIP_SO_ALLOCATIONS |
Implementation/DBA Data: | APPS.WIP_SO_ALLOCATIONS_V |
SELECT WSA.ROWID ROW_ID
, MSO.SEGMENT1
, MSO.SEGMENT2
, MSO.SEGMENT3
, WSA.USER_LINE_NUM
, WSA.USER_DELIVERY
, WSA.DEMAND_CLASS
, WSA.QUANTITY_ALLOCATED
, DECODE(WSA.QUANTITY_COMPLETED
, 0
, NULL
, WSA.QUANTITY_COMPLETED)
, WSA.DEMAND_SOURCE_DELIVERY
, WSA.WIP_ENTITY_ID
, WSA.ORGANIZATION_ID
, WSA.ALLOCATION_ID
, WSA.DEMAND_SOURCE_HEADER_ID
, WSA.DEMAND_SOURCE_LINE
, WSA.LAST_UPDATE_DATE
, WSA.LAST_UPDATED_BY
, WSA.CREATION_DATE
, WSA.CREATED_BY
, WSA.LAST_UPDATE_LOGIN
, WSA.REQUEST_ID
, WSA.PROGRAM_APPLICATION_ID
, WSA.PROGRAM_ID
, WSA.PROGRAM_UPDATE_DATE
, (MD.LINE_ITEM_QUANTITY / MD.PRIMARY_UOM_QUANTITY)
, MD.UOM_CODE
, MD.REQUIREMENT_DATE
, (MD.PRIMARY_UOM_QUANTITY - MD.RESERVATION_QUANTITY + WSA.QUANTITY_ALLOCATED)
, MD.INVENTORY_ITEM_ID
FROM MTL_DEMAND MD
, MTL_SALES_ORDERS MSO
, WIP_SO_ALLOCATIONS WSA
WHERE WSA.DEMAND_SOURCE_HEADER_ID = MSO.SALES_ORDER_ID
AND MD.DEMAND_SOURCE_HEADER_ID(+) = WSA.DEMAND_SOURCE_HEADER_ID
AND MD.DEMAND_SOURCE_LINE(+) = WSA.DEMAND_SOURCE_LINE
AND MD.DEMAND_SOURCE_DELIVERY(+) = WSA.DEMAND_SOURCE_DELIVERY
AND MD.RESERVATION_TYPE(+) = 1
AND MD.ROW_STATUS_FLAG(+) = 1
AND MD.PARENT_DEMAND_ID(+) IS NULL
AND MD.DEMAND_SOURCE_TYPE(+) = 2
AND MD.SUPPLY_SOURCE_HEADER_ID(+) IS NULL
AND MD.PRIMARY_UOM_QUANTITY(+) > 0