DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.WMS_WAVEPLAN_TASKS_V

Object Details
Object Name: WMS_WAVEPLAN_TASKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_WAVEPLAN_TASKS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER

Task Identifier
TRANSACTION_TEMP_ID NUMBER

Transaction line identifier used to join to lot or serial table when under these controls
PARENT_LINE_ID NUMBER

Parent Transaction Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Id
ITEM VARCHAR2 (240)
Item Name
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
UNIT_WEIGHT NUMBER

Conversion between weight unit of measure and base unit of measure
WEIGHT_UOM_CODE VARCHAR2 (3)
Weight unit of measure code
DISPLAY_WEIGHT NUMBER

Display Weight
UNIT_VOLUME NUMBER

Conversion between volume unit of measure and base unit of measure
VOLUME_UOM_CODE VARCHAR2 (3)
Volume Unit of Measure Code
DISPLAY_VOLUME NUMBER

Display Volume
TIME_ESTIMATE NUMBER

Time estimate for Task
ORGANIZATION_ID NUMBER

Organization Identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
REVISION VARCHAR2 (3)
Revision of the item
SUBINVENTORY VARCHAR2 (10)
Subinventory
LOCATOR_ID NUMBER

Locator id
LOCATOR VARCHAR2 (240)
Locator name
TRANSACTION_TYPE_ID NUMBER

Transaction type identifier
TRANSACTION_ACTION_ID NUMBER

Transaction action identifier
TRANSACTION_SOURCE_TYPE_ID NUMBER

Transaction source type identifier
TRANSACTION_SOURCE_TYPE VARCHAR2 (240)
Transaction Source Type
TRANSACTION_SOURCE_ID NUMBER

Transaction Source Identifier
TRANSACTION_SOURCE_LINE_ID NUMBER

Transaction Source Line Id
TO_ORGANIZATION_ID NUMBER

To Organization Id
TO_ORGANIZATION_CODE VARCHAR2 (3)
To Organization Code
TO_SUBINVENTORY VARCHAR2 (10)
To Subinventory
TO_LOCATOR_ID NUMBER

To Locator Id
TO_LOCATOR VARCHAR2 (204)
To Locator
TRANSACTION_UOM VARCHAR2 (3)
Transaction unit of measure
TRANSACTION_QUANTITY NUMBER

Transaction Quantity
USER_TASK_TYPE_ID NUMBER

Identifier for Standard Operation Id of the task being performed
USER_TASK_TYPE VARCHAR2 (4)
Standard Operation ID of the task being performed
PERSON_ID NUMBER

Employee Number of the person performing the task
PERSON_ID_ORIGINAL NUMBER

Original Person Id Performing Task
PERSON VARCHAR2 (240)
Name of the employee
EFFECTIVE_START_DATE DATE

Effective start date
EFFECTIVE_END_DATE DATE

Effective end date
PERSON_RESOURCE_ID NUMBER

Resource Id of the person performing the task
PERSON_RESOURCE_CODE VARCHAR2 (10)
Resource code of the person performing the task
MACHINE_RESOURCE_ID NUMBER

Resource Id of the equipment being used to perform the task
MACHINE_RESOURCE_CODE VARCHAR2 (10)
Resource code of the equipment being used to perform the task
EQUIPMENT_INSTANCE VARCHAR2 (30)
Serial Number of the Equipment being used to perform the task
STATUS_ID NUMBER

Status Identifier
STATUS_ID_ORIGINAL NUMBER

Original Status Id
STATUS VARCHAR2 (80)
Status of the Tasks
CREATION_TIME DATE

Tasks Creation Time
DISPATCHED_TIME DATE

Dispatched Time
LOADED_TIME DATE

Loaded Time
DROP_OFF_TIME DATE

Drop Off Time
MMTT_LAST_UPDATE_DATE DATE

Standard Who Column for MMTT record
MMTT_LAST_UPDATED_BY NUMBER

Standard Who Column for MMTT record
WDT_LAST_UPDATE_DATE DATE

Standard Who Column for WDT
WDT_LAST_UPDATED_BY NUMBER

Standard Who Column for WDT
PRIORITY NUMBER

Priority of the tasks
PRIORITY_ORIGINAL NUMBER

Previous priority of the task
TASK_TYPE_ID NUMBER

Task Type Identifier
TASK_TYPE VARCHAR2 (80)
SYSTEM TASK TYPE - FROM WMS_TASK_TYPES LOOKUP
MOVE_ORDER_LINE_ID NUMBER

