[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

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