APPS.INV_OPM_LOT_MIGRATION dependencies on IC_ITEM_MST_B

Line 208: FROM ic_item_mst_b

204: DECODE(sublot_ctl, 1, DECODE(l_opm_lot.sublot_no, NULL, NULL,
205: l_opm_lot.lot_no)),
206: status_ctl, lot_status
207: INTO x_lot_number, x_parent_lot_number, l_status_ctl, l_default_status
208: FROM ic_item_mst_b
209: WHERE
210: item_id = p_item_id;
211:
212: -- Get the inventory status for the lot

Line 741: FROM ic_item_mst_b i, mtl_system_items_b d

737: l_field_name := 'Matching OPM Item';
738: l_field_value := to_char(p_organization_id) ||', '||to_char(p_inventory_item_id);
739: SELECT i.item_id
740: INTO l_item_id
741: FROM ic_item_mst_b i, mtl_system_items_b d
742: WHERE
743: d.organization_id = p_organization_id AND
744: d.inventory_item_id = p_inventory_item_id AND
745: d.segment1 = i.item_no;