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_TRANSACTIONS_TEMP

Object Details

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

Temporary Table Details

WMS.WMS_TRANSACTIONS_TEMP 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$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Column
WMS_TRANSACTIONS_TEMP_U1	NORMAL	UNIQUE	PP_TRANSACTION_TEMP_ID
WMS_TRANSACTIONS_TEMP_N1	NORMAL	NONUNIQUE	TRANSACTION_TEMP_ID TYPE_CODE LINE_TYPE_CODE
WMS_TRANSACTIONS_TEMP_N2	NORMAL	NONUNIQUE	TO_SUBINVENTORY_CODE TO_LOCATOR_ID

Columns

Name	Datatype	Length	Mandatory
PP_TRANSACTION_TEMP_ID	NUMBER		Yes
TRANSACTION_TEMP_ID	NUMBER		Yes
TYPE_CODE	NUMBER		Yes
LINE_TYPE_CODE	NUMBER		Yes
TRANSACTION_QUANTITY	NUMBER		Yes
PRIMARY_QUANTITY	NUMBER		Yes
REVISION	VARCHAR2	(3)
LOT_NUMBER	VARCHAR2	(80)
LOT_EXPIRATION_DATE	DATE
SERIAL_NUMBER	VARCHAR2	(30)
FROM_SUBINVENTORY_CODE	VARCHAR2	(10)
FROM_LOCATOR_ID	NUMBER
RULE_ID	NUMBER
TRANSACTION_SOURCE_ID	NUMBER
TRANSACTION_SOURCE_LINE_ID	NUMBER
TRANSACTION_SOURCE_NAME	VARCHAR2	(30)
TRANSACTION_SOURCE_DELIVERY	NUMBER
FREIGHT_CARRIER_CODE	VARCHAR2	(30)
CUSTOMER_ID	NUMBER
RESERVATION_ID	NUMBER
TO_SUBINVENTORY_CODE	VARCHAR2	(10)
TO_LOCATOR_ID	NUMBER
FROM_ORGANIZATION_ID	NUMBER
TO_ORGANIZATION_ID	NUMBER
FROM_COST_GROUP_ID	NUMBER
TO_COST_GROUP_ID	NUMBER
LPN_ID	NUMBER
SECONDARY_QUANTITY	NUMBER
GRADE_CODE	VARCHAR2	(150)

Query Text

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


SELECT PP_TRANSACTION_TEMP_ID
,      TRANSACTION_TEMP_ID
,      TYPE_CODE
,      LINE_TYPE_CODE
,      TRANSACTION_QUANTITY
,      PRIMARY_QUANTITY
,      REVISION
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
,      SERIAL_NUMBER
,      FROM_SUBINVENTORY_CODE
,      FROM_LOCATOR_ID
,      RULE_ID
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_LINE_ID
,      TRANSACTION_SOURCE_NAME
,      TRANSACTION_SOURCE_DELIVERY
,      FREIGHT_CARRIER_CODE
,      CUSTOMER_ID
,      RESERVATION_ID
,      TO_SUBINVENTORY_CODE
,      TO_LOCATOR_ID
,      FROM_ORGANIZATION_ID
,      TO_ORGANIZATION_ID
,      FROM_COST_GROUP_ID
,      TO_COST_GROUP_ID
,      LPN_ID
,      SECONDARY_QUANTITY
,      GRADE_CODE
FROM WMS.WMS_TRANSACTIONS_TEMP;

Dependencies

[top of page]

WMS.WMS_TRANSACTIONS_TEMP does not reference any database object

WMS.WMS_TRANSACTIONS_TEMP is referenced by following:

APPS: WMS_TRANSACTIONS_TEMP