View: WMS_WP_TASKS_GTMP_V

Product:	WMS - Warehouse Management
Description:
Implementation/DBA Data:	APPS.WMS_WP_TASKS_GTMP_V

View Text

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 WMS_WP_TASKS_GTMP