eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: WSH_DELIVERY_LINES_DPW_V

Product:	OE - Order Entry
Description:	Delivery lines for Departure Planning Workbench
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SLD.ROWID
, SLD.LINE_DETAIL_ID
, 'LD'
, 'A'
, SL.HEADER_ID
, SLD.WAREHOUSE_ID
, SLD.RELEASED_FLAG
, SH.ORDER_NUMBER
, SH.ORDER_TYPE_ID
, SOTA.NAME
, SL.LINE_NUMBER
, SH.OPEN_FLAG
, SH.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, SLD.DEPARTURE_ID
, DEP.NAME
, DEP.STATUS_CODE
, DEP.PLANNED_DEPARTURE_DATE
, SLD.DELIVERY_ID
, DEL.NAME
, DEL.STATUS_CODE
, SLD.LOAD_SEQ_NUMBER
, NVL(SL.SHIP_TO_SITE_USE_ID
, SH.SHIP_TO_SITE_USE_ID)
, USHIP.LOCATION
, SL.INTERMEDIATE_SHIP_TO_ID
, ISHIP.LOCATION
, DEL.POOLED_SHIP_TO_ID
, PSHIP.LOCATION
, SLD.INVENTORY_ITEM_ID
, DECODE(SL.PARENT_LINE_ID
, NULL
, NULL
, SL2.INVENTORY_ITEM_ID)
, SLD.QUANTITY
, SLD.UNIT_CODE
, SLD.SCHEDULE_DATE
, SL.S2
, SL.S3
, SL.S4
, SL.S9
, SL.S27
, SLD.MASTER_CONTAINER_ITEM_ID
, SLD.DETAIL_CONTAINER_ITEM_ID
, SLA.INDUSTRY_ATTRIBUTE2
, SL.DATE_REQUESTED_CURRENT
, SH.CURRENCY_CODE
, SH.FOB_CODE
, SH.FREIGHT_TERMS_CODE
, SL.PLANNING_PROD_SEQ_NUMBER
, SL.CUSTOMER_MODEL_SERIAL_NUMBER
, SL.CUSTOMER_PRODUCTION_LINE
, SL.CUSTOMER_JOB
, SL.CUSTOMER_DOCK_CODE
, SLD.DEP_PLAN_REQUIRED_FLAG
, SLD.DPW_ASSIGNED_FLAG
, SLD.REVISION
, SLD.LOT_NUMBER
, SLD.SUBINVENTORY
, NVL(SL.SHIP_METHOD_CODE
, SH.SHIP_METHOD_CODE)
, WIP.WIP_ENTITY_NAME
, SL.SHIP_SET_NUMBER
, SL.SHIP_MODEL_COMPLETE_FLAG
, SLD.SHIPPABLE_FLAG
, SLD.INCLUDED_ITEM_FLAG
, SL.LINK_TO_LINE_ID
, SL.PARENT_LINE_ID
, SL.ATO_FLAG
, SLA.INDUSTRY_CONTEXT
, SLA.INDUSTRY_ATTRIBUTE1
, SLA.INDUSTRY_ATTRIBUTE2
, SLA.INDUSTRY_ATTRIBUTE3
, SLA.INDUSTRY_ATTRIBUTE4
, SLA.INDUSTRY_ATTRIBUTE5
, SLA.INDUSTRY_ATTRIBUTE6
, SLA.INDUSTRY_ATTRIBUTE7
, SLA.INDUSTRY_ATTRIBUTE8
, SLA.INDUSTRY_ATTRIBUTE9
, SLA.INDUSTRY_ATTRIBUTE10
, SLA.INDUSTRY_ATTRIBUTE11
, SLA.INDUSTRY_ATTRIBUTE12
, SLA.INDUSTRY_ATTRIBUTE13
, SLA.INDUSTRY_ATTRIBUTE14
, SLA.INDUSTRY_ATTRIBUTE15
, SLD.CREATED_BY
, SLD.CREATION_DATE
, SLD.LAST_UPDATED_BY
, SLD.LAST_UPDATE_DATE
, SLD.LAST_UPDATE_LOGIN
FROM WIP_ENTITIES WIP
, SO_LINE_ATTRIBUTES SLA
, RA_SITE_USES_ALL PSHIP
, RA_SITE_USES_ALL ISHIP
, SO_LINES_ALL SL2
, SO_LINES_ALL SL
, RA_SITE_USES_ALL USHIP
, RA_CUSTOMERS CUST
, SO_HEADERS_ALL SH
, SO_ORDER_TYPES_ALL SOTA
, SO_LINE_DETAILS SLD
, WSH_DELIVERIES DEL
, WSH_DEPARTURES DEP
WHERE SL.HEADER_ID = SH.HEADER_ID
AND SLD.LINE_ID = SL.LINE_ID
AND SOTA.ORDER_TYPE_ID = SH.ORDER_TYPE_ID
AND CUST.CUSTOMER_ID = SH.CUSTOMER_ID
AND NVL(SL.SHIP_TO_SITE_USE_ID
, SH.SHIP_TO_SITE_USE_ID) = USHIP.SITE_USE_ID
AND SL.INTERMEDIATE_SHIP_TO_ID = ISHIP.SITE_USE_ID (+)
AND SLD.LINE_ID = SLA.LINE_ID (+)
AND SLD.RELEASED_FLAG = 'N'
AND SLD.DEPARTURE_ID = DEP.DEPARTURE_ID (+)
AND SLD.DELIVERY_ID = DEL.DELIVERY_ID (+)
AND DEL.POOLED_SHIP_TO_ID = PSHIP.SITE_USE_ID (+)
AND SLD.SUPPLY_SOURCE_HEADER_ID = WIP.WIP_ENTITY_ID (+)
AND SL.PARENT_LINE_ID = SL2.LINE_ID (+)
AND SLD.DPW_ASSIGNED_FLAG IS NULL
AND ( (NVL(SLD.SHIPPABLE_FLAG
, 'N') = 'Y'
AND NOT (NVL(SL.ATO_FLAG
, 'N') = 'Y'
AND SL.ITEM_TYPE_CODE = 'MODEL')) OR (NVL(SLD.SHIPPABLE_FLAG
, 'N') = 'N'
AND NVL(SL.ATO_FLAG
, 'N') = 'Y'
AND SL.ATO_LINE_ID IS NULL
AND NVL(SLD.CONFIGURATION_ITEM_FLAG
, 'N') = 'N'
AND SL.ITEM_TYPE_CODE = 'MODEL') )
AND SH.S1 + 0 = 1
AND SH.ORDER_CATEGORY IN ('P'
, 'R')
AND NVL(SH.S4
, -1) != 11
AND NVL(SL.S9
, -1) != 11
AND NVL(SL.ORDERED_QUANTITY
, 0) > NVL(SL.CANCELLED_QUANTITY
, 0)
AND SL.ITEM_TYPE_CODE != 'SERVICE'
AND SL.LINE_TYPE_CODE IN ('REGULAR'
, 'DETAIL')
AND SL.SOURCE_TYPE_CODE = 'INTERNAL' UNION SELECT SLD.ROWID
, SLD.LINE_DETAIL_ID
, 'LD'
, 'U'
, SL.HEADER_ID
, SLD.WAREHOUSE_ID
, SLD.RELEASED_FLAG
, SH.ORDER_NUMBER
, SH.ORDER_TYPE_ID
, SOTA.NAME
, SL.LINE_NUMBER
, SH.OPEN_FLAG
, SH.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, SLD.DEPARTURE_ID
, DEP.NAME
, DEP.STATUS_CODE
, DEP.PLANNED_DEPARTURE_DATE
, SLD.DELIVERY_ID
, DEL.NAME
, DEL.STATUS_CODE
, SLD.LOAD_SEQ_NUMBER
, NVL(SL.SHIP_TO_SITE_USE_ID
, SH.SHIP_TO_SITE_USE_ID)
, USHIP.LOCATION
, SL.INTERMEDIATE_SHIP_TO_ID
, ISHIP.LOCATION
, DEL.POOLED_SHIP_TO_ID
, PSHIP.LOCATION
, SLD.INVENTORY_ITEM_ID
, DECODE(SL.PARENT_LINE_ID
, NULL
, NULL
, SL2.INVENTORY_ITEM_ID)
, SLD.QUANTITY
, SLD.UNIT_CODE
, SLD.SCHEDULE_DATE
, SL.S2
, SL.S3
, SL.S4
, SL.S9
, SL.S27
, SLD.MASTER_CONTAINER_ITEM_ID
, SLD.DETAIL_CONTAINER_ITEM_ID
, SLA.INDUSTRY_ATTRIBUTE2
, SL.DATE_REQUESTED_CURRENT
, SH.CURRENCY_CODE
, SH.FOB_CODE
, SH.FREIGHT_TERMS_CODE
, SL.PLANNING_PROD_SEQ_NUMBER
, SL.CUSTOMER_MODEL_SERIAL_NUMBER
, SL.CUSTOMER_PRODUCTION_LINE
, SL.CUSTOMER_JOB
, SL.CUSTOMER_DOCK_CODE
, SLD.DEP_PLAN_REQUIRED_FLAG
, SLD.DPW_ASSIGNED_FLAG
, SLD.REVISION
, SLD.LOT_NUMBER
, SLD.SUBINVENTORY
, NVL(SL.SHIP_METHOD_CODE
, SH.SHIP_METHOD_CODE)
, WIP.WIP_ENTITY_NAME
, SL.SHIP_SET_NUMBER
, SL.SHIP_MODEL_COMPLETE_FLAG
, SLD.SHIPPABLE_FLAG
, SLD.INCLUDED_ITEM_FLAG
, SL.LINK_TO_LINE_ID
, SL.PARENT_LINE_ID
, SL.ATO_FLAG
, SLA.INDUSTRY_CONTEXT
, SLA.INDUSTRY_ATTRIBUTE1
, SLA.INDUSTRY_ATTRIBUTE2
, SLA.INDUSTRY_ATTRIBUTE3
, SLA.INDUSTRY_ATTRIBUTE4
, SLA.INDUSTRY_ATTRIBUTE5
, SLA.INDUSTRY_ATTRIBUTE6
, SLA.INDUSTRY_ATTRIBUTE7
, SLA.INDUSTRY_ATTRIBUTE8
, SLA.INDUSTRY_ATTRIBUTE9
, SLA.INDUSTRY_ATTRIBUTE10
, SLA.INDUSTRY_ATTRIBUTE11
, SLA.INDUSTRY_ATTRIBUTE12
, SLA.INDUSTRY_ATTRIBUTE13
, SLA.INDUSTRY_ATTRIBUTE14
, SLA.INDUSTRY_ATTRIBUTE15
, SLD.CREATED_BY
, SLD.CREATION_DATE
, SLD.LAST_UPDATED_BY
, SLD.LAST_UPDATE_DATE
, SLD.LAST_UPDATE_LOGIN
FROM WIP_ENTITIES WIP
, SO_LINE_ATTRIBUTES SLA
, RA_SITE_USES_ALL PSHIP
, RA_SITE_USES_ALL ISHIP
, SO_LINES_ALL SL2
, SO_LINES_ALL SL
, RA_SITE_USES_ALL USHIP
, RA_CUSTOMERS CUST
, SO_HEADERS_ALL SH
, SO_ORDER_TYPES_ALL SOTA
, WSH_DELIVERIES DEL
, WSH_DEPARTURES DEP
, SO_LINE_DETAILS SLD
WHERE SL.HEADER_ID = SH.HEADER_ID
AND SLD.LINE_ID = SL.LINE_ID
AND SOTA.ORDER_TYPE_ID = SH.ORDER_TYPE_ID
AND CUST.CUSTOMER_ID = SH.CUSTOMER_ID
AND NVL(SL.SHIP_TO_SITE_USE_ID
, SH.SHIP_TO_SITE_USE_ID) = USHIP.SITE_USE_ID
AND SL.INTERMEDIATE_SHIP_TO_ID = ISHIP.SITE_USE_ID (+)
AND SLD.LINE_ID = SLA.LINE_ID (+)
AND SLD.RELEASED_FLAG = 'N'
AND SLD.DEPARTURE_ID = DEP.DEPARTURE_ID (+)
AND SLD.DELIVERY_ID = DEL.DELIVERY_ID (+)
AND DEL.POOLED_SHIP_TO_ID = PSHIP.SITE_USE_ID (+)
AND SLD.SUPPLY_SOURCE_HEADER_ID = WIP.WIP_ENTITY_ID (+)
AND SL.PARENT_LINE_ID = SL2.LINE_ID (+)
AND SLD.DPW_ASSIGNED_FLAG = 'N'
AND ( (NVL(SLD.SHIPPABLE_FLAG
, 'N') = 'Y'
AND NOT (NVL(SL.ATO_FLAG
, 'N') = 'Y'
AND SL.ITEM_TYPE_CODE = 'MODEL')) OR (NVL(SLD.SHIPPABLE_FLAG
, 'N') = 'N'
AND NVL(SL.ATO_FLAG
, 'N') = 'Y'
AND SL.ATO_LINE_ID IS NULL
AND NVL(SLD.CONFIGURATION_ITEM_FLAG
, 'N') = 'N'
AND SL.ITEM_TYPE_CODE = 'MODEL') )
AND SH.S1 + 0 = 1
AND SH.ORDER_CATEGORY IN ('P'
, 'R')
AND NVL(SH.S4
, -1) != 11
AND NVL(SL.S9
, -1) != 11
AND NVL(SL.ORDERED_QUANTITY
, 0) > NVL(SL.CANCELLED_QUANTITY
, 0)
AND SL.ITEM_TYPE_CODE != 'SERVICE'
AND SL.LINE_TYPE_CODE IN ('REGULAR'
, 'DETAIL')
AND SL.SOURCE_TYPE_CODE = 'INTERNAL' UNION SELECT SPLD.ROWID
, SPLD.PICKING_LINE_DETAIL_ID
, 'PLD'
, 'A'
, SL.HEADER_ID
, SPLD.WAREHOUSE_ID
, SPLD.RELEASED_FLAG
, SH.ORDER_NUMBER
, SH.ORDER_TYPE_ID
, SOTA.NAME
, SL.LINE_NUMBER
, SH.OPEN_FLAG
, SH.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, SPLD.DEPARTURE_ID
, DEP.NAME
, DEP.STATUS_CODE
, DEP.PLANNED_DEPARTURE_DATE
, SPLD.DELIVERY_ID
, DEL.NAME
, DEL.STATUS_CODE
, SPLD.LOAD_SEQ_NUMBER
, SPL.SHIP_TO_SITE_USE_ID
, USHIP.LOCATION
, SL.INTERMEDIATE_SHIP_TO_ID
, ISHIP.LOCATION
, DEL.POOLED_SHIP_TO_ID
, PSHIP.LOCATION
, SPL.INVENTORY_ITEM_ID
, DECODE(SL.PARENT_LINE_ID
, NULL
, NULL
, SL2.INVENTORY_ITEM_ID)
, DECODE(DEL.STATUS_CODE
, 'CL'
, SPLD.SHIPPED_QUANTITY
, SPLD.REQUESTED_QUANTITY)
, SPL.UNIT_CODE
, SPL.SCHEDULE_DATE
, SL.S2
, SL.S3
, SL.S4
, SL.S9
, SL.S27
, SPLD.MASTER_CONTAINER_ITEM_ID
, SPLD.DETAIL_CONTAINER_ITEM_ID
, SLA.INDUSTRY_ATTRIBUTE2
, SPL.DATE_REQUESTED
, SH.CURRENCY_CODE
, SH.FOB_CODE
, SH.FREIGHT_TERMS_CODE
, SL.PLANNING_PROD_SEQ_NUMBER
, SL.CUSTOMER_MODEL_SERIAL_NUMBER
, SL.CUSTOMER_PRODUCTION_LINE
, SL.CUSTOMER_JOB
, SL.CUSTOMER_DOCK_CODE
, SPL.DEP_PLAN_REQUIRED_FLAG
, SPLD.DPW_ASSIGNED_FLAG
, SPLD.REVISION
, SPLD.LOT_NUMBER
, SPLD.SUBINVENTORY
, NVL(SPL.SHIP_METHOD_CODE
, SH.SHIP_METHOD_CODE)
, WIP.WIP_ENTITY_NAME
, SL.SHIP_SET_NUMBER
, SL.SHIP_MODEL_COMPLETE_FLAG
, 'Y'
, SPL.INCLUDED_ITEM_FLAG
, SL.LINK_TO_LINE_ID
, SL.PARENT_LINE_ID
, SL.ATO_FLAG
, SLA.INDUSTRY_CONTEXT
, SLA.INDUSTRY_ATTRIBUTE1
, SLA.INDUSTRY_ATTRIBUTE2
, SLA.INDUSTRY_ATTRIBUTE3
, SLA.INDUSTRY_ATTRIBUTE4
, SLA.INDUSTRY_ATTRIBUTE5
, SLA.INDUSTRY_ATTRIBUTE6
, SLA.INDUSTRY_ATTRIBUTE7
, SLA.INDUSTRY_ATTRIBUTE8
, SLA.INDUSTRY_ATTRIBUTE9
, SLA.INDUSTRY_ATTRIBUTE10
, SLA.INDUSTRY_ATTRIBUTE11
, SLA.INDUSTRY_ATTRIBUTE12
, SLA.INDUSTRY_ATTRIBUTE13
, SLA.INDUSTRY_ATTRIBUTE14
, SLA.INDUSTRY_ATTRIBUTE15
, SPLD.CREATED_BY
, SPLD.CREATION_DATE
, SPLD.LAST_UPDATED_BY
, SPLD.LAST_UPDATE_DATE
, SPLD.LAST_UPDATE_LOGIN
FROM WIP_ENTITIES WIP
, SO_LINE_ATTRIBUTES SLA
, RA_CUSTOMERS CUST
, RA_SITE_USES_ALL PSHIP
, RA_SITE_USES_ALL USHIP
, RA_SITE_USES_ALL ISHIP
, SO_HEADERS_ALL SH
, SO_ORDER_TYPES_ALL SOTA
, SO_LINES_ALL SL2
, SO_LINES_ALL SL
, SO_PICKING_LINES_ALL SPL
, SO_PICKING_LINE_DETAILS SPLD
, WSH_DELIVERIES DEL
, WSH_DEPARTURES DEP
WHERE SL.HEADER_ID = SH.HEADER_ID
AND SPL.ORDER_LINE_ID = SL.LINE_ID
AND SPLD.PICKING_LINE_ID = SPL.PICKING_LINE_ID
AND SOTA.ORDER_TYPE_ID = SH.ORDER_TYPE_ID
AND CUST.CUSTOMER_ID = SH.CUSTOMER_ID
AND SPL.SHIP_TO_SITE_USE_ID = USHIP.SITE_USE_ID
AND SL.INTERMEDIATE_SHIP_TO_ID = ISHIP.SITE_USE_ID (+)
AND SPL.ORDER_LINE_ID = SLA.LINE_ID (+)
AND SPLD.DEPARTURE_ID = DEP.DEPARTURE_ID (+)
AND SPLD.DELIVERY_ID = DEL.DELIVERY_ID (+)
AND DEL.POOLED_SHIP_TO_ID = PSHIP.SITE_USE_ID (+)
AND SPLD.SUPPLY_SOURCE_HEADER_ID = WIP.WIP_ENTITY_ID (+)
AND SL.PARENT_LINE_ID = SL2.LINE_ID (+)
AND SPL.PICKING_HEADER_ID >= 0
AND SPLD.DPW_ASSIGNED_FLAG IS NULL
AND NVL(SPL.REQUESTED_QUANTITY
, 0) >= NVL( SPL.SHIPPED_QUANTITY
, 0)
AND SH.ORDER_CATEGORY IN ('P'
, 'R')
AND NVL(SH.S4
, -1) != 11
AND NVL(SL.S9
, -1) != 11 UNION SELECT SPLD.ROWID
, SPLD.PICKING_LINE_DETAIL_ID
, 'PLD'
, 'U'
, SL.HEADER_ID
, SPLD.WAREHOUSE_ID
, SPLD.RELEASED_FLAG
, SH.ORDER_NUMBER
, SH.ORDER_TYPE_ID
, SOTA.NAME
, SL.LINE_NUMBER
, SH.OPEN_FLAG
, SH.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, SPLD.DEPARTURE_ID
, DEP.NAME
, DEP.STATUS_CODE
, DEP.PLANNED_DEPARTURE_DATE
, SPLD.DELIVERY_ID
, DEL.NAME
, DEL.STATUS_CODE
, SPLD.LOAD_SEQ_NUMBER
, SPL.SHIP_TO_SITE_USE_ID
, USHIP.LOCATION
, SL.INTERMEDIATE_SHIP_TO_ID
, ISHIP.LOCATION
, DEL.POOLED_SHIP_TO_ID
, PSHIP.LOCATION
, SPL.INVENTORY_ITEM_ID
, DECODE(SL.PARENT_LINE_ID
, NULL
, NULL
, SL2.INVENTORY_ITEM_ID)
, DECODE(DEL.STATUS_CODE
, 'CL'
, SPLD.SHIPPED_QUANTITY
, SPLD.REQUESTED_QUANTITY)
, SPL.UNIT_CODE
, SPL.SCHEDULE_DATE
, SL.S2
, SL.S3
, SL.S4
, SL.S9
, SL.S27
, SPLD.MASTER_CONTAINER_ITEM_ID
, SPLD.DETAIL_CONTAINER_ITEM_ID
, SLA.INDUSTRY_ATTRIBUTE2
, SPL.DATE_REQUESTED
, SH.CURRENCY_CODE
, SH.FOB_CODE
, SH.FREIGHT_TERMS_CODE
, SL.PLANNING_PROD_SEQ_NUMBER
, SL.CUSTOMER_MODEL_SERIAL_NUMBER
, SL.CUSTOMER_PRODUCTION_LINE
, SL.CUSTOMER_JOB
, SL.CUSTOMER_DOCK_CODE
, SPL.DEP_PLAN_REQUIRED_FLAG
, SPLD.DPW_ASSIGNED_FLAG
, SPLD.REVISION
, SPLD.LOT_NUMBER
, SPLD.SUBINVENTORY
, NVL(SPL.SHIP_METHOD_CODE
, SH.SHIP_METHOD_CODE)
, WIP.WIP_ENTITY_NAME
, SL.SHIP_SET_NUMBER
, SL.SHIP_MODEL_COMPLETE_FLAG
, 'Y'
, SPL.INCLUDED_ITEM_FLAG
, SL.LINK_TO_LINE_ID
, SL.PARENT_LINE_ID
, SL.ATO_FLAG
, SLA.INDUSTRY_CONTEXT
, SLA.INDUSTRY_ATTRIBUTE1
, SLA.INDUSTRY_ATTRIBUTE2
, SLA.INDUSTRY_ATTRIBUTE3
, SLA.INDUSTRY_ATTRIBUTE4
, SLA.INDUSTRY_ATTRIBUTE5
, SLA.INDUSTRY_ATTRIBUTE6
, SLA.INDUSTRY_ATTRIBUTE7
, SLA.INDUSTRY_ATTRIBUTE8
, SLA.INDUSTRY_ATTRIBUTE9
, SLA.INDUSTRY_ATTRIBUTE10
, SLA.INDUSTRY_ATTRIBUTE11
, SLA.INDUSTRY_ATTRIBUTE12
, SLA.INDUSTRY_ATTRIBUTE13
, SLA.INDUSTRY_ATTRIBUTE14
, SLA.INDUSTRY_ATTRIBUTE15
, SPLD.CREATED_BY
, SPLD.CREATION_DATE
, SPLD.LAST_UPDATED_BY
, SPLD.LAST_UPDATE_DATE
, SPLD.LAST_UPDATE_LOGIN
FROM WIP_ENTITIES WIP
, SO_LINE_ATTRIBUTES SLA
, RA_CUSTOMERS CUST
, RA_SITE_USES_ALL PSHIP
, RA_SITE_USES_ALL USHIP
, RA_SITE_USES_ALL ISHIP
, SO_HEADERS_ALL SH
, SO_ORDER_TYPES_ALL SOTA
, SO_LINES_ALL SL2
, SO_LINES_ALL SL
, WSH_DELIVERIES DEL
, WSH_DEPARTURES DEP
, SO_PICKING_LINES_ALL SPL
, SO_PICKING_LINE_DETAILS SPLD
WHERE SL.HEADER_ID = SH.HEADER_ID
AND SPL.ORDER_LINE_ID = SL.LINE_ID
AND SPLD.PICKING_LINE_ID = SPL.PICKING_LINE_ID
AND SOTA.ORDER_TYPE_ID = SH.ORDER_TYPE_ID
AND CUST.CUSTOMER_ID = SH.CUSTOMER_ID
AND SPL.SHIP_TO_SITE_USE_ID = USHIP.SITE_USE_ID
AND SL.INTERMEDIATE_SHIP_TO_ID = ISHIP.SITE_USE_ID (+)
AND SPL.ORDER_LINE_ID = SLA.LINE_ID (+)
AND SPLD.DEPARTURE_ID = DEP.DEPARTURE_ID (+)
AND SPLD.DELIVERY_ID = DEL.DELIVERY_ID (+)
AND DEL.POOLED_SHIP_TO_ID = PSHIP.SITE_USE_ID (+)
AND SPLD.SUPPLY_SOURCE_HEADER_ID = WIP.WIP_ENTITY_ID (+)
AND SL.PARENT_LINE_ID = SL2.LINE_ID (+)
AND SPL.PICKING_HEADER_ID >= 0
AND SPLD.DPW_ASSIGNED_FLAG = 'N'
AND NVL(SPL.REQUESTED_QUANTITY
, 0) >= NVL( SPL.SHIPPED_QUANTITY
, 0)
AND SH.ORDER_CATEGORY IN ('P'
, 'R')
AND NVL(SH.S4
, -1) != 11
AND NVL(SL.S9
, -1) != 11

