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_PUTAWAY_GROUP_TASKS_GTMP

Object Details

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

Temporary Table Details

WMS.WMS_PUTAWAY_GROUP_TASKS_GTMP 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
ORGANIZATION_ID	NUMBER
TRANSACTION_TEMP_ID	NUMBER
TRANSACTION_HEADER_ID	NUMBER
LPN_ID	NUMBER
LPN_NAME	VARCHAR2	(30)
LPN_CONTEXT	NUMBER
PARENT_LPN_ID	NUMBER
PARENT_LPN_NAME	VARCHAR2	(30)
OUTERMOST_LPN_ID	NUMBER
OUTERMOST_LPN_NAME	VARCHAR2	(30)
CONSOLIDATED_LPN_ID	NUMBER
CONSOLIDATED_LPN_NAME	VARCHAR2	(30)
INTO_LPN_ID	NUMBER
INTO_LPN_NAME	VARCHAR2	(30)
DROP_TYPE	VARCHAR2	(15)
DROP_ORDER	NUMBER
INVENTORY_ITEM_ID	NUMBER
ITEM	VARCHAR2	(800)
GROUP_ID	NUMBER
LOT_NUMBER	VARCHAR2	(80)
REVISION	VARCHAR2	(3)
TRANSACTION_QUANTITY	NUMBER
TRANSACTION_UOM	VARCHAR2	(3)
LOCATOR	VARCHAR2	(4000)
PRIMARY_UOM_CODE	VARCHAR2	(3)
DEST_SUBINVENTORY	VARCHAR2	(10)
DEST_LOCATOR	NUMBER
REVISION_QTY_CONTROL_CODE	NUMBER
LOT_CONTROL_CODE	NUMBER
SERIAL_NUMBER_CONTROL_CODE	NUMBER
RESTRICT_SUBINVENTORIES_CODE	NUMBER
RESTRICT_LOCATORS_CODE	NUMBER
LOCATION_CONTROL_CODE	NUMBER
ALLOWED_UNITS_LOOKUP_CODE	NUMBER
BACKORDER_DELIVERY_DETAIL	NUMBER
CROSSDOCK_TYPE	NUMBER
WIP_SUPPLY_TYPE	NUMBER
FROM_SUBINVENTORY	VARCHAR2	(10)
FROM_LOCATOR	NUMBER
TRANSFER_SUBINVENTORY	VARCHAR2	(10)
TRANSFER_TO_LOCATION	NUMBER
TRANSFER_ORGANIZATION	NUMBER
TRANSACTION_ACTION_ID	NUMBER
REFERENCE	VARCHAR2	(240)
LOC_DROPPING_ORDER	NUMBER
SUB_DROPPING_ORDER	NUMBER
ROW_TYPE	VARCHAR2	(15)
MOVE_ORDER_LINE_ID	NUMBER
PROJECT_ID	NUMBER
TASK_ID	NUMBER
TXN_SOURCE_ID	NUMBER
PRIMARY_QUANTITY	NUMBER
PROCESS_FLAG	VARCHAR2	(15)
LPN_LEVEL	NUMBER
WIP_JOB	VARCHAR2	(240)
WIP_LINE	VARCHAR2	(10)
WIP_DEPT	VARCHAR2	(10)
WIP_OP_SEQ	NUMBER
WIP_ENTITY_TYPE	NUMBER
WIP_START_DATE	DATE
WIP_SCHEDULE	VARCHAR2	(40)
WIP_ASSEMBLY	VARCHAR2	(240)
SECONDARY_QUANTITY	NUMBER
SECONDARY_UOM	VARCHAR2	(25)
INSPECTION_STATUS	NUMBER
SHOW_MESSAGE	NUMBER
ERROR_CODE	VARCHAR2	(240)
ERROR_EXPLANATION	VARCHAR2	(240)
SUB_LPN_CONTROLLED_FLAG	NUMBER
CONSOLIDATION_METHOD_ID	NUMBER
DROP_LPN_OPTION	NUMBER

Query Text

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


SELECT ORGANIZATION_ID
,      TRANSACTION_TEMP_ID
,      TRANSACTION_HEADER_ID
,      LPN_ID
,      LPN_NAME
,      LPN_CONTEXT
,      PARENT_LPN_ID
,      PARENT_LPN_NAME
,      OUTERMOST_LPN_ID
,      OUTERMOST_LPN_NAME
,      CONSOLIDATED_LPN_ID
,      CONSOLIDATED_LPN_NAME
,      INTO_LPN_ID
,      INTO_LPN_NAME
,      DROP_TYPE
,      DROP_ORDER
,      INVENTORY_ITEM_ID
,      ITEM
,      GROUP_ID
,      LOT_NUMBER
,      REVISION
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      LOCATOR
,      PRIMARY_UOM_CODE
,      DEST_SUBINVENTORY
,      DEST_LOCATOR
,      REVISION_QTY_CONTROL_CODE
,      LOT_CONTROL_CODE
,      SERIAL_NUMBER_CONTROL_CODE
,      RESTRICT_SUBINVENTORIES_CODE
,      RESTRICT_LOCATORS_CODE
,      LOCATION_CONTROL_CODE
,      ALLOWED_UNITS_LOOKUP_CODE
,      BACKORDER_DELIVERY_DETAIL
,      CROSSDOCK_TYPE
,      WIP_SUPPLY_TYPE
,      FROM_SUBINVENTORY
,      FROM_LOCATOR
,      TRANSFER_SUBINVENTORY
,      TRANSFER_TO_LOCATION
,      TRANSFER_ORGANIZATION
,      TRANSACTION_ACTION_ID
,      REFERENCE
,      LOC_DROPPING_ORDER
,      SUB_DROPPING_ORDER
,      ROW_TYPE
,      MOVE_ORDER_LINE_ID
,      PROJECT_ID
,      TASK_ID
,      TXN_SOURCE_ID
,      PRIMARY_QUANTITY
,      PROCESS_FLAG
,      LPN_LEVEL
,      WIP_JOB
,      WIP_LINE
,      WIP_DEPT
,      WIP_OP_SEQ
,      WIP_ENTITY_TYPE
,      WIP_START_DATE
,      WIP_SCHEDULE
,      WIP_ASSEMBLY
,      SECONDARY_QUANTITY
,      SECONDARY_UOM
,      INSPECTION_STATUS
,      SHOW_MESSAGE
,      ERROR_CODE
,      ERROR_EXPLANATION
,      SUB_LPN_CONTROLLED_FLAG
,      CONSOLIDATION_METHOD_ID
,      DROP_LPN_OPTION
FROM WMS.WMS_PUTAWAY_GROUP_TASKS_GTMP;

Dependencies

[top of page]

WMS.WMS_PUTAWAY_GROUP_TASKS_GTMP does not reference any database object

WMS.WMS_PUTAWAY_GROUP_TASKS_GTMP is referenced by following:

APPS: WMS_PUTAWAY_GROUP_TASKS_GTMP