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

Line 583: from mtl_item_revisions mir

579: l_sql_stmt_no := 50;
580:
581: select MAX(revision)
582: into l_revision
583: from mtl_item_revisions mir
584: where inventory_item_id = l_kanban_card_Rec_Tbl(1).Inventory_Item_Id
585: and organization_id = l_kanban_card_Rec_Tbl(1).organization_Id
586: and effectivity_date < SYSDATE
587: and implementation_date is not null

Line 589: from mtl_item_revisions mir1

585: and organization_id = l_kanban_card_Rec_Tbl(1).organization_Id
586: and effectivity_date < SYSDATE
587: and implementation_date is not null
588: and effectivity_date = ( select MAX(effectivity_date)
589: from mtl_item_revisions mir1
590: where mir1.inventory_item_id = mir.inventory_item_id
591: and mir1.organization_id = mir.organization_id
592: and implementation_date is not null
593: and effectivity_date < SYSDATE );