Product: | WMS - Warehouse Management |
---|---|
Description: | WMS Wave Planning Task View |
Implementation/DBA Data: | APPS.WMS_WAVEPLAN_TASKS_V |
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