Columns

Name
ROW_ID
DEL_LINE_DETAIL_ID
LINE_TYPE
LINE_STATUS
HEADER_ID
ORGANIZATION_ID
RELEASED_FLAG
ORDER_NUMBER
ORDER_TYPE_ID
ORDER_TYPE
ORDER_LINE_NUMBER
OPEN_FLAG
CUSTOMER_ID
CUSTOMER_NAME
DEPARTURE_ID
DEPARTURE_NAME
DEPARTURE_STATUS_CODE
PLANNED_DEPARTURE_DATE
DELIVERY_ID
DELIVERY_NAME
DELIVERY_STATUS_CODE
LOAD_SEQ_NUMBER
ULTIMATE_SHIP_TO_ID
ULTIMATE_SHIP_TO
INTERMEDIATE_SHIP_TO_ID
INTERMEDIATE_SHIP_TO
POOLED_SHIP_TO_ID
POOLED_SHIP_TO
INVENTORY_ITEM_ID
TOP_INVENTORY_ITEM_ID
QUANTITY
UNIT_CODE
SCHEDULE_DATE
S2
S3
S4
S9
S27
MASTER_CONTAINER_ITEM_ID
DETAIL_CONTAINER_ITEM_ID
DEMAND_SOURCE
REQUESTED_DATE
CURRENCY_CODE
FOB_CODE
FREIGHT_TERMS_CODE
PLANNING_PROD_SEQ_NUMBER
CUSTOMER_MODEL_SERIAL_NUMBER
CUSTOMER_PRODUCTION_LINE
CUSTOMER_JOB
CUSTOMER_DOCK_CODE
DEP_PLAN_REQUIRED_FLAG
DPW_ASSIGNED_FLAG
REVISION
LOT_NUMBER
SUBINVENTORY
FREIGHT_CARRIER_CODE
WIP_JOB_NUMBER
SHIP_SET_NUMBER
SHIP_MODEL_COMPLETE_FLAG
SHIPPABLE_FLAG
INCLUDED_ITEM_FLAG
LINK_TO_LINE_ID
PARENT_LINE_ID
ATO_FLAG
INDUSTRY_CONTEXT
INDUSTRY_ATTRIBUTE1
INDUSTRY_ATTRIBUTE2
INDUSTRY_ATTRIBUTE3
INDUSTRY_ATTRIBUTE4
INDUSTRY_ATTRIBUTE5
INDUSTRY_ATTRIBUTE6
INDUSTRY_ATTRIBUTE7
INDUSTRY_ATTRIBUTE8
INDUSTRY_ATTRIBUTE9
INDUSTRY_ATTRIBUTE10
INDUSTRY_ATTRIBUTE11
INDUSTRY_ATTRIBUTE12
INDUSTRY_ATTRIBUTE13
INDUSTRY_ATTRIBUTE14
INDUSTRY_ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN