View: MTL_ITEM_REVISIONS_ORG_VAL_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_ITEM_REVISIONS_ORG_VAL_V

View Text

SELECT MIR.REVISION
, MIR.REVISION_ID
, MIR.ORGANIZATION_ID
, MIR.INVENTORY_ITEM_ID
FROM ORG_ORGANIZATION_DEFINITIONS OOD
, MTL_ITEM_REVISIONS_B MIR
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE MIR.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND SYSDATE < NVL(OOD.DISABLE_DATE
, SYSDATE+1)
AND FSP.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID

Columns