APPS.INV_GMI_MIGRATION dependencies on GMI_ITEM_CATEGORIES

Line 639: FROM gmi_item_categories g,

635: SELECT DISTINCT
636: i.inventory_item_id,
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

Line 661: p_table_name => 'GMI_ITEM_CATEGORIES',

657: GMA_COMMON_LOGGING.gma_migration_central_log (
658: p_run_id => p_migration_run_id,
659: p_log_level => FND_LOG.LEVEL_PROCEDURE,
660: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
661: p_table_name => 'GMI_ITEM_CATEGORIES',
662: p_context => 'ITEM CATEGORIES',
663: p_param1 => NULL,
664: p_param2 => NULL,
665: p_param3 => NULL,

Line 702: FROM gmi_item_categories g,

698: NULL,
699: NULL,
700: NULL,
701: NULL
702: FROM gmi_item_categories g,
703: ic_item_mst_b_mig i
704: WHERE i.rowid BETWEEN p_start_rowid AND p_end_rowid AND
705: i.migrated_ind is not NULL and
706: -- i.category_migrated_ind is NULL and bug 13910275

Line 726: p_table_name => 'GMI_ITEM_CATEGORIES',

722: GMA_COMMON_LOGGING.gma_migration_central_log (
723: p_run_id => p_migration_run_id,
724: p_log_level => FND_LOG.LEVEL_PROCEDURE,
725: p_message_token => 'GMI_MIG_ITEM_CAT_EXISTS',
726: p_table_name => 'GMI_ITEM_CATEGORIES',
727: p_context => 'ITEM CATEGORIES',
728: p_param1 => INV_GMI_Migration.org(r.organization_id),
729: p_param2 => INV_GMI_Migration.ditem(r.organization_id, r.inventory_item_id),
730: p_param3 => to_char(r.category_set_id),

Line 745: FROM gmi_item_categories gic

741: /* Modified the update*/
742: UPDATE ic_item_mst_b_mig mig
743: SET category_migrated_ind = 1
744: WHERE exists ( SELECT 1
745: FROM gmi_item_categories gic
746: WHERE mig.item_id = gic.item_id)
747: AND ROWID BETWEEN p_start_rowid AND p_end_rowid;
748:
749:

Line 755: FROM gmi_item_categories

751: SET category_migrated_ind = 1
752: WHERE
753: (organization_id, inventory_item_id) IN (
754: SELECT organization_id, inventory_item_id
755: FROM gmi_item_categories
756: WHERE
757: rowid BETWEEN p_start_rowid AND p_end_rowid); */
758:
759: -- dbms_output.put_line ('Completed ITEM CATEGORIES migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));

Line 764: p_table_name => 'GMI_ITEM_CATEGORIES',

760: GMA_COMMON_LOGGING.gma_migration_central_log (
761: p_run_id => p_migration_run_id,
762: p_log_level => FND_LOG.LEVEL_PROCEDURE,
763: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
764: p_table_name => 'GMI_ITEM_CATEGORIES',
765: p_context => 'ITEM CATEGORIES',
766: p_param1 => l_migrate_count,
767: p_param2 => x_failure_count,
768: p_param3 => NULL,

Line 781: p_table_name => 'GMI_ITEM_CATEGORIES',

777: GMA_COMMON_LOGGING.gma_migration_central_log (
778: p_run_id => p_migration_run_id,
779: p_log_level => FND_LOG.LEVEL_ERROR,
780: p_message_token => 'GMA_MIGRATION_DB_ERROR',
781: p_table_name => 'GMI_ITEM_CATEGORIES',
782: p_context => 'ITEM CATEGORIES',
783: p_param1 => NULL,
784: p_param2 => NULL,
785: p_param3 => NULL,