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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: WMS.WMS_PACKING_MATERIAL_GTEMP

Object Details

Object Name:	WMS_PACKING_MATERIAL_GTEMP
Object Type:	TABLE
Owner:	WMS
FND Design Data:	WMS.WMS_PACKING_MATERIAL_GTEMP
Subobject Name:
Status:	VALID

Temporary Table Details

WMS.WMS_PACKING_MATERIAL_GTEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
MOVE_ORDER_HEADER_ID	NUMBER
MOVE_ORDER_LINE_ID	NUMBER
REFERENCE	VARCHAR2	(240)
REFERENCE_ID	NUMBER
TXN_SOURCE_ID	NUMBER
DELIVERY_DETAIL_ID	NUMBER
ORGANIZATION_ID	NUMBER
ORGANIZATION_CODE	VARCHAR2	(3)
SUBINVENTORY	VARCHAR2	(10)
LOCATOR_ID	NUMBER
LOCATOR	VARCHAR2	(204)
PROJECT_ID	NUMBER
PROJECT	VARCHAR2	(30)
TASK_ID	NUMBER
TASK_NUMBER	VARCHAR2	(25)
TASK_NAME	VARCHAR2	(20)
INVENTORY_ITEM_ID	NUMBER
ITEM	VARCHAR2	(40)
ITEM_DESCRIPTION	VARCHAR2	(240)
LPN_ID	NUMBER
LPN	VARCHAR2	(30)
PARENT_LPN_ID	NUMBER
PARENT_LPN	VARCHAR2	(30)
OUTERMOST_LPN_ID	NUMBER
OUTERMOST_LPN	VARCHAR2	(30)
REVISION	VARCHAR2	(3)
UOM	VARCHAR2	(3)
LOT_NUMBER	VARCHAR2	(80)
QUANTITY	NUMBER
DELIVERY_ID	NUMBER
DELIVERY	VARCHAR2	(30)
DELIVERY_COMPLETED	VARCHAR2	(1)
TRIP_ID	NUMBER
TRIP	VARCHAR2	(30)
CARRIER_ID	NUMBER
CARRIER	VARCHAR2	(360)
ORDER_HEADER_ID	NUMBER
ORDER_NUMBER	VARCHAR2	(150)
ORDER_LINE_ID	NUMBER
ORDER_LINE_NUM	VARCHAR2	(150)
PACKING_INSTRUCTION	VARCHAR2	(2000)
CUSTOMER_ID	NUMBER
CUSTOMER_NUMBER	VARCHAR2	(30)
CUSTOMER_NAME	VARCHAR2	(360)
SHIP_TO_LOCATION_ID	NUMBER
SHIP_TO_LOCATION	VARCHAR2	(60)
RECEIPT_NUM	VARCHAR2	(30)
DOCUMENT_TYPE	VARCHAR2	(20)
DOCUMENT_ID	NUMBER
DOCUMENT_NUMBER	VARCHAR2	(50)
DOCUMENT_LINE_ID	NUMBER
DOCUMENT_LINE_NUM	NUMBER
VENDOR_ID	NUMBER
SOURCE_ORG_ID	NUMBER
TRADING_PARTNER	VARCHAR2	(240)
RECEIVING_LOCATION_ID	NUMBER
RECEIVING_LOCATION	VARCHAR2	(60)
PTO_FLAG	VARCHAR2	(1)
SELECTED_FLAG	VARCHAR2	(1)
SHIP_SET_ID	NUMBER
SHIP_SET	VARCHAR2	(30)
SECONDARY_QUANTITY	NUMBER
SECONDARY_UOM_CODE	VARCHAR2	(3)
GRADE_CODE	VARCHAR2	(150)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM WMS.WMS_PACKING_MATERIAL_GTEMP;

Dependencies

[top of page]

WMS.WMS_PACKING_MATERIAL_GTEMP does not reference any database object

WMS.WMS_PACKING_MATERIAL_GTEMP is referenced by following:

APPS: WMS_PACKING_MATERIAL_GTEMP