Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.WSHBV_PICK_LINE_DETAIL |
SELECT SPLD.PICKING_LINE_DETAIL_ID
, SPLD.LAST_UPDATE_DATE
, SPLD.LAST_UPDATED_BY
, SPLD.CREATED_BY
, SPLD.CREATION_DATE
, SPLD.LAST_UPDATE_LOGIN
, SPLD.PROGRAM_APPLICATION_ID
, SPLD.PROGRAM_ID
, SPLD.PROGRAM_UPDATE_DATE
, SPLD.REQUEST_ID
, SPLD.PICKING_LINE_ID
, SPLD.WAREHOUSE_ID
, SPLD.REQUESTED_QUANTITY
, SPLD.SHIPPED_QUANTITY
, SPLD.SERIAL_NUMBER
, SPLD.CUSTOMER_REQUESTED_LOT_FLAG
, SPLD.REVISION
, SPLD.SUBINVENTORY
, SPLD.INVENTORY_LOCATION_ID
, SPLD.RELEASED_FLAG
, SPLD.SCHEDULE_DATE PICK_SCHEDULE_DATE
, SPLD.SCHEDULE_LEVEL SCHEDULE_CONTROL_LEVEL
, SPLD.SCHEDULE_STATUS_CODE
, SPLD.DEMAND_ID
, SPLD.SUPPLY_SOURCE_TYPE
, SPLD.SUPPLY_SOURCE_HEADER_ID
, SPLD.DEMAND_CLASS_CODE
, SPLD.RESERVABLE_FLAG
, SPLD.TRANSACTABLE_FLAG INVENTORY_TRANSACTABLE_FLAG
, SPLD.LATEST_ACCEPTABLE_DATE
, SPLD.DPW_ASSIGNED_FLAG DEPARTURE_PLAN_ASSIGNED_FLAG
, SPLD.DELIVERY_ID
, SPLD.DEPARTURE_ID
, SPLD.LOAD_SEQ_NUMBER LOAD_SEQUENCE_NUMBER
, SPLD.MASTER_CONTAINER_ITEM_ID
, SPLD.DETAIL_CONTAINER_ITEM_ID
, SPLD.TRANSACTION_TEMP_ID
, SPLD.PICK_SLIP_NUMBER
, SPLD.CONTAINER_ID
, SPLD.MOVEMENT_ID
FROM SO_PICKING_LINE_DETAILS SPLD