APPS.INV_GMI_MIGRATION dependencies on MTL_ITEM_CATEGORIES

Line 602: mtl_item_categories m

598: i.organization_id,
599: g.category_set_id
600: FROM gmi_item_categories g,
601: ic_item_mst_b_mig i,
602: mtl_item_categories m
603: WHERE g.rowid BETWEEN p_start_rowid AND p_end_rowid AND
604: i.migrated_ind is not NULL and
605: i.category_migrated_ind is NULL and
606: i.item_id = g.item_id and

Line 633: insert into mtl_item_categories(

629: p_db_error => NULL,
630: p_app_short_name => 'GMA');
631:
632: -- insert new record in discrete
633: insert into mtl_item_categories(
634: INVENTORY_ITEM_ID,
635: ORGANIZATION_ID,
636: CATEGORY_SET_ID,
637: CATEGORY_ID,

Line 671: FROM mtl_item_categories

667: i.category_migrated_ind is NULL and
668: i.item_id = g.item_id and
669: NOT EXISTS(
670: SELECT 1
671: FROM mtl_item_categories
672: WHERE
673: organization_id = i.organization_id AND
674: inventory_item_id = i.inventory_item_id AND
675: category_set_id = g.category_set_id);