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

Line 1939: from mtl_item_revisions mir,

1935: Begin
1936:
1937: l_stmt_num := 140;
1938: select max(revision) into l_item_revision
1939: from mtl_item_revisions mir,
1940: mtl_system_items msi
1941: where msi.organization_id = p_destination_org_id
1942: and msi.inventory_item_id = p_item_id
1943: and mir.organization_id = msi.organization_id

Line 1946: from mtl_item_revisions mir1

1942: and msi.inventory_item_id = p_item_id
1943: and mir.organization_id = msi.organization_id
1944: and mir.inventory_item_id = msi.inventory_item_id
1945: and mir.effectivity_date = (select max(mir1.effectivity_date)
1946: from mtl_item_revisions mir1
1947: where mir1.organization_id = msi.organization_id
1948: and mir1.inventory_item_id = msi.inventory_item_id
1949: and mir1.effectivity_date <= sysdate )
1950: and msi.revision_qty_control_code = 2 --revision controlled items only