[Home] [Help] [Dependency Information]

TABLE: WMS.WMS_WAVEPLAN_TASKS_TEMP

Object Details

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

Temporary Table Details

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

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_WAVEPLAN_TASKS_TEMP_N1	NORMAL	NONUNIQUE		TRANSACTION_TEMP_ID TASK_TYPE_ID
WMS_WAVEPLAN_TASKS_TEMP_N2	NORMAL	NONUNIQUE		RESULT

Columns

Query Text

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

SELECT TASK_ID
,      TRANSACTION_TEMP_ID
,      PARENT_LINE_ID
,      INVENTORY_ITEM_ID
,      ITEM
,      ITEM_DESCRIPTION
,      UNIT_WEIGHT
,      WEIGHT_UOM_CODE
,      DISPLAY_WEIGHT
,      UNIT_VOLUME
,      VOLUME_UOM_CODE
,      DISPLAY_VOLUME
,      TIME_ESTIMATE
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      REVISION
,      SUBINVENTORY
,      LOCATOR_ID
,      LOCATOR
,      TRANSACTION_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE_TYPE
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_LINE_ID
,      TO_ORGANIZATION_ID
,      TO_ORGANIZATION_CODE
,      TO_SUBINVENTORY
,      TO_LOCATOR_ID
,      TO_LOCATOR
,      TRANSACTION_UOM
,      TRANSACTION_QUANTITY
,      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
,      MACHINE_RESOURCE_ID
,      MACHINE_RESOURCE_CODE
,      EQUIPMENT_INSTANCE
,      STATUS_ID
,      STATUS_ID_ORIGINAL
,      STATUS
,      CREATION_TIME
,      DISPATCHED_TIME
,      LOADED_TIME
,      DROP_OFF_TIME
,      MMTT_LAST_UPDATE_DATE
,      MMTT_LAST_UPDATED_BY
,      WDT_LAST_UPDATE_DATE
,      WDT_LAST_UPDATED_BY
,      PRIORITY
,      PRIORITY_ORIGINAL
,      TASK_TYPE_ID
,      TASK_TYPE
,      MOVE_ORDER_LINE_ID
,      PICK_SLIP_NUMBER
,      CARTONIZATION_ID
,      ALLOCATED_LPN_ID
,      CONTAINER_ITEM_ID
,      CONTENT_LPN_ID
,      TO_LPN_ID
,      CONTAINER_ITEM
,      CARTONIZATION_LPN
,      ALLOCATED_LPN
,      CONTENT_LPN
,      TO_LPN
,      REFERENCE
,      REFERENCE_ID
,      CUSTOMER_ID
,      CUSTOMER
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_STATE
,      SHIP_TO_COUNTRY
,      SHIP_TO_POSTAL_CODE
,      DELIVERY_ID
,      DELIVERY
,      SHIP_METHOD
,      CARRIER_ID
,      CARRIER
,      SHIPMENT_DATE
,      SHIPMENT_PRIORITY
,      WIP_ENTITY_TYPE
,      WIP_ENTITY_ID
,      ASSEMBLY_ID
,      ASSEMBLY
,      LINE_ID
,      LINE
,      DEPARTMENT_ID
,      DEPARTMENT
,      SOURCE_HEADER
,      LINE_NUMBER
,      OPERATION_PLAN_ID
,      OPERATION_PLAN
,      RESULT
,      ERROR
,      IS_MODIFIED
,      FROM_LPN_ID
,      FROM_LPN
,      NUM_OF_CHILD_TASKS
,      EXPANSION_CODE
,      PLANS_TASKS
,      OP_PLAN_INSTANCE_ID
,      OPERATION_SEQUENCE
,      SECONDARY_TRANSACTION_QUANTITY
,      SECONDARY_TRANSACTION_UOM
,      PRIMARY_PRODUCT
,      TRANSACTION_SET_ID
,      PICKED_LPN_ID
,      PICKED_LPN
,      LOADED_LPN
,      LOADED_LPN_ID
,      DROP_LPN
,      LOAD_SEQ_NUMBER
,      WAVE_HEADER_ID
,      TRIP_ID
,      TRIP_NAME
FROM WMS.WMS_WAVEPLAN_TASKS_TEMP;

Dependencies

[top of page]

WMS.WMS_WAVEPLAN_TASKS_TEMP does not reference any database object

WMS.WMS_WAVEPLAN_TASKS_TEMP is referenced by following:

APPS

WMS_WAVEPLAN_TASKS_TEMP