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_MWB_QUERY_MANAGER dependencies on MTL_SYSTEM_ITEMS_VL

Line 1666: FROM mtl_system_items_vl --Bug 7691371

1662: l_item_name -- Bug 6350236
1663: , DESCRIPTION
1664: , PRIMARY_UOM_CODE
1665: , SECONDARY_UOM_CODE
1666: FROM mtl_system_items_vl --Bug 7691371
1667: WHERE inventory_item_id = rec.item_id
1668: AND organization_id = rec.org_id)
1669: WHERE item_id = rec.item_id
1670: AND org_id = rec.org_id; --Bug 12633111

Line 2561: --Bug 14548684 add view mtl_system_items_vl to support multi-language

2557: add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
2558: add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_inventory_item_id);
2559: END IF;
2560:
2561: --Bug 14548684 add view mtl_system_items_vl to support multi-language
2562: IF inv_mwb_globals.g_inventory_item_id IS NULL
2563: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
2564: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik', 'ONHAND');
2565: inv_mwb_query_manager.add_from_clause('mtl_system_items_vl msiv', 'ONHAND');

Line 2565: inv_mwb_query_manager.add_from_clause('mtl_system_items_vl msiv', 'ONHAND');

2561: --Bug 14548684 add view mtl_system_items_vl to support multi-language
2562: IF inv_mwb_globals.g_inventory_item_id IS NULL
2563: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
2564: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik', 'ONHAND');
2565: inv_mwb_query_manager.add_from_clause('mtl_system_items_vl msiv', 'ONHAND');
2566: add_where_clause('moqd.inventory_item_id = msik.inventory_item_id', 'ONHAND');
2567: add_where_clause('moqd.organization_id = msik.organization_id', 'ONHAND');
2568: add_where_clause('msik.inventory_item_id = msiv.inventory_item_id', 'ONHAND');
2569: add_where_clause('msik.organization_id = msiv.organization_id', 'ONHAND');

Line 3611: --Bug 14548684 add view mtl_system_items_vl to support multi-language

3607: add_where_clause('rs.item_id = :rcv_item_id', 'RECEIVING');
3608: add_bind_variable('rcv_item_id', inv_mwb_globals.g_inventory_item_id);
3609: END IF;
3610:
3611: --Bug 14548684 add view mtl_system_items_vl to support multi-language
3612: IF inv_mwb_globals.g_inventory_item_id IS NULL
3613: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3614: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');
3615: inv_mwb_query_manager.add_from_clause('mtl_system_items_vl msiv', 'RECEIVING');

Line 3615: inv_mwb_query_manager.add_from_clause('mtl_system_items_vl msiv', 'RECEIVING');

3611: --Bug 14548684 add view mtl_system_items_vl to support multi-language
3612: IF inv_mwb_globals.g_inventory_item_id IS NULL
3613: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3614: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');
3615: inv_mwb_query_manager.add_from_clause('mtl_system_items_vl msiv', 'RECEIVING');
3616: add_where_clause('msib.inventory_item_id = rs.item_id', 'RECEIVING');
3617: add_where_clause('msib.organization_id = rs.to_organization_id', 'RECEIVING');
3618: add_where_clause('msib.inventory_item_id = msiv.inventory_item_id', 'RECEIVING');
3619: add_where_clause('msib.organization_id = msiv.organization_id', 'RECEIVING');

Line 3707: --Bug 14548684 add view mtl_system_items_vl to support multi-language

3703: add_where_clause('msn.inventory_item_id = :rcv_item_id', 'RECEIVING');
3704: add_bind_variable('rcv_item_id', inv_mwb_globals.g_inventory_item_id);
3705: END IF;
3706:
3707: --Bug 14548684 add view mtl_system_items_vl to support multi-language
3708: IF inv_mwb_globals.g_inventory_item_id IS NULL
3709: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3710: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik','RECEIVING');
3711: inv_mwb_query_manager.add_from_clause('mtl_system_items_vl msiv', 'RECEIVING');

Line 3711: inv_mwb_query_manager.add_from_clause('mtl_system_items_vl msiv', 'RECEIVING');

