FND Design Data [Home] [Help]

View: WSHBV_PICK_LINE

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

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

Columns

Name
PICKING_LINE_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
PICKING_HEADER_ID
ORDER_LINE_ID
MODEL_OPTION_COMPONENT_CODE
LINE_DETAIL_ID
MODEL_OPTION_COMPONENT_RATIO
CURRENT_REQUEST_QUANTITY
INVENTORY_ITEM_ID
INCLUDED_ITEM_FLAG
DATE_REQUESTED
ORIGINAL_REQUESTED_QUANTITY
WAREHOUSE_ID
SHIPPED_QUANTITY
CANCELLED_QUANTITY
SHIP_TO_SITE_USE_ID
SHIP_TO_CONTACT_ID
SHIPMENT_PRIORITY_CODE
SHIP_METHOD_CODE
CONFIRMED_DATE
RECEIVABLE_INTERFACE_STATUS
INVOICED_QUANTITY
INVENTORY_INT_STATUS
UNIT_CODE
SCHEDULE_DATE
COMPONENT_SEQUENCE_ID
CONFIGURATION_ITEM_FLAG
LATEST_ACCEPTABLE_DATE
MOVEMENT_ID
ORG_ID
TRANSACTION_HEADER_ID
SERVICE_INTERFACE_STATUS
BO_PICKING_LINE_ID
DEPARTURE_PLAN_REQUIRED_FLAG
CUSTOMER_ITEM_ID