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 3988: FROM MTL_ITEM_REVISIONS_B

3984: , p_rev IN VARCHAR2
3985: )
3986: IS
3987: SELECT REVISION_ID
3988: FROM MTL_ITEM_REVISIONS_B
3989: WHERE INVENTORY_ITEM_ID = p_item_id
3990: AND ORGANIZATION_ID = p_org_id
3991: AND REVISION = p_rev ;
3992:

Line 4055: FROM MTL_ITEM_REVISIONS_B rev_b

4051: , c_org_id IN NUMBER
4052: )
4053: IS
4054: SELECT rev_b.REVISION_ID
4055: FROM MTL_ITEM_REVISIONS_B rev_b
4056: WHERE rev_b.INVENTORY_ITEM_ID = c_item_id
4057: AND rev_b.ORGANIZATION_ID = c_org_id
4058: AND rev_b.REVISION = ( SELECT max(max_rev.revision)
4059: FROM MTL_ITEM_REVISIONS_B max_rev

Line 4059: FROM MTL_ITEM_REVISIONS_B max_rev

4055: FROM MTL_ITEM_REVISIONS_B rev_b
4056: WHERE rev_b.INVENTORY_ITEM_ID = c_item_id
4057: AND rev_b.ORGANIZATION_ID = c_org_id
4058: AND rev_b.REVISION = ( SELECT max(max_rev.revision)
4059: FROM MTL_ITEM_REVISIONS_B max_rev
4060: WHERE max_rev.INVENTORY_ITEM_ID = rev_b.INVENTORY_ITEM_ID
4061: AND max_rev.ORGANIZATION_ID = rev_b.ORGANIZATION_ID
4062: ) ;
4063: