VIEW: APPS.WMS_WP_TASKS_GTMP_V

Source

View Text - Preformatted

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
   
   

View Text - HTML Formatted

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