VIEW: APPS.MRP_WORKBENCH_MESSAGES_V

Source

View Text - Preformatted

SELECT ROWID , QUERY_ID , NUMBER1 , NUMBER2 , CHAR1 , NUMBER3 , NUMBER15 , CHAR8 , TO_NUMBER(NULL) , TO_CHAR(NULL) , 1 , TO_CHAR(NULL) , TO_NUMBER(NULL) FROM MRP_FORM_QUERY UNION ALL SELECT MIE.ROWID, TO_NUMBER(NULL) , MIE.EXCEPTION_TYPE , 1 , L1.MEANING , TO_NUMBER(NULL) , MSI.ORGANIZATION_ID , MSI.COMPILE_DESIGNATOR , MSI.INVENTORY_ITEM_ID , KFV.ITEM_NUMBER || ' '|| KFV.DESCRIPTION , 3 , MSI.PLANNER_CODE, MIE.DISPLAY FROM MFG_LOOKUPS L1 , MRP_ITEM_EXCEPTIONS MIE , MTL_ITEM_FLEXFIELDS KFV , MRP_SYSTEM_ITEMS MSI WHERE L1.LOOKUP_TYPE = 'MRP_EXCEPTION_TYPE' AND L1.LOOKUP_CODE = MIE.EXCEPTION_TYPE AND KFV.ORGANIZATION_ID = MIE.ORGANIZATION_ID AND KFV.INVENTORY_ITEM_ID = MIE.INVENTORY_ITEM_ID AND MIE.EXCEPTION_TYPE <> 5 AND MIE.DISPLAY = 1 AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIE.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR AND MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID UNION ALL SELECT DISTINCT MSI.ROWID, TO_NUMBER(NULL) , TO_NUMBER(NULL) , 1 , TO_CHAR(NULL) , TO_NUMBER(NULL) , MSI.ORGANIZATION_ID , MSI.COMPILE_DESIGNATOR , MSI.INVENTORY_ITEM_ID , KFV.ITEM_NUMBER || ' '|| KFV.DESCRIPTION , 2 , MSI.PLANNER_CODE , TO_NUMBER(NULL) FROM MTL_ITEM_FLEXFIELDS KFV , MRP_ITEM_EXCEPTIONS MIE , MRP_SYSTEM_ITEMS MSI WHERE KFV.ORGANIZATION_ID = MIE.ORGANIZATION_ID AND KFV.INVENTORY_ITEM_ID = MIE.INVENTORY_ITEM_ID AND MIE.EXCEPTION_TYPE <> 5 AND MIE.DISPLAY = 1 AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIE.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR AND MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID

View Text - HTML Formatted

SELECT ROWID
, QUERY_ID
, NUMBER1
, NUMBER2
, CHAR1
, NUMBER3
, NUMBER15
, CHAR8
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, 1
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
FROM MRP_FORM_QUERY UNION ALL SELECT MIE.ROWID
, TO_NUMBER(NULL)
, MIE.EXCEPTION_TYPE
, 1
, L1.MEANING
, TO_NUMBER(NULL)
, MSI.ORGANIZATION_ID
, MSI.COMPILE_DESIGNATOR
, MSI.INVENTORY_ITEM_ID
, KFV.ITEM_NUMBER || ' '|| KFV.DESCRIPTION
, 3
, MSI.PLANNER_CODE
, MIE.DISPLAY
FROM MFG_LOOKUPS L1
, MRP_ITEM_EXCEPTIONS MIE
, MTL_ITEM_FLEXFIELDS KFV
, MRP_SYSTEM_ITEMS MSI
WHERE L1.LOOKUP_TYPE = 'MRP_EXCEPTION_TYPE'
AND L1.LOOKUP_CODE = MIE.EXCEPTION_TYPE
AND KFV.ORGANIZATION_ID = MIE.ORGANIZATION_ID
AND KFV.INVENTORY_ITEM_ID = MIE.INVENTORY_ITEM_ID
AND MIE.EXCEPTION_TYPE <> 5
AND MIE.DISPLAY = 1
AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MIE.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR
AND MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID UNION ALL SELECT DISTINCT MSI.ROWID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, 1
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, MSI.ORGANIZATION_ID
, MSI.COMPILE_DESIGNATOR
, MSI.INVENTORY_ITEM_ID
, KFV.ITEM_NUMBER || ' '|| KFV.DESCRIPTION
, 2
, MSI.PLANNER_CODE
, TO_NUMBER(NULL)
FROM MTL_ITEM_FLEXFIELDS KFV
, MRP_ITEM_EXCEPTIONS MIE
, MRP_SYSTEM_ITEMS MSI
WHERE KFV.ORGANIZATION_ID = MIE.ORGANIZATION_ID
AND KFV.INVENTORY_ITEM_ID = MIE.INVENTORY_ITEM_ID
AND MIE.EXCEPTION_TYPE <> 5
AND MIE.DISPLAY = 1
AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MIE.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR
AND MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID