eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MTL_ITEM_REVISIONS_ORG_VAL_V

Source

View Text - Preformatted


SELECT MIR.REVISION , MIR.ORGANIZATION_ID , MIR.INVENTORY_ITEM_ID FROM ORG_ORGANIZATION_DEFINITIONS OOD, MTL_ITEM_REVISIONS 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

View Text - HTML Formatted

SELECT MIR.REVISION
, MIR.ORGANIZATION_ID
, MIR.INVENTORY_ITEM_ID
FROM ORG_ORGANIZATION_DEFINITIONS OOD
, MTL_ITEM_REVISIONS 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