VIEW: APPS.WIP_SO_ALLOCATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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