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

Line 561: FROM mtl_system_items

557: serial_number_control_code
558: INTO l_rev_control,
559: l_lot_control,
560: l_serial_control
561: FROM mtl_system_items
562: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
563: AND organization_id = inv_mwb_globals.g_tree_organization_id;
564:
565: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

Line 895: FROM mtl_system_items

891: serial_number_control_code
892: INTO l_rev_control,
893: l_lot_control,
894: l_serial_control
895: FROM mtl_system_items
896: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
897: AND organization_id = inv_mwb_globals.g_tree_organization_id;
898:
899: IF inv_mwb_globals.g_chk_onhand = 1 THEN

Line 950: FROM mtl_system_items

946: SELECT lot_control_code,
947: serial_number_control_code
948: INTO l_lot_control,
949: l_serial_control
950: FROM mtl_system_items
951: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
952: AND organization_id = inv_mwb_globals.g_tree_organization_id;
953:
954: INV_MWB_ITEM_TREE.make_common_queries('MOQD');

Line 989: FROM mtl_system_items

985: SELECT revision_qty_control_code,
986: serial_number_control_code
987: INTO l_rev_control,
988: l_serial_control
989: FROM mtl_system_items
990: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
991: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
992:
993: INV_MWB_ITEM_TREE.make_common_queries('MOQD');

Line 1133: FROM mtl_system_items

1129: SELECT revision_qty_control_code,
1130: serial_number_control_code
1131: INTO l_rev_control,
1132: l_serial_control
1133: FROM mtl_system_items
1134: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
1135: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
1136:
1137: INV_MWB_LOT_TREE.make_common_queries('MOQD');

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 2039: FROM mtl_system_items

2035: or nvl(g_item_id_trak_qty, -9999) <> rec.item_id) then
2036:
2037: SELECT tracking_quantity_ind
2038: INTO l_tracking_qty_ind
2039: FROM mtl_system_items
2040: WHERE organization_id = rec.org_id
2041: AND inventory_item_id = rec.item_id;
2042:
2043: IF nvl(l_tracking_qty_ind, '@@@@') <> 'PS' THEN

Line 2551: add_where_clause('moqd.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :onh_client_code) ', 'ONHAND');

2547: END IF;
2548:
2549: -- ER(9158529 client)
2550: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
2551: add_where_clause('moqd.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :onh_client_code) ', 'ONHAND');
2552: add_bind_variable('onh_client_code', inv_mwb_globals.g_client_code);
2553: END IF;
2554: -- ER(9158529 client)
2555:

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 2564: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik', 'ONHAND');

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');
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');

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 2789: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');

2785: if inv_mwb_globals.g_status_id is not null then
2786: if l_default_status_id is not null then
2787: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2788:
2789: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2790: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2791: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2792: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');
2793:

Line 2801: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');

2797: else
2798: -- Bug 6060233
2799: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2800:
2801: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2802: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2803: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2804: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2805: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');

Line 2903: add_where_clause('msn.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :onh_client_code) ', 'ONHAND');

2899: END IF;
2900:
2901: -- ER(9158529 client)
2902: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
2903: add_where_clause('msn.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :onh_client_code) ', 'ONHAND');
2904: add_bind_variable('onh_client_code', inv_mwb_globals.g_client_code);
2905: END IF;
2906: -- ER(9158529 client)
2907:

Line 3163: FROM mtl_system_items

3159:
3160: IF inv_mwb_globals.g_tree_item_id IS NOT NULL THEN
3161: SELECT serial_number_control_code
3162: INTO l_serial_control
3163: FROM mtl_system_items
3164: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
3165: AND organization_id = inv_mwb_globals.g_tree_organization_id;
3166: END IF;
3167:

Line 3279: add_where_clause('wlc.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ', p_mat_loc);

3275: END IF;
3276:
3277: -- ER(9158529 client)
3278: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
3279: add_where_clause('wlc.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ', p_mat_loc);
3280: add_bind_variable('client_code', inv_mwb_globals.g_client_code);
3281: END IF;
3282: -- ER(9158529 client)
3283:

Line 3456: FROM mtl_system_items

3452: SELECT lot_control_code,
3453: serial_number_control_code
3454: INTO l_lot_control,
3455: l_serial_control
3456: FROM mtl_system_items
3457: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
3458: AND organization_id = inv_mwb_globals.g_tree_organization_id;
3459: EXCEPTION
3460: WHEN NO_DATA_FOUND THEN

Line 3601: add_where_clause('rs.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :rcv_client_code) ', 'RECEIVING');

3597: END IF;
3598:
3599: -- ER(9158529 client)
3600: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
3601: add_where_clause('rs.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :rcv_client_code) ', 'RECEIVING');
3602: add_bind_variable('rcv_client_code', inv_mwb_globals.g_client_code);
3603: END IF;
3604: -- ER(9158529 client)
3605:

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 3614: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');

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');
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');

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 3697: add_where_clause('msn.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :rcv_client_code) ', 'RECEIVING');

3693: END IF;
3694:
3695: -- ER(9158529 client)
3696: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
3697: add_where_clause('msn.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :rcv_client_code) ', 'RECEIVING');
3698: add_bind_variable('rcv_client_code', inv_mwb_globals.g_client_code);
3699: END IF;
3700: -- ER(9158529 client)
3701:

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 3710: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik','RECEIVING');

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');
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');

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 3861: add_where_clause('rs.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :rcv_client_code) ', 'RECEIVING');

3857: END IF;
3858:
3859: -- ER(9158529 client)
3860: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
3861: add_where_clause('rs.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :rcv_client_code) ', 'RECEIVING');
3862: add_bind_variable('rcv_client_code', inv_mwb_globals.g_client_code);
3863: END IF;
3864: -- ER(9158529 client)
3865:

Line 3873: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');

3869: END IF;
3870:
3871: IF inv_mwb_globals.g_inventory_item_id IS NULL
3872: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3873: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');
3874: add_where_clause('msib.inventory_item_id = rs.item_id', 'RECEIVING');
3875: add_where_clause('msib.organization_id = rs.to_organization_id', 'RECEIVING');
3876: add_where_clause('upper(msib.description) LIKE upper(:rcv_item_description)', 'RECEIVING');
3877: add_bind_variable('rcv_item_description', inv_mwb_globals.g_item_description);

Line 4011: FROM mtl_system_items

4007: serial_number_control_code
4008: INTO l_rev_control,
4009: l_lot_control,
4010: l_serial_control
4011: FROM mtl_system_items
4012: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
4013: AND organization_id = inv_mwb_globals.g_tree_organization_id;
4014:
4015: END IF;

Line 4104: add_where_clause('ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ', 'INBOUND');

4100: END IF;
4101:
4102: -- ER(9158529 client)
4103: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
4104: add_where_clause('ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ', 'INBOUND');
4105: add_bind_variable('inb_client_code', inv_mwb_globals.g_client_code);
4106: END IF;
4107: -- ER(9158529 client)
4108:

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 4152: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');

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');
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');

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 4290: add_where_clause('ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ', 'INBOUND');

4286: END IF;
4287:
4288: -- ER(9158529 client)
4289: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
4290: add_where_clause('ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ', 'INBOUND');
4291: add_bind_variable('inb_client_code', inv_mwb_globals.g_client_code);
4292: END IF;
4293: -- ER(9158529 client)
4294:

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 4460: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');

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');
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');

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 4484: add_where_clause('ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ', 'INBOUND');

4480: END IF;
4481:
4482: -- ER(9158529 client)
4483: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
4484: add_where_clause('ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ', 'INBOUND');
4485: add_bind_variable('inb_client_code', inv_mwb_globals.g_client_code);
4486: END IF;
4487: -- ER(9158529 client)
4488:

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 4651: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');

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');
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');

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');