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 1616: from mtl_item_revisions mir,

1612: Begin
1613:
1614: l_stmt_num := 140;
1615: select max(revision) into l_item_revision
1616: from mtl_item_revisions mir,
1617: mtl_system_items msi
1618: where msi.organization_id = p_destination_org_id
1619: and msi.inventory_item_id = p_item_id
1620: and mir.organization_id = msi.organization_id

Line 1623: from mtl_item_revisions mir1

1619: and msi.inventory_item_id = p_item_id
1620: and mir.organization_id = msi.organization_id
1621: and mir.inventory_item_id = msi.inventory_item_id
1622: and mir.effectivity_date = (select max(mir1.effectivity_date)
1623: from mtl_item_revisions mir1
1624: where mir1.organization_id = msi.organization_id
1625: and mir1.inventory_item_id = msi.inventory_item_id
1626: and mir1.effectivity_date <= sysdate )
1627: and msi.revision_qty_control_code = 2 --revision controlled items only