APPS.GML_OPM_ROI_GRP dependencies on IC_ITEM_MST

Line 169: From ic_item_mst

165:
166: /*Bug 3117947*/
167: Cursor Cr_check_noninv IS
168: Select noninv_ind
169: From ic_item_mst
170: Where item_id = p_opm_item_id;
171:
172: l_noninv_ind NUMBER :=0;
173: l_table_name VARCHAR2(35);

Line 335: select item_um2,item_id into l_item_um2,l_opm_item_id from ic_item_mst

331:
332: IF x_opm_record.receipt_source_code IN ('VENDOR','INTERNAL ORDER','CUSTOMER') THEN
333: BEGIN
334: IF x_opm_record.item_num is not null THEN
335: select item_um2,item_id into l_item_um2,l_opm_item_id from ic_item_mst
336: where item_no = x_opm_record.item_num ;
337: ELSE
338: select iim.item_no , iim.item_um2 , iim.item_id into x_opm_record.item_num,l_item_um2 , l_opm_item_id
339: from mtl_system_items_b msi,ic_item_mst iim

Line 339: from mtl_system_items_b msi,ic_item_mst iim

335: select item_um2,item_id into l_item_um2,l_opm_item_id from ic_item_mst
336: where item_no = x_opm_record.item_num ;
337: ELSE
338: select iim.item_no , iim.item_um2 , iim.item_id into x_opm_record.item_num,l_item_um2 , l_opm_item_id
339: from mtl_system_items_b msi,ic_item_mst iim
340: where msi.inventory_item_id = x_opm_record.item_id
341: and msi.organization_id = x_opm_record.to_organization_id
342: and msi.segment1 = iim.item_no ;
343: END IF;

Line 571: FROM ic_item_mst_b

567: END IF;
568:
569: SELECT sublot_ctl,shelf_life
570: INTO l_sublot_ctl,l_shelf_life
571: FROM ic_item_mst_b
572: WHERE item_id = p_lot_attribute_rec.opm_item_id ;
573:
574:
575: IF p_lot_attribute_rec.sublot_no IS NOT NULL AND l_sublot_ctl = 0 THEN

Line 769: FROM IC_ITEM_MST

765:
766:
767: SELECT lot_status,status_ctl
768: INTO l_default_lot_status,l_item_status_ctl
769: FROM IC_ITEM_MST
770: WHERE item_id = p_lot_attribute_rec.opm_item_id;
771:
772: IF l_inv_debug = 1 THEN
773: print_debug('Item lot status '||l_default_lot_status, 1);

Line 1051: FROM IC_ITEM_MST_B

1047: FROM SY_UOMS_MST
1048: WHERE unit_of_measure = p_to_unit_of_measure ;
1049:
1050: SELECT dualum_ind INTO l_dualum_ind
1051: FROM IC_ITEM_MST_B
1052: WHERE item_no = l_new_lot_rec.item_no ;
1053:
1054:
1055: IF (l_from_um_type <> l_to_um_type) AND (l_dualum_ind > 1) THEN