eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: WSHFV_PICK_LINE

Product:	OE - Order Entry
Description:	- Retrofitted
Implementation/DBA Data:	Not implemented in this database

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
, SH.ORDER_NUMBER
, SPL.ORDER_LINE_ID
, SL.LINE_NUMBER
, 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
, MSI.DESCRIPTION ITEM_DESCRIPTION
, SPL.INCLUDED_ITEM_FLAG
, SPL.DATE_REQUESTED
, SPL.ORIGINAL_REQUESTED_QUANTITY
, SPL.WAREHOUSE_ID
, ORG.ORGANIZATION_CODE
, SPL.SHIPPED_QUANTITY
, SPL.CANCELLED_QUANTITY
, SPL.SHIP_TO_SITE_USE_ID
, SU.LOCATION SHIP_TO
, SPL.SHIP_TO_CONTACT_ID
, SPL.SHIPMENT_PRIORITY_CODE
, SPL.SHIP_METHOD_CODE
, OGF.DESCRIPTION FREIGHT
, SPL.DATE_CONFIRMED CONFIRMED_DATE
, SPL.RA_INTERFACE_STATUS RECEIVABLE_INTERFACE_STATUS
, SPL.INVOICED_QUANTITY
, SPL.INVENTORY_STATUS INVENTORY_INTERFACE_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
, HOU.NAME ORG_NAME
, 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
, SO_HEADERS_ALL SH
, SO_PICKING_HEADERS_ALL SPH
, SO_LINES_ALL SL
, MTL_PARAMETERS ORG
, MTL_SYSTEM_ITEMS MSI
, RA_SITE_USES_ALL SU
, ORG_FREIGHT OGF
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE SPH.PICKING_HEADER_ID (+) = SPL.PICKING_HEADER_ID
AND SPH.ORDER_HEADER_ID = SH.HEADER_ID (+)
AND SL.LINE_ID (+) = SPL.ORDER_LINE_ID
AND MSI.INVENTORY_ITEM_ID (+) = SPL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID (+) = SPL.WAREHOUSE_ID
AND ORG.ORGANIZATION_ID (+) = SPL.WAREHOUSE_ID
AND SU.SITE_USE_ID (+) = SPL.SHIP_TO_SITE_USE_ID
AND OGF.FREIGHT_CODE (+) = SPL.SHIP_METHOD_CODE
AND OGF.ORGANIZATION_ID (+) = SPL.WAREHOUSE_ID
AND HOU.ORGANIZATION_ID (+) = SPL.ORG_ID

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_NUMBER
ORDER_LINE_ID
LINE_NUMBER
MODEL_OPTION_COMPONENT_CODE
LINE_DETAIL_ID
MODEL_OPTION_COMPONENT_RATIO
CURRENT_REQUEST_QUANTITY
INVENTORY_ITEM_ID
ITEM_DESCRIPTION
INCLUDED_ITEM_FLAG
DATE_REQUESTED
ORIGINAL_REQUESTED_QUANTITY
WAREHOUSE_ID
ORGANIZATION_CODE
SHIPPED_QUANTITY
CANCELLED_QUANTITY
SHIP_TO_SITE_USE_ID
SHIP_TO
SHIP_TO_CONTACT_ID
SHIPMENT_PRIORITY_CODE
SHIP_METHOD_CODE
FREIGHT
CONFIRMED_DATE
RECEIVABLE_INTERFACE_STATUS
INVOICED_QUANTITY
INVENTORY_INTERFACE_STATUS
UNIT_CODE
SCHEDULE_DATE
COMPONENT_SEQUENCE_ID
CONFIGURATION_ITEM_FLAG
LATEST_ACCEPTABLE_DATE
MOVEMENT_ID
ORG_ID
ORG_NAME
TRANSACTION_HEADER_ID
SERVICE_INTERFACE_STATUS
BO_PICKING_LINE_ID
DEPARTURE_PLAN_REQUIRED_FLAG
CUSTOMER_ITEM_ID