View: BOM_RTG_CURRENT_REV_VIEW

Product:	BOM - Bills of Material
Description:	Routing current revisions
Implementation/DBA Data:	APPS.BOM_RTG_CURRENT_REV_VIEW

View Text

SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, PROCESS_REVISION
, EFFECTIVITY_DATE
FROM MTL_RTG_ITEM_REVISIONS MRIR
WHERE EFFECTIVITY_DATE = (SELECT MAX(EFFECTIVITY_DATE)
FROM MTL_RTG_ITEM_REVISIONS
WHERE ORGANIZATION_ID = MRIR.ORGANIZATION_ID
AND INVENTORY_ITEM_ID = MRIR.INVENTORY_ITEM_ID
AND EFFECTIVITY_DATE <= SYSDATE)
AND PROCESS_REVISION = (SELECT MAX(PROCESS_REVISION)
FROM MTL_RTG_ITEM_REVISIONS
WHERE ORGANIZATION_ID = MRIR.ORGANIZATION_ID
AND INVENTORY_ITEM_ID = MRIR.INVENTORY_ITEM_ID
AND EFFECTIVITY_DATE = MRIR.EFFECTIVITY_DATE)

Columns