VIEW: APPS.WMS_WAVEPLAN_TASKS_V

Source

View Text - Preformatted

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 WMS_WAVEPLAN_TASKS_TEMP

View Text - HTML Formatted

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 WMS_WAVEPLAN_TASKS_TEMP