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

Line 814: from mtl_item_revisions mir,

810: IF NVL(FND_PROFILE.VALUE('INV_PURCHASING_BY_REVISION'),2) = 1 THEN
811: BEGIN
812: select MAX(revision)
813: into l_item_revision
814: from mtl_item_revisions mir,
815: mtl_system_items mti
816: where mir.inventory_item_id = mti.inventory_item_id
817: and mir.organization_id = mti.organization_id
818: and mti.inventory_item_id = p_drop_ship_line_rec.inventory_item_id

Line 824: from mtl_item_revisions mir1

820: and mti.REVISION_QTY_CONTROL_CODE =2 /* Means item is under revision control */
821: and mir.effectivity_date < SYSDATE+1
822: and mir.effectivity_date =
823: ( select MAX(mir1.effectivity_date)
824: from mtl_item_revisions mir1
825: where mir1.inventory_item_id = mir.inventory_item_id
826: and mir1.organization_id = mir.organization_id
827: and mir1.effectivity_date < SYSDATE+1
828: );