FND Design Data [Home] [Help]

View: WSHBV_PICK_LINE_DETAIL

Product: OE - Order Entry
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.WSHBV_PICK_LINE_DETAIL
View Text

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

Columns

Name
PICKING_LINE_DETAIL_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
PICKING_LINE_ID
WAREHOUSE_ID
REQUESTED_QUANTITY
SHIPPED_QUANTITY
SERIAL_NUMBER
CUSTOMER_REQUESTED_LOT_FLAG
REVISION
SUBINVENTORY
INVENTORY_LOCATION_ID
RELEASED_FLAG
PICK_SCHEDULE_DATE
SCHEDULE_CONTROL_LEVEL
SCHEDULE_STATUS_CODE
DEMAND_ID
SUPPLY_SOURCE_TYPE
SUPPLY_SOURCE_HEADER_ID
DEMAND_CLASS_CODE
RESERVABLE_FLAG
INVENTORY_TRANSACTABLE_FLAG
LATEST_ACCEPTABLE_DATE
DEPARTURE_PLAN_ASSIGNED_FLAG
DELIVERY_ID
DEPARTURE_ID
LOAD_SEQUENCE_NUMBER
MASTER_CONTAINER_ITEM_ID
DETAIL_CONTAINER_ITEM_ID
TRANSACTION_TEMP_ID
PICK_SLIP_NUMBER
CONTAINER_ID
MOVEMENT_ID