VIEW: APPS.WSHBV_PICK_LINE_DETAIL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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