View: WSH_PICKING_UPGRADE_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_PICKING_UPGRADE_V

View Text

SELECT PL.PICKING_LINE_ID
, PL.PICKING_HEADER_ID
, PL.ORDER_LINE_ID
, PL.LINE_DETAIL_ID
, NVL(PLD.SCHEDULE_DATE
, PL.SCHEDULE_DATE) SCHEDULE_DATE
, SUM(PLD.REQUESTED_QUANTITY) REQUESTED_QUANTITY
, PLD.WAREHOUSE_ID
, PL.CUSTOMER_ITEM_ID
, PL.INVENTORY_ITEM_ID
, PL.CREATION_DATE
, PL.CREATED_BY
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.LAST_UPDATE_LOGIN
, PL.COMPONENT_SEQUENCE_ID
, PL.COMPONENT_CODE
, PL.SHIP_METHOD_CODE
, NVL(PLD.LATEST_ACCEPTABLE_DATE
, PL.LATEST_ACCEPTABLE_DATE) LATEST_ACCEPTABLE_DATE
, PL.DEP_PLAN_REQUIRED_FLAG
, PLD.SCHEDULE_STATUS_CODE
, PL.CONFIGURATION_ITEM_FLAG
, PL.INCLUDED_ITEM_FLAG
, SUM(PLD.SHIPPED_QUANTITY) SHIPPED_QUANTITY
, DP.ACTUAL_DEPARTURE_DATE
, PLD.DELIVERY FROM WSH_DEPARTURES DP
, SO_PICKING_LINES_ALL PL
, SO_PICKING_LINE_DETAILS PLD
WHERE PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID AND PLD.DEPARTURE_ID = DP.DEPARTURE_ID(+)
AND (PL.PICKING_HEADER_ID = 0 OR (PL.PICKING_HEADER_ID > 0
AND NVL(PL.SHIPPED_QUANTITY
, 0) > 0)) GROUP BY PL.PICKING_LINE_ID
, PL.PICKING_HEADER_ID
, PL.ORDER_LINE_ID
, PL.LINE_DETAIL_ID
, NVL(PLD.SCHEDULE_DATE
, PL.SCHEDULE_DATE)
, PLD.WAREHOUSE_ID
, PL.CUSTOMER_ITEM_ID
, PL.INVENTORY_ITEM_ID
, PL.CREATION_DATE
, PL.CREATED_BY
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.LAST_UPDATE_LOGIN
, PL.COMPONENT_SEQUENCE_ID
, PL.COMPONENT_CODE
, PL.SHIP_METHOD_CODE
, NVL(PLD.LATEST_ACCEPTABLE_DATE
, PL.LATEST_ACCEPTABLE_DATE)
, PL.DEP_PLAN_REQUIRED_FLAG
, PLD.SCHEDULE_STATUS_CODE
, PL.CONFIGURATION_ITEM_FLAG
, PL.INCLUDED_ITEM_FLAG
, DP.ACTUAL_DEPARTURE_DATE
, PLD.DELIVERY

Columns