APPS.BSC_MIGRATION dependencies on BSC_TAB_IND_GROUPS_B

Line 3839: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_TAB_IND_GROUPS_B';

3835: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3836: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3837:
3838: g_num_metadata_tables := g_num_metadata_tables + 1;
3839: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_TAB_IND_GROUPS_B';
3840: g_metadata_tables(g_num_metadata_tables).level := 1;
3841: g_metadata_tables(g_num_metadata_tables).level_column := 'TAB_ID';
3842: g_metadata_tables(g_num_metadata_tables).level_condition := NULL;
3843: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 4870: -- 8. Add TAB_ID -1 in BSC_TAB_IND_GROUPS_B and BSC_TAB_IND_GROUPS_TL

4866: h_sql := 'ALTER SEQUENCE BSC_KPI_COMMENTS_ID_S INCREMENT BY 1';
4867: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_KPI_COMMENTS_ID_S');
4868: END IF;
4869:
4870: -- 8. Add TAB_ID -1 in BSC_TAB_IND_GROUPS_B and BSC_TAB_IND_GROUPS_TL
4871: INSERT INTO BSC_TAB_IND_GROUPS_TL (TAB_ID,CSF_ID,IND_GROUP_ID,LANGUAGE,SOURCE_LANG,NAME,HELP)
4872: SELECT -1,CSF_ID,IND_GROUP_ID,LANGUAGE,MIN(SOURCE_LANG),MIN(NAME),MIN(HELP)
4873: FROM BSC_TAB_IND_GROUPS_TL
4874: GROUP BY -1,CSF_ID,IND_GROUP_ID,LANGUAGE;

Line 4876: INSERT INTO BSC_TAB_IND_GROUPS_B (TAB_ID,CSF_ID,IND_GROUP_ID,GROUP_TYPE,NAME_POSITION,

4872: SELECT -1,CSF_ID,IND_GROUP_ID,LANGUAGE,MIN(SOURCE_LANG),MIN(NAME),MIN(HELP)
4873: FROM BSC_TAB_IND_GROUPS_TL
4874: GROUP BY -1,CSF_ID,IND_GROUP_ID,LANGUAGE;
4875:
4876: INSERT INTO BSC_TAB_IND_GROUPS_B (TAB_ID,CSF_ID,IND_GROUP_ID,GROUP_TYPE,NAME_POSITION,
4877: NAME_JUSTIFICATION,LEFT_POSITION,TOP_POSITION,WIDTH,HEIGHT,SHORT_NAME)
4878: SELECT -1,CSF_ID,IND_GROUP_ID,MIN(GROUP_TYPE),MIN(NAME_POSITION),
4879: MIN(NAME_JUSTIFICATION),MIN(LEFT_POSITION),MIN(TOP_POSITION),MIN(WIDTH),MIN(HEIGHT),SHORT_NAME
4880: FROM BSC_TAB_IND_GROUPS_B

Line 4880: FROM BSC_TAB_IND_GROUPS_B

4876: INSERT INTO BSC_TAB_IND_GROUPS_B (TAB_ID,CSF_ID,IND_GROUP_ID,GROUP_TYPE,NAME_POSITION,
4877: NAME_JUSTIFICATION,LEFT_POSITION,TOP_POSITION,WIDTH,HEIGHT,SHORT_NAME)
4878: SELECT -1,CSF_ID,IND_GROUP_ID,MIN(GROUP_TYPE),MIN(NAME_POSITION),
4879: MIN(NAME_JUSTIFICATION),MIN(LEFT_POSITION),MIN(TOP_POSITION),MIN(WIDTH),MIN(HEIGHT),SHORT_NAME
4880: FROM BSC_TAB_IND_GROUPS_B
4881: GROUP BY -1,CSF_ID,IND_GROUP_ID,SHORT_NAME;
4882:
4883: -- 9. Fix OWNER_ID in BSC_TABS_B according to users in the target system.
4884: -- Update this column in the target system with the USER_ID from FND_USER