WSH_ORDER_LINES_V

Details

• Schema: FUSION

• Object owner: WSH

• Object type: VIEW

Columns

Name
SOURCE_SYSTEM_ID SOURCE_HEADER_NUMBER SOURCE_LINE_NUMBER SOURCE_SHIPMENT_NUMBER SOURCE_SHIPMENT_ID SALES_ORDER_NUMBER SALES_ORDER_LINE_NUMBER SALES_ORDER_SHIPMENT_NUMBER INVENTORY_ITEM_ID ORDERED_QUANTITY SHIPPED_QUANTITY STAGED_QUANTITY BACKORDERED_QUANTITY RELEASEDTOWAREHOUSE_QTY NEW_SOURCE_SHIPMENT_ID NEW_SOURCE_SHIPMENT_NUMBER

Query

SQL_Statement

SELECT source_system_id, source_header_number, source_line_number, source_shipment_number, source_shipment_id, sales_order_number, sales_order_line_number, sales_order_shipment_number, MAX(inventory_item_id) inventory_item_id, MAX(src_requested_quantity) ordered_quantity, SUM(DECODE(released_status,'C', converted_quantity,0)) shipped_quantity, SUM(DECODE(released_status,'Y', converted_quantity,0)) staged_quantity, SUM(DECODE(released_status,'B', converted_quantity,0)) backordered_quantity, SUM(DECODE(released_status,'S', nvl(converted_quantity, wsh_wv_utils.convert_uom( p_from_uom => requested_quantity_uom, p_to_uom => src_requested_quantity_uom, p_quantity => requested_quantity, p_item_id => inventory_item_id, p_org_id => organization_id)),0)) releasedtowarehouse_qty, new_source_shipment_id, new_source_shipment_number FROM wsh_delivery_details GROUP BY source_system_id, source_header_number, source_line_number, source_shipment_number, source_shipment_id, sales_order_number, sales_order_line_number, sales_order_shipment_number, new_source_shipment_id, new_source_shipment_number