VIEW: APPS.WSH_PICKING_UPGRADE_V

Source

View Text - Preformatted

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 , pl.invoiced_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) , pl.invoiced_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) , pl.dep_plan_required_flag , pld.schedule_status_code , pl.configuration_item_flag , pl.included_item_flag , dp.actual_departure_date , pld.delivery

View Text - HTML Formatted

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
, PL.INVOICED_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)
, PL.INVOICED_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)
, PL.DEP_PLAN_REQUIRED_FLAG
, PLD.SCHEDULE_STATUS_CODE
, PL.CONFIGURATION_ITEM_FLAG
, PL.INCLUDED_ITEM_FLAG
, DP.ACTUAL_DEPARTURE_DATE
, PLD.DELIVERY