Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.WSHBV_PICK_LINE |
SELECT SPL.PICKING_LINE_ID
, SPL.CREATION_DATE
, SPL.CREATED_BY
, SPL.LAST_UPDATE_DATE
, SPL.LAST_UPDATED_BY
, SPL.LAST_UPDATE_LOGIN
, SPL.PROGRAM_APPLICATION_ID
, SPL.PROGRAM_ID
, SPL.PROGRAM_UPDATE_DATE
, SPL.REQUEST_ID
, SPL.PICKING_HEADER_ID
, SPL.ORDER_LINE_ID
, SPL.COMPONENT_CODE MODEL_OPTION_COMPONENT_CODE
, SPL.LINE_DETAIL_ID
, SPL.COMPONENT_RATIO MODEL_OPTION_COMPONENT_RATIO
, SPL.REQUESTED_QUANTITY CURRENT_REQUEST_QUANTITY
, SPL.INVENTORY_ITEM_ID
, SPL.INCLUDED_ITEM_FLAG
, SPL.DATE_REQUESTED
, SPL.ORIGINAL_REQUESTED_QUANTITY
, SPL.WAREHOUSE_ID
, SPL.SHIPPED_QUANTITY
, SPL.CANCELLED_QUANTITY
, SPL.SHIP_TO_SITE_USE_ID
, SPL.SHIP_TO_CONTACT_ID
, SPL.SHIPMENT_PRIORITY_CODE
, SPL.SHIP_METHOD_CODE
, SPL.DATE_CONFIRMED CONFIRMED_DATE
, SPL.RA_INTERFACE_STATUS RECEIVABLE_INTERFACE_STATUS
, SPL.INVOICED_QUANTITY
, SPL.INVENTORY_STATUS INVENTORY_INT_STATUS
, SPL.UNIT_CODE
, SPL.SCHEDULE_DATE
, SPL.COMPONENT_SEQUENCE_ID
, SPL.CONFIGURATION_ITEM_FLAG
, SPL.LATEST_ACCEPTABLE_DATE
, SPL.MOVEMENT_ID
, SPL.ORG_ID
, SPL.TRANSACTION_HEADER_ID
, SPL.SERVICE_INTERFACE_STATUS
, SPL.BO_PICKING_LINE_ID
, SPL.DEP_PLAN_REQUIRED_FLAG DEPARTURE_PLAN_REQUIRED_FLAG
, SPL.CUSTOMER_ITEM_ID
FROM SO_PICKING_LINES_ALL SPL