DBA Data[Home] [Help]

APPS.BSC_MIGRATION dependencies on BSC_TAB_IND_GROUPS_TL

Line 3847: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_TAB_IND_GROUPS_TL';

3843: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3844: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3845:
3846: g_num_metadata_tables := g_num_metadata_tables + 1;
3847: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_TAB_IND_GROUPS_TL';
3848: g_metadata_tables(g_num_metadata_tables).level := 1;
3849: g_metadata_tables(g_num_metadata_tables).level_column := 'TAB_ID';
3850: g_metadata_tables(g_num_metadata_tables).level_condition := NULL;
3851: 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 4871: INSERT INTO BSC_TAB_IND_GROUPS_TL (TAB_ID,CSF_ID,IND_GROUP_ID,LANGUAGE,SOURCE_LANG,NAME,HELP)

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;
4875:

Line 4873: FROM BSC_TAB_IND_GROUPS_TL

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;
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)