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

775: IF NVL(FND_PROFILE.VALUE('INV_PURCHASING_BY_REVISION'),2) = 1 THEN
776: BEGIN
777: select MAX(revision)
778: into l_item_revision
779: from mtl_item_revisions mir,
780: mtl_system_items mti
781: where mir.inventory_item_id = mti.inventory_item_id
782: and mir.organization_id = mti.organization_id
783: and mti.inventory_item_id = p_drop_ship_line_rec.inventory_item_id

Line 789: from mtl_item_revisions mir1

785: and mti.REVISION_QTY_CONTROL_CODE =2 /* Means item is under revision control */
786: and mir.effectivity_date < SYSDATE+1
787: and mir.effectivity_date =
788: ( select MAX(mir1.effectivity_date)
789: from mtl_item_revisions mir1
790: where mir1.inventory_item_id = mir.inventory_item_id
791: and mir1.organization_id = mir.organization_id
792: and mir1.effectivity_date < SYSDATE+1
793: );