DBA Data[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: TableWMS.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: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
WMS_WAVEPLAN_TASKS_TEMP_N1 NORMAL NONUNIQUE Tablespace ColumnTRANSACTION_TEMP_ID
ColumnTASK_TYPE_ID
WMS_WAVEPLAN_TASKS_TEMP_N2 NORMAL NONUNIQUE Tablespace ColumnRESULT
Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER

TRANSACTION_TEMP_ID NUMBER

PARENT_LINE_ID NUMBER

INVENTORY_ITEM_ID NUMBER

ITEM VARCHAR2 (240)
ITEM_DESCRIPTION VARCHAR2 (240)
UNIT_WEIGHT NUMBER

WEIGHT_UOM_CODE VARCHAR2 (3)
DISPLAY_WEIGHT NUMBER

UNIT_VOLUME NUMBER

VOLUME_UOM_CODE VARCHAR2 (3)
DISPLAY_VOLUME NUMBER

TIME_ESTIMATE NUMBER

ORGANIZATION_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (3)
REVISION VARCHAR2 (3)
SUBINVENTORY VARCHAR2 (10)
LOCATOR_ID NUMBER

LOCATOR VARCHAR2 (240)
TRANSACTION_TYPE_ID NUMBER

TRANSACTION_ACTION_ID NUMBER

TRANSACTION_SOURCE_TYPE_ID NUMBER

TRANSACTION_SOURCE_TYPE VARCHAR2 (240)
TRANSACTION_SOURCE_ID NUMBER

TRANSACTION_SOURCE_LINE_ID NUMBER

TO_ORGANIZATION_ID NUMBER

TO_ORGANIZATION_CODE VARCHAR2 (3)
TO_SUBINVENTORY VARCHAR2 (10)
TO_LOCATOR_ID NUMBER

TO_LOCATOR VARCHAR2 (204)
TRANSACTION_UOM VARCHAR2 (3)
TRANSACTION_QUANTITY NUMBER

USER_TASK_TYPE_ID NUMBER

USER_TASK_TYPE VARCHAR2 (4)
PERSON_ID NUMBER

PERSON_ID_ORIGINAL NUMBER

PERSON VARCHAR2 (240)
EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

PERSON_RESOURCE_ID NUMBER

PERSON_RESOURCE_CODE VARCHAR2 (10)
MACHINE_RESOURCE_ID NUMBER

MACHINE_RESOURCE_CODE VARCHAR2 (10)
EQUIPMENT_INSTANCE VARCHAR2 (30)
STATUS_ID NUMBER

STATUS_ID_ORIGINAL NUMBER

STATUS VARCHAR2 (80)
CREATION_TIME DATE

DISPATCHED_TIME DATE

LOADED_TIME DATE

DROP_OFF_TIME DATE

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)
MOVE_ORDER_LINE_ID NUMBER

PICK_SLIP_NUMBER NUMBER

CARTONIZATION_ID NUMBER

ALLOCATED_LPN_ID NUMBER

CONTAINER_ITEM_ID NUMBER

CONTENT_LPN_ID NUMBER

TO_LPN_ID NUMBER

CONTAINER_ITEM VARCHAR2 (240)
CARTONIZATION_LPN VARCHAR2 (30)
ALLOCATED_LPN VARCHAR2 (30)
CONTENT_LPN VARCHAR2 (30)
TO_LPN VARCHAR2 (30)
REFERENCE VARCHAR2 (240)
REFERENCE_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER VARCHAR2 (240)
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_STATE VARCHAR2 (60)
SHIP_TO_COUNTRY VARCHAR2 (60)
SHIP_TO_POSTAL_CODE VARCHAR2 (60)
DELIVERY_ID NUMBER

DELIVERY VARCHAR2 (30)
SHIP_METHOD VARCHAR2 (80)
CARRIER_ID NUMBER

CARRIER VARCHAR2 (360)
SHIPMENT_DATE DATE

SHIPMENT_PRIORITY VARCHAR2 (80)
WIP_ENTITY_TYPE NUMBER

WIP_ENTITY_ID NUMBER

ASSEMBLY_ID NUMBER

ASSEMBLY VARCHAR2 (240)
LINE_ID NUMBER

LINE VARCHAR2 (10)
DEPARTMENT_ID NUMBER

DEPARTMENT VARCHAR2 (10)
SOURCE_HEADER VARCHAR2 (240)
LINE_NUMBER VARCHAR2 (240)
OPERATION_PLAN_ID NUMBER

OPERATION_PLAN VARCHAR2 (255)
RESULT VARCHAR2 (1)
ERROR VARCHAR2 (240)
IS_MODIFIED VARCHAR2 (1)
FROM_LPN_ID NUMBER

FROM_LPN VARCHAR2 (30)
NUM_OF_CHILD_TASKS NUMBER

EXPANSION_CODE VARCHAR2 (1)
PLANS_TASKS VARCHAR2 (80)
OP_PLAN_INSTANCE_ID NUMBER

OPERATION_SEQUENCE NUMBER

SECONDARY_TRANSACTION_QUANTITY NUMBER

SECONDARY_TRANSACTION_UOM VARCHAR2 (3)
PRIMARY_PRODUCT VARCHAR2 (240)
TRANSACTION_SET_ID NUMBER

PICKED_LPN_ID NUMBER

PICKED_LPN VARCHAR2 (30)
LOADED_LPN VARCHAR2 (30)
LOADED_LPN_ID NUMBER

DROP_LPN VARCHAR2 (30)
LOAD_SEQ_NUMBER NUMBER

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
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:

SchemaAPPS
SynonymWMS_WAVEPLAN_TASKS_TEMP