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

Line 3562: from mtl_item_revisions mir

3558: l_sql_stmt_no := 50;
3559:
3560: select MAX(revision)
3561: into l_revision
3562: from mtl_item_revisions mir
3563: where inventory_item_id = l_kanban_card_Rec_Tbl(1).Inventory_Item_Id
3564: and organization_id = l_kanban_card_Rec_Tbl(1).organization_Id
3565: and effectivity_date < SYSDATE
3566: and implementation_date is not null /* Added for bug 7110794 */

Line 3570: from mtl_item_revisions mir1

3566: and implementation_date is not null /* Added for bug 7110794 */
3567: and effectivity_date =
3568: (
3569: select MAX(effectivity_date)
3570: from mtl_item_revisions mir1
3571: where mir1.inventory_item_id = mir.inventory_item_id
3572: and mir1.organization_id = mir.organization_id
3573: and implementation_date is not null /* Added for bug 7110794 */
3574: and effectivity_date < SYSDATE