View: MRP_WORKBENCH_MESSAGES_V

Product:	MRP - Master Scheduling/MRP
Description:	MRP or MPS exception messages
Implementation/DBA Data:	APPS.MRP_WORKBENCH_MESSAGES_V

View Text

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

Columns