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 2073: FROM mtl_item_revisions

2069: RETURN BOOLEAN IS
2070:
2071: CURSOR c IS
2072: SELECT 1
2073: FROM mtl_item_revisions
2074: WHERE inventory_item_id = x_item_id AND
2075: organization_id = x_org_id AND
2076: revision = x_revision;
2077:

Line 3296: FROM mtl_item_revisions mir, mtl_system_items msi

3292: -- will have a base revision by default. But we want this sql to
3293: -- fetch revision only if the item is revision controlled. kabalakr.
3294:
3295: sql_string := 'SELECT mir.revision, mir.effectivity_date
3296: FROM mtl_item_revisions mir, mtl_system_items msi
3297: WHERE mir.inventory_item_id = :1
3298: AND mir.organization_id = :2
3299: AND mir.revision like :3
3300: AND mir.inventory_item_id = msi.inventory_item_id