APPS.GMA_MIGRATION_UTILS dependencies on IC_ITEM_MST

Line 147: /* ic_item_mst */

143: --- Removing all the GMA Logging
144: --
145:
146:
147: /* ic_item_mst */
148: --
149: --- Cursor for the item text_code migration
150: --
151:

Line 161: ic_item_mst ic

157: msi.organization_id,
158: msi.segment1
159: FROM mtl_system_items msi,
160: mtl_parameters p,
161: ic_item_mst ic
162: WHERE msi.segment1 = ic.item_no
163: AND msi.organization_id = p.master_organization_id
164: AND p.organization_id = p.master_organization_id
165: AND ic.text_code IS NOT NULL;

Line 174: FROM ic_item_mst_b_mig itm,

170: SELECT p.lot_number,
171: itm.INVENTORY_ITEM_ID,
172: p.organization_id,
173: ic.text_code
174: FROM ic_item_mst_b_mig itm,
175: mtl_lot_numbers msi,
176: IC_LOTS_MST_MIG p,
177: IC_LOTS_MST ic
178: WHERE p.lot_number = msi.lot_number

Line 260: l_opm_table_name := 'IC_ITEM_MST';

256: p_Event_Name=>l_event_name) = FALSE THEN
257:
258: /* Edit Text Migration for Item Master */
259: l_table_name := 'MTL_SYSTEM_ITEMS';
260: l_opm_table_name := 'IC_ITEM_MST';
261:
262: FOR l_item_mst_rec IN item_mst_cur LOOP
263: BEGIN
264: /* Call the Attachment_main procedure */