APPS.INV_GMI_MIGRATION dependencies on GMI_ITEM_CATEGORIES

Line 600: FROM gmi_item_categories g,

596: SELECT DISTINCT
597: i.inventory_item_id,
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

Line 622: p_table_name => 'GMI_ITEM_CATEGORIES',

618: GMA_COMMON_LOGGING.gma_migration_central_log (
619: p_run_id => p_migration_run_id,
620: p_log_level => FND_LOG.LEVEL_PROCEDURE,
621: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
622: p_table_name => 'GMI_ITEM_CATEGORIES',
623: p_context => 'ITEM CATEGORIES',
624: p_param1 => NULL,
625: p_param2 => NULL,
626: p_param3 => NULL,

Line 663: FROM gmi_item_categories g,

659: NULL,
660: NULL,
661: NULL,
662: NULL
663: FROM gmi_item_categories g,
664: ic_item_mst_b_mig i
665: WHERE g.rowid BETWEEN p_start_rowid AND p_end_rowid AND
666: i.migrated_ind is not NULL and
667: i.category_migrated_ind is NULL and

Line 687: p_table_name => 'GMI_ITEM_CATEGORIES',

683: GMA_COMMON_LOGGING.gma_migration_central_log (
684: p_run_id => p_migration_run_id,
685: p_log_level => FND_LOG.LEVEL_PROCEDURE,
686: p_message_token => 'GMI_MIG_ITEM_CAT_EXISTS',
687: p_table_name => 'GMI_ITEM_CATEGORIES',
688: p_context => 'ITEM CATEGORIES',
689: p_param1 => INV_GMI_Migration.org(r.organization_id),
690: p_param2 => INV_GMI_Migration.ditem(r.organization_id, r.inventory_item_id),
691: p_param3 => to_char(r.category_set_id),

Line 706: FROM gmi_item_categories

702: SET category_migrated_ind = 1
703: WHERE
704: (organization_id, inventory_item_id) IN (
705: SELECT organization_id, inventory_item_id
706: FROM gmi_item_categories
707: WHERE
708: rowid BETWEEN p_start_rowid AND p_end_rowid);
709:
710: -- dbms_output.put_line ('Completed ITEM CATEGORIES migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));

Line 715: p_table_name => 'GMI_ITEM_CATEGORIES',

711: GMA_COMMON_LOGGING.gma_migration_central_log (
712: p_run_id => p_migration_run_id,
713: p_log_level => FND_LOG.LEVEL_PROCEDURE,
714: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
715: p_table_name => 'GMI_ITEM_CATEGORIES',
716: p_context => 'ITEM CATEGORIES',
717: p_param1 => l_migrate_count,
718: p_param2 => x_failure_count,
719: p_param3 => NULL,

Line 732: p_table_name => 'GMI_ITEM_CATEGORIES',

728: GMA_COMMON_LOGGING.gma_migration_central_log (
729: p_run_id => p_migration_run_id,
730: p_log_level => FND_LOG.LEVEL_ERROR,
731: p_message_token => 'GMA_MIGRATION_DB_ERROR',
732: p_table_name => 'GMI_ITEM_CATEGORIES',
733: p_context => 'ITEM CATEGORIES',
734: p_param1 => NULL,
735: p_param2 => NULL,
736: p_param3 => NULL,