VIEW: APPS.WMS_WAVEPLAN_TASK_EXCEPTIONS_V

Source

View Text - Preformatted

SELECT we.organization_id, we.task_id, we.reason_id, mtr.reason_name, mtr.description reason_description, we.creation_date exception_time, we.person_id, pap.full_name, we.subinventory_code, we.inventory_location_id locator_id, milv.concatenated_segments locator, we.inventory_item_id, msiv.concatenated_segments item FROM wms_exceptions we, mtl_transaction_reasons mtr, per_all_people_f pap, mtl_item_locations_kfv milv, mtl_system_items_kfv msiv WHERE we.reason_id = mtr.reason_id AND we.inventory_location_id = milv.inventory_location_id AND we.organization_id = milv.organization_id AND pap.person_id = we.person_id AND pap.effective_start_date <= we.creation_date AND pap.effective_end_date >= we.creation_date AND msiv.organization_id = milv.organization_id AND msiv.inventory_item_id = we.inventory_item_id

View Text - HTML Formatted

SELECT WE.ORGANIZATION_ID
, WE.TASK_ID
, WE.REASON_ID
, MTR.REASON_NAME
, MTR.DESCRIPTION REASON_DESCRIPTION
, WE.CREATION_DATE EXCEPTION_TIME
, WE.PERSON_ID
, PAP.FULL_NAME
, WE.SUBINVENTORY_CODE
, WE.INVENTORY_LOCATION_ID LOCATOR_ID
, MILV.CONCATENATED_SEGMENTS LOCATOR
, WE.INVENTORY_ITEM_ID
, MSIV.CONCATENATED_SEGMENTS ITEM
FROM WMS_EXCEPTIONS WE
, MTL_TRANSACTION_REASONS MTR
, PER_ALL_PEOPLE_F PAP
, MTL_ITEM_LOCATIONS_KFV MILV
, MTL_SYSTEM_ITEMS_KFV MSIV
WHERE WE.REASON_ID = MTR.REASON_ID
AND WE.INVENTORY_LOCATION_ID = MILV.INVENTORY_LOCATION_ID
AND WE.ORGANIZATION_ID = MILV.ORGANIZATION_ID
AND PAP.PERSON_ID = WE.PERSON_ID
AND PAP.EFFECTIVE_START_DATE <= WE.CREATION_DATE
AND PAP.EFFECTIVE_END_DATE >= WE.CREATION_DATE
AND MSIV.ORGANIZATION_ID = MILV.ORGANIZATION_ID
AND MSIV.INVENTORY_ITEM_ID = WE.INVENTORY_ITEM_ID