[Home] [Help] [Dependency Information]
Object Name: | WMS_WP_TASKS_GTMP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WMS.WMS_WP_TASKS_GTMP_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_ID | NUMBER | |||
TO_LPN | VARCHAR2 | (30) | ||
TO_LPN_ID | NUMBER | |||
TRANSACTION_TEMP_ID | NUMBER | |||
TRANSACTION_TYPE_ID | NUMBER | |||
TRANSACTION_ACTION_ID | NUMBER | |||
TRANSACTION_SOURCE_TYPE_ID | NUMBER | |||
TRANSACTION_SOURCE_ID | NUMBER | |||
TRANSACTION_SOURCE_LINE_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
TO_ORGANIZATION_ID | NUMBER | |||
TO_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
TO_SUBINVENTORY | VARCHAR2 | (30) | ||
TO_LOCATOR_ID | NUMBER | |||
TO_LOCATOR | VARCHAR2 | (40) | ||
USER_TASK_TYPE_ID | NUMBER | |||
USER_TASK_TYPE | VARCHAR2 | (4) | ||
PERSON_ID | NUMBER | |||
PERSON_ID_ORIGINAL | NUMBER | |||
PERSON | VARCHAR2 | (120) | ||
EFFECTIVE_START_DATE | DATE | |||
EFFECTIVE_END_DATE | DATE | |||
PERSON_RESOURCE_ID | NUMBER | |||
PERSON_RESOURCE_CODE | VARCHAR2 | (10) | ||
STATUS_ID | NUMBER | |||
STATUS_ID_ORIGINAL | NUMBER | |||
STATUS | VARCHAR2 | (80) | ||
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) | ||
IS_MODIFIED | VARCHAR2 | (1) | ||
PLAN_TASK | VARCHAR2 | (100) | ||
RESULT | VARCHAR2 | (1) | ||
ERROR | VARCHAR2 | (2000) | ||
SOURCE_HEADER | VARCHAR2 | (150) | ||
LINE_NUMBER | VARCHAR2 | (50) | ||
ITEM | VARCHAR2 | (200) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
REVISION | VARCHAR2 | (3) | ||
SUBINVENTORY | VARCHAR2 | (30) | ||
LOCATOR | VARCHAR2 | (40) | ||
SECONDARY_QUANTITY | NUMBER | |||
SECONDARY_UOM | VARCHAR2 | (3) | ||
OPERATION_PLAN_ID | NUMBER | |||
OPERATION_PLAN | VARCHAR2 | (255) | ||
OPERATION_SEQUENCE | VARCHAR2 | (100) | ||
OPERATION_PLAN_INSTANCE | VARCHAR2 | (100) | ||
SHIP_METHOD | VARCHAR2 | (100) | ||
SHIPMENT_DATE | DATE | |||
SHIPMENT_PRIORITY | VARCHAR2 | (100) | ||
DEPARTMENT | VARCHAR2 | (100) | ||
CHILD_TASKS | VARCHAR2 | (100) | ||
NUM_OF_CHILD_TASKS | NUMBER | |||
ALLOCATED_LPN | VARCHAR2 | (30) | ||
CARTONIZED_LPN | VARCHAR2 | (30) | ||
CONTAINER_ITEM | VARCHAR2 | (30) | ||
CONTENT_LPN | VARCHAR2 | (30) | ||
DISPATCHED_TIME | DATE | |||
EQUIPMENT | NUMBER | |||
FROM_LPN | VARCHAR2 | (30) | ||
PARENT_LINE_ID | NUMBER | |||
MOVE_ORDER_LINE_ID | NUMBER | |||
PICK_SLIP_NUMBER | NUMBER | |||
PICKED_LPN | VARCHAR2 | (30) | ||
TRANSACTION_UOM | VARCHAR2 | (3) | ||
TRANSACTION_QUANTITY | NUMBER |
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 APPS.WMS_WP_TASKS_GTMP_V;
APPS.WMS_WP_TASKS_GTMP_V is not referenced by any database object
|
|
|