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: WMS_PACKING_MATERIAL_V

Product:	WMS - Warehouse Management
Description:	View to be used for Packing Workbench eligible material spreadtable
Implementation/DBA Data:	APPS.WMS_PACKING_MATERIAL_V

View Text

SELECT *
FROM WMS_PACKING_MATERIAL_GTEMP

Columns

Name
MOVE_ORDER_HEADER_ID
MOVE_ORDER_LINE_ID
REFERENCE
REFERENCE_ID
TXN_SOURCE_ID
DELIVERY_DETAIL_ID
ORGANIZATION_ID
ORGANIZATION_CODE
SUBINVENTORY
LOCATOR_ID
LOCATOR
PROJECT_ID
PROJECT
TASK_ID
TASK_NUMBER
TASK_NAME
INVENTORY_ITEM_ID
ITEM
ITEM_DESCRIPTION
LPN_ID
LPN
PARENT_LPN_ID
PARENT_LPN
OUTERMOST_LPN_ID
OUTERMOST_LPN
REVISION
UOM
LOT_NUMBER
QUANTITY
DELIVERY_ID
DELIVERY
DELIVERY_COMPLETED
TRIP_ID
TRIP
CARRIER_ID
CARRIER
ORDER_HEADER_ID
ORDER_NUMBER
ORDER_LINE_ID
ORDER_LINE_NUM
PACKING_INSTRUCTION
CUSTOMER_ID
CUSTOMER_NUMBER
CUSTOMER_NAME
SHIP_TO_LOCATION_ID
SHIP_TO_LOCATION
RECEIPT_NUM
DOCUMENT_TYPE
DOCUMENT_ID
DOCUMENT_NUMBER
DOCUMENT_LINE_ID
DOCUMENT_LINE_NUM
VENDOR_ID
SOURCE_ORG_ID
TRADING_PARTNER
RECEIVING_LOCATION_ID
RECEIVING_LOCATION
PTO_FLAG
SELECTED_FLAG
SHIP_SET_ID
SHIP_SET
SECONDARY_QUANTITY
SECONDARY_UOM_CODE
GRADE_CODE