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.

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on MTL_ITEM_REVISIONS_B

Line 3882: FROM MTL_ITEM_REVISIONS_B

3878: , p_rev IN VARCHAR2
3879: )
3880: IS
3881: SELECT REVISION_ID
3882: FROM MTL_ITEM_REVISIONS_B
3883: WHERE INVENTORY_ITEM_ID = p_item_id
3884: AND ORGANIZATION_ID = p_org_id
3885: AND REVISION = p_rev ;
3886:

Line 3949: FROM MTL_ITEM_REVISIONS_B rev_b

3945: , c_org_id IN NUMBER
3946: )
3947: IS
3948: SELECT rev_b.REVISION_ID
3949: FROM MTL_ITEM_REVISIONS_B rev_b
3950: WHERE rev_b.INVENTORY_ITEM_ID = c_item_id
3951: AND rev_b.ORGANIZATION_ID = c_org_id
3952: AND rev_b.REVISION = ( SELECT max(max_rev.revision)
3953: FROM MTL_ITEM_REVISIONS_B max_rev

Line 3953: FROM MTL_ITEM_REVISIONS_B max_rev

3949: FROM MTL_ITEM_REVISIONS_B rev_b
3950: WHERE rev_b.INVENTORY_ITEM_ID = c_item_id
3951: AND rev_b.ORGANIZATION_ID = c_org_id
3952: AND rev_b.REVISION = ( SELECT max(max_rev.revision)
3953: FROM MTL_ITEM_REVISIONS_B max_rev
3954: WHERE max_rev.INVENTORY_ITEM_ID = rev_b.INVENTORY_ITEM_ID
3955: AND max_rev.ORGANIZATION_ID = rev_b.ORGANIZATION_ID
3956: ) ;
3957: