APPS.INV_GMI_MIGRATION dependencies on MTL_ITEM_CATEGORIES

Line 641: mtl_item_categories m

637: i.organization_id,
638: g.category_set_id
639: FROM gmi_item_categories g,
640: ic_item_mst_b_mig i,
641: mtl_item_categories m
642: WHERE i.rowid BETWEEN p_start_rowid AND p_end_rowid AND
643: i.migrated_ind is not NULL and
644: i.category_migrated_ind is NULL and
645: i.item_id = g.item_id and

Line 672: insert into mtl_item_categories(

668: p_db_error => NULL,
669: p_app_short_name => 'GMA');
670:
671: -- insert new record in discrete
672: insert into mtl_item_categories(
673: INVENTORY_ITEM_ID,
674: ORGANIZATION_ID,
675: CATEGORY_SET_ID,
676: CATEGORY_ID,

Line 710: FROM mtl_item_categories

706: -- i.category_migrated_ind is NULL and bug 13910275
707: i.item_id = g.item_id and
708: NOT EXISTS(
709: SELECT 1
710: FROM mtl_item_categories
711: WHERE
712: organization_id = i.organization_id AND
713: inventory_item_id = i.inventory_item_id AND
714: category_set_id = g.category_set_id);