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_WP_TASKS_GTMP

Object Details

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

Temporary Table Details

WMS.WMS_WP_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
TASK_ID	NUMBER
TO_LPN	VARCHAR2	(30)
TO_LPN_ID	NUMBER
TRANSACTION_TEMP_ID	NUMBER
TRANSACTION_TYPE_ID	NUMBER
TRANSACTION_ACTION_ID	NUMBER
TRANSACTION_SOURCE_TYPE_ID	NUMBER
TRANSACTION_SOURCE_ID	NUMBER
TRANSACTION_SOURCE_LINE_ID	NUMBER
ORGANIZATION_ID	NUMBER
ORGANIZATION_CODE	VARCHAR2	(3)
TO_ORGANIZATION_ID	NUMBER
TO_ORGANIZATION_CODE	VARCHAR2	(3)
TO_SUBINVENTORY	VARCHAR2	(30)
TO_LOCATOR_ID	NUMBER
TO_LOCATOR	VARCHAR2	(40)
USER_TASK_TYPE_ID	NUMBER
USER_TASK_TYPE	VARCHAR2	(4)
PERSON_ID	NUMBER
PERSON_ID_ORIGINAL	NUMBER
PERSON	VARCHAR2	(120)
EFFECTIVE_START_DATE	DATE
EFFECTIVE_END_DATE	DATE
PERSON_RESOURCE_ID	NUMBER
PERSON_RESOURCE_CODE	VARCHAR2	(10)
STATUS_ID	NUMBER
STATUS_ID_ORIGINAL	NUMBER
STATUS	VARCHAR2	(80)
MMTT_LAST_UPDATE_DATE	DATE
MMTT_LAST_UPDATED_BY	NUMBER
WDT_LAST_UPDATE_DATE	DATE
WDT_LAST_UPDATED_BY	NUMBER
PRIORITY	NUMBER
PRIORITY_ORIGINAL	NUMBER
TASK_TYPE_ID	NUMBER
TASK_TYPE	VARCHAR2	(80)
IS_MODIFIED	VARCHAR2	(1)
PLAN_TASK	VARCHAR2	(100)
RESULT	VARCHAR2	(1)
ERROR	VARCHAR2	(2000)
SOURCE_HEADER	VARCHAR2	(150)
LINE_NUMBER	VARCHAR2	(50)
ITEM	VARCHAR2	(200)
ITEM_DESCRIPTION	VARCHAR2	(240)
REVISION	VARCHAR2	(3)
SUBINVENTORY	VARCHAR2	(30)
LOCATOR	VARCHAR2	(40)
SECONDARY_QUANTITY	NUMBER
SECONDARY_UOM	VARCHAR2	(3)
OPERATION_PLAN_ID	NUMBER
OPERATION_PLAN	VARCHAR2	(255)
OPERATION_SEQUENCE	VARCHAR2	(100)
OPERATION_PLAN_INSTANCE	VARCHAR2	(100)
SHIP_METHOD	VARCHAR2	(100)
SHIPMENT_DATE	DATE
SHIPMENT_PRIORITY	VARCHAR2	(100)
DEPARTMENT	VARCHAR2	(100)
CHILD_TASKS	VARCHAR2	(100)
NUM_OF_CHILD_TASKS	NUMBER
ALLOCATED_LPN	VARCHAR2	(30)
CARTONIZED_LPN	VARCHAR2	(30)
CONTAINER_ITEM	VARCHAR2	(30)
CONTENT_LPN	VARCHAR2	(30)
DISPATCHED_TIME	DATE
EQUIPMENT	NUMBER
FROM_LPN	VARCHAR2	(30)
PARENT_LINE_ID	NUMBER
MOVE_ORDER_LINE_ID	NUMBER
PICK_SLIP_NUMBER	NUMBER
PICKED_LPN	VARCHAR2	(30)
TRANSACTION_UOM	VARCHAR2	(3)
TRANSACTION_QUANTITY	NUMBER

Query Text

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


SELECT TASK_ID
,      TO_LPN
,      TO_LPN_ID
,      TRANSACTION_TEMP_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_LINE_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      TO_ORGANIZATION_ID
,      TO_ORGANIZATION_CODE
,      TO_SUBINVENTORY
,      TO_LOCATOR_ID
,      TO_LOCATOR
,      USER_TASK_TYPE_ID
,      USER_TASK_TYPE
,      PERSON_ID
,      PERSON_ID_ORIGINAL
,      PERSON
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PERSON_RESOURCE_ID
,      PERSON_RESOURCE_CODE
,      STATUS_ID
,      STATUS_ID_ORIGINAL
,      STATUS
,      MMTT_LAST_UPDATE_DATE
,      MMTT_LAST_UPDATED_BY
,      WDT_LAST_UPDATE_DATE
,      WDT_LAST_UPDATED_BY
,      PRIORITY
,      PRIORITY_ORIGINAL
,      TASK_TYPE_ID
,      TASK_TYPE
,      IS_MODIFIED
,      PLAN_TASK
,      RESULT
,      ERROR
,      SOURCE_HEADER
,      LINE_NUMBER
,      ITEM
,      ITEM_DESCRIPTION
,      REVISION
,      SUBINVENTORY
,      LOCATOR
,      SECONDARY_QUANTITY
,      SECONDARY_UOM
,      OPERATION_PLAN_ID
,      OPERATION_PLAN
,      OPERATION_SEQUENCE
,      OPERATION_PLAN_INSTANCE
,      SHIP_METHOD
,      SHIPMENT_DATE
,      SHIPMENT_PRIORITY
,      DEPARTMENT
,      CHILD_TASKS
,      NUM_OF_CHILD_TASKS
,      ALLOCATED_LPN
,      CARTONIZED_LPN
,      CONTAINER_ITEM
,      CONTENT_LPN
,      DISPATCHED_TIME
,      EQUIPMENT
,      FROM_LPN
,      PARENT_LINE_ID
,      MOVE_ORDER_LINE_ID
,      PICK_SLIP_NUMBER
,      PICKED_LPN
,      TRANSACTION_UOM
,      TRANSACTION_QUANTITY
FROM WMS.WMS_WP_TASKS_GTMP;

Dependencies

[top of page]

WMS.WMS_WP_TASKS_GTMP does not reference any database object

WMS.WMS_WP_TASKS_GTMP is referenced by following:

APPS: WMS_WP_TASKS_GTMP