View: WMS_WAVEPLAN_TASK_EXCEPTIONS_V

Product:	WMS - Warehouse Management
Description:	WMS Wave Planning Task Exceptions View
Implementation/DBA Data:	APPS.WMS_WAVEPLAN_TASK_EXCEPTIONS_V

View Text

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

Columns