Move order line Id
PICK_SLIP_NUMBER NUMBER

Pick Slip Number
CARTONIZATION_ID NUMBER

Cartonization Identifier
ALLOCATED_LPN_ID NUMBER

Allocated LPN Id
CONTAINER_ITEM_ID NUMBER

Item id for suggested container item for this line - used by WMS only
CONTENT_LPN_ID NUMBER

Content LPN Id
TO_LPN_ID NUMBER

To LPN Id
CONTAINER_ITEM VARCHAR2 (240)
Container Item
CARTONIZATION_LPN VARCHAR2 (30)
Catonization LPN
ALLOCATED_LPN VARCHAR2 (30)
Allocated LPN
CONTENT_LPN VARCHAR2 (30)
Content LPN
TO_LPN VARCHAR2 (30)
To LPN
REFERENCE VARCHAR2 (240)
Reference
REFERENCE_ID NUMBER

Reference Id
CUSTOMER_ID NUMBER

Customer Id
CUSTOMER VARCHAR2 (240)
Customer Name
SHIP_TO_LOCATION_ID NUMBER

Ship To Location Id
SHIP_TO_STATE VARCHAR2 (60)
Ship to the state
SHIP_TO_COUNTRY VARCHAR2 (60)
Ship to Country
SHIP_TO_POSTAL_CODE VARCHAR2 (60)
Ship to Postal Code
DELIVERY_ID NUMBER

Delivery Id
DELIVERY VARCHAR2 (30)
Delivery
SHIP_METHOD VARCHAR2 (80)
Ship method
CARRIER_ID NUMBER

Carrier Id
CARRIER VARCHAR2 (360)
Carrier Name
SHIPMENT_DATE DATE

Shipment Date
SHIPMENT_PRIORITY VARCHAR2 (80)
Priority for the Shipment
WIP_ENTITY_TYPE NUMBER

WIP Job Entity Type
WIP_ENTITY_ID NUMBER

WIP Job Identifier
ASSEMBLY_ID NUMBER

Assembly Id
ASSEMBLY VARCHAR2 (240)
Assembly
LINE_ID NUMBER

Line Id for the Task
LINE VARCHAR2 (10)
Line Number
DEPARTMENT_ID NUMBER

Department Id
DEPARTMENT VARCHAR2 (10)
Department Name
SOURCE_HEADER VARCHAR2 (240)
Source Header
LINE_NUMBER VARCHAR2 (240)
Line Number
OPERATION_PLAN_ID NUMBER

Operation Plan Id
OPERATION_PLAN VARCHAR2 (255)
Operation Plan Name
RESULT VARCHAR2 (1)
Result
ERROR VARCHAR2 (240)
Error Code
IS_MODIFIED VARCHAR2 (1)
Is record modified
FROM_LPN_ID NUMBER

From LPN Id
FROM_LPN VARCHAR2 (30)
From LPN
NUM_OF_CHILD_TASKS NUMBER

Number of Child Taks
EXPANSION_CODE VARCHAR2 (1)
Expansion Code
PLANS_TASKS VARCHAR2 (80)
Plan Task Flag
OP_PLAN_INSTANCE_ID NUMBER

Operation Plan Instance Id
OPERATION_SEQUENCE NUMBER

Operation Sequence
SECONDARY_TRANSACTION_QUANTITY NUMBER

Transaction Qty in the secondary UOM
SECONDARY_TRANSACTION_UOM VARCHAR2 (3)
Secondary Transaction UOM
PRIMARY_PRODUCT VARCHAR2 (240)
Primary Product
TRANSACTION_SET_ID NUMBER

Transaction Set Id
PICKED_LPN_ID NUMBER

Picked LPN Id
PICKED_LPN VARCHAR2 (30)
Picked LPN
LOADED_LPN VARCHAR2 (30)
Loaded LPN
LOADED_LPN_ID NUMBER

Loaded LPN Id
DROP_LPN VARCHAR2 (30)
Drop LPN
LOAD_SEQ_NUMBER NUMBER

Loading Sequence Number
WAVE_HEADER_ID NUMBER

TRIP_ID NUMBER

TRIP_NAME VARCHAR2 (32)
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 APPS.WMS_WAVEPLAN_TASKS_V;

Dependencies

[top of page]

APPS.WMS_WAVEPLAN_TASKS_V references the following:

SchemaAPPS
SynonymWMS_WAVEPLAN_TASKS_TEMP

APPS.WMS_WAVEPLAN_TASKS_V is not referenced by any database object