[Home] [Help]
View: 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
Name |
ORGANIZATION_ID |
TASK_ID |
REASON_ID |
REASON_NAME |
REASON_DESCRIPTION |
EXCEPTION_TIME |
PERSON_ID |
FULL_NAME |
SUBINVENTORY_CODE |
LOCATOR_ID |
LOCATOR |
INVENTORY_ITEM_ID |
ITEM |