[Home] [Help] [Dependency Information]
Object Name: | WMS_WAVEPLAN_TASKS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WMS.WMS_WAVEPLAN_TASKS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
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 |
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 APPS.WMS_WAVEPLAN_TASKS_V;
APPS.WMS_WAVEPLAN_TASKS_V is not referenced by any database object
|
|
|