VIEW: APPS.WSHBV_PICK_LINE

Source

View Text - Preformatted

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

View Text - HTML Formatted

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