3707: --Bug 14548684 add view mtl_system_items_vl to support multi-language
3708: IF inv_mwb_globals.g_inventory_item_id IS NULL
3709: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3710: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik','RECEIVING');
3711: inv_mwb_query_manager.add_from_clause('mtl_system_items_vl msiv', 'RECEIVING');
3712: add_where_clause('msik.inventory_item_id = msn.inventory_item_id', 'RECEIVING');
3713: add_where_clause('msik.organization_id = msn.current_organization_id', 'RECEIVING');
3714: add_where_clause('msik.inventory_item_id = msiv.inventory_item_id', 'RECEIVING');
3715: add_where_clause('msik.organization_id = msiv.organization_id', 'RECEIVING');

Line 4149: --Bug 14548684 add view mtl_system_items_vl to support multi-language

4145: add_where_clause('ms.expected_delivery_date <= :inb_expected_to_date', 'INBOUND');
4146: add_bind_variable('inb_expected_to_date', inv_mwb_globals.g_expected_to_date);
4147: END IF;
4148:
4149: --Bug 14548684 add view mtl_system_items_vl to support multi-language
4150: IF inv_mwb_globals.g_inventory_item_id IS NULL
4151: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
4152: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');
4153: add_from_clause('mtl_system_items_vl msiv', 'INBOUND');

Line 4153: add_from_clause('mtl_system_items_vl msiv', 'INBOUND');

4149: --Bug 14548684 add view mtl_system_items_vl to support multi-language
4150: IF inv_mwb_globals.g_inventory_item_id IS NULL
4151: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
4152: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');
4153: add_from_clause('mtl_system_items_vl msiv', 'INBOUND');
4154: add_where_clause(' ms.item_id = msik.inventory_item_id ', 'INBOUND');
4155: add_where_clause(' ms.to_organization_id = msik.organization_id ', 'INBOUND');
4156: add_where_clause('msik.inventory_item_id = msiv.inventory_item_id', 'INBOUND');
4157: add_where_clause('msik.organization_id = msiv.organization_id', 'INBOUND');

Line 4457: --Bug 14548684 add view mtl_system_items_vl to support multi-language

4453: add_where_clause('rss.serial_num <= :inb_serial_to', 'INBOUND');
4454: add_bind_variable('inb_serial_to', inv_mwb_globals.g_serial_to);
4455: END IF;
4456:
4457: --Bug 14548684 add view mtl_system_items_vl to support multi-language
4458: IF inv_mwb_globals.g_inventory_item_id IS NULL
4459: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
4460: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');
4461: add_from_clause('mtl_system_items_vl msiv', 'INBOUND');

Line 4461: add_from_clause('mtl_system_items_vl msiv', 'INBOUND');

4457: --Bug 14548684 add view mtl_system_items_vl to support multi-language
4458: IF inv_mwb_globals.g_inventory_item_id IS NULL
4459: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
4460: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');
4461: add_from_clause('mtl_system_items_vl msiv', 'INBOUND');
4462: add_where_clause(' ms.item_id = msik.inventory_item_id ', 'INBOUND');
4463: add_where_clause(' ms.to_organization_id = msik.organization_id ', 'INBOUND');
4464: add_where_clause('msik.inventory_item_id = msiv.inventory_item_id', 'INBOUND');
4465: add_where_clause('msik.organization_id = msiv.organization_id', 'INBOUND');

Line 4648: --Bug 14548684 add view mtl_system_items_vl to support multi-language

4644: add_where_clause('rss.serial_num <= :inb_serial_to', 'INBOUND');
4645: add_bind_variable('inb_serial_to', inv_mwb_globals.g_serial_to);
4646: END IF;
4647:
4648: --Bug 14548684 add view mtl_system_items_vl to support multi-language
4649: IF inv_mwb_globals.g_inventory_item_id IS NULL
4650: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
4651: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');
4652: add_from_clause('mtl_system_items_vl msiv', 'INBOUND');

Line 4652: add_from_clause('mtl_system_items_vl msiv', 'INBOUND');

4648: --Bug 14548684 add view mtl_system_items_vl to support multi-language
4649: IF inv_mwb_globals.g_inventory_item_id IS NULL
4650: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
4651: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');
4652: add_from_clause('mtl_system_items_vl msiv', 'INBOUND');
4653: add_where_clause(' ms.item_id = msik.inventory_item_id ', 'INBOUND');
4654: add_where_clause(' ms.to_organization_id = msik.organization_id ', 'INBOUND');
4655: add_where_clause('msik.inventory_item_id = msiv.inventory_item_id', 'INBOUND');
4656: add_where_clause('msik.organization_id = msiv.organization_id', 'INBOUND');