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.QA_PLAN_ELEMENT_API dependencies on MTL_ITEM_REVISIONS

Line 2092: FROM mtl_item_revisions

2088: RETURN BOOLEAN IS
2089:
2090: CURSOR c IS
2091: SELECT 1
2092: FROM mtl_item_revisions
2093: WHERE inventory_item_id = x_item_id AND
2094: organization_id = x_org_id AND
2095: revision = x_revision;
2096:

Line 3388: FROM mtl_item_revisions mir, mtl_system_items msi

3384: -- will have a base revision by default. But we want this sql to
3385: -- fetch revision only if the item is revision controlled. kabalakr.
3386:
3387: sql_string := 'SELECT mir.revision, mir.effectivity_date
3388: FROM mtl_item_revisions mir, mtl_system_items msi
3389: WHERE mir.inventory_item_id = :1
3390: AND mir.organization_id = :2
3391: AND mir.revision like :3
3392: AND mir.inventory_item_id = msi.inventory_item_id