APPS.GMICUOM dependencies on MTL_SYSTEM_ITEMS

Line 292: l_inventory_item_id mtl_system_items.inventory_item_id%type;

288: l_parm_name lm_item_dat.tech_parm_name%TYPE;
289: l_factor NUMBER;
290: l_new_qty NUMBER;
291: l_item_no ic_item_mst.item_no%type;
292: l_inventory_item_id mtl_system_items.inventory_item_id%type;
293: var1 NUMBER;
294:
295: /* Bug 2844068 */
296: l_factor_len NUMBER;

Line 302: Vinventory_item_id mtl_system_items.inventory_item_id%type) IS

298:
299: /* Cursor Definitions
300: ==================*/
301: CURSOR get_uom_type(Vum_code uomcode_type,
302: Vinventory_item_id mtl_system_items.inventory_item_id%type) IS
303: SELECT 1, uomc.uom_class um_type, uomc.conversion_rate std_factor
304: FROM mtl_uom_conversions uomc, mtl_units_of_measure uom, sy_uoms_mst sy
305: WHERE sy.um_code = Vum_code
306: AND uom.unit_of_measure = sy.unit_of_measure

Line 343: FROM mtl_system_items

339: WHERE item_id = Vitem_id;
340:
341: CURSOR get_inventory_item_id(Vitem_no ic_item_mst.item_no%type) IS
342: SELECT inventory_item_id
343: FROM mtl_system_items
344: WHERE segment1= Vitem_no
345: AND rownum = 1;
346: /* ================================================*/
347: BEGIN

Line 728: l_inventory_item_id mtl_system_items.inventory_item_id%type;

724: l_parm_name lm_item_dat.tech_parm_name%TYPE;
725: l_factor NUMBER;
726: l_new_qty NUMBER;
727: l_item_no ic_item_mst.item_no%type;
728: l_inventory_item_id mtl_system_items.inventory_item_id%type;
729: var1 NUMBER;
730:
731: /* Cursor Definitions
732: ==================*/

Line 734: Vinventory_item_id mtl_system_items.inventory_item_id%type) IS

730:
731: /* Cursor Definitions
732: ==================*/
733: CURSOR get_uom_type(Vum_code uomcode_type,
734: Vinventory_item_id mtl_system_items.inventory_item_id%type) IS
735: SELECT 1, uomc.uom_class um_type, uomc.conversion_rate std_factor
736: FROM mtl_uom_conversions uomc, mtl_units_of_measure uom, sy_uoms_mst sy
737: WHERE sy.um_code = Vum_code
738: AND uom.unit_of_measure = sy.unit_of_measure

Line 782: FROM mtl_system_items

778: WHERE item_id = Vitem_id;
779:
780: CURSOR get_inventory_item_id(Vitem_no ic_item_mst.item_no%type) IS
781: SELECT inventory_item_id
782: FROM mtl_system_items
783: WHERE segment1= Vitem_no
784: AND rownum = 1;
785:
786: /* ================================================*/