APPS.GMICUOM dependencies on IC_ITEM_MST

Line 291: l_item_no ic_item_mst.item_no%type;

287: l_lab_conv_factor lm_item_dat.num_data%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 */

Line 321: FROM ic_item_mst

317:
318:
319: CURSOR get_inv_uom(v_item_id itm_surg_type) IS
320: SELECT item_um
321: FROM ic_item_mst
322: WHERE item_id = v_item_id;
323:
324: /* Bug 2844068 */
325: /* Added type_factorrev to the query */

Line 336: CURSOR get_item_no (Vitem_id ic_item_mst.item_id%type) IS

332: AND lot_id = v_lot_id
333: AND delete_mark = 0
334: AND um_type = v_um_type;
335:
336: CURSOR get_item_no (Vitem_id ic_item_mst.item_id%type) IS
337: SELECT item_no
338: FROM ic_item_mst
339: WHERE item_id = Vitem_id;
340:

Line 338: FROM ic_item_mst

334: AND um_type = v_um_type;
335:
336: CURSOR get_item_no (Vitem_id ic_item_mst.item_id%type) IS
337: SELECT item_no
338: FROM ic_item_mst
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

Line 341: CURSOR get_inventory_item_id(Vitem_no ic_item_mst.item_no%type) IS

337: SELECT item_no
338: FROM ic_item_mst
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;

Line 727: l_item_no ic_item_mst.item_no%type;

723: l_lab_conv_factor lm_item_dat.num_data%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

Line 750: FROM ic_item_mst

746: ORDER by 1;
747:
748: CURSOR get_inv_uom(v_item_id itm_surg_type) IS
749: SELECT item_um
750: FROM ic_item_mst
751: WHERE item_id = v_item_id;
752:
753: CURSOR get_conversion_factor(v_item_id itm_surg_type,
754: v_lot_id lot_surg_type,

Line 775: CURSOR get_item_no (Vitem_id ic_item_mst.item_id%type) IS

771: AND formula_id = v_formula_id
772: AND tech_parm_name = v_parm_name
773: AND delete_mark = 0;
774:
775: CURSOR get_item_no (Vitem_id ic_item_mst.item_id%type) IS
776: SELECT item_no
777: FROM ic_item_mst
778: WHERE item_id = Vitem_id;
779:

Line 777: FROM ic_item_mst

773: AND delete_mark = 0;
774:
775: CURSOR get_item_no (Vitem_id ic_item_mst.item_id%type) IS
776: SELECT item_no
777: FROM ic_item_mst
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

Line 780: CURSOR get_inventory_item_id(Vitem_no ic_item_mst.item_no%type) IS

776: SELECT item_no
777: FROM ic_item_mst
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;