APPS.BSC_UPDATE_DIM dependencies on BSC_DB_TABLES

Line 743: FROM bsc_db_tables_rels

739: CURSOR c_system_tables (p_col_name1 VARCHAR2, p_col_name2 VARCHAR2,
740: p_col_type VARCHAR2, p_table_type NUMBER, p_count NUMBER) IS
741: SELECT DISTINCT bt.table_name
742: FROM (SELECT DISTINCT table_name
743: FROM bsc_db_tables_rels
744: WHERE source_table_name IN (
745: SELECT table_name
746: FROM bsc_db_tables
747: WHERE table_type = p_table_type)

Line 746: FROM bsc_db_tables

742: FROM (SELECT DISTINCT table_name
743: FROM bsc_db_tables_rels
744: WHERE source_table_name IN (
745: SELECT table_name
746: FROM bsc_db_tables
747: WHERE table_type = p_table_type)
748: ) bt,
749: bsc_db_tables_cols c
750: WHERE bt.table_name = c.table_name AND

Line 749: bsc_db_tables_cols c

745: SELECT table_name
746: FROM bsc_db_tables
747: WHERE table_type = p_table_type)
748: ) bt,
749: bsc_db_tables_cols c
750: WHERE bt.table_name = c.table_name AND
751: (c.column_name = p_col_name1 OR
752: c.column_name = p_col_name2) AND
753: c.column_type = p_col_type

Line 836: FROM bsc_db_tables_rels

832: -- BSC-MV Note: Change query to get only base tables. This logic is valid for both architectures
833: CURSOR c_affected_tables (p_col_name VARCHAR2, p_col_type VARCHAR2, p_table_type NUMBER) IS
834: SELECT DISTINCT bt.table_name
835: FROM (SELECT DISTINCT table_name
836: FROM bsc_db_tables_rels
837: WHERE source_table_name IN (
838: SELECT table_name
839: FROM bsc_db_tables
840: WHERE table_type = p_table_type)

Line 839: FROM bsc_db_tables

835: FROM (SELECT DISTINCT table_name
836: FROM bsc_db_tables_rels
837: WHERE source_table_name IN (
838: SELECT table_name
839: FROM bsc_db_tables
840: WHERE table_type = p_table_type)
841: ) bt,
842: bsc_db_tables_cols c
843: WHERE bt.table_name = c.table_name AND

Line 842: bsc_db_tables_cols c

838: SELECT table_name
839: FROM bsc_db_tables
840: WHERE table_type = p_table_type)
841: ) bt,
842: bsc_db_tables_cols c
843: WHERE bt.table_name = c.table_name AND
844: c.column_name = p_col_name AND
845: c.column_type = p_col_type;
846:

Line 1964: ' FROM bsc_db_tables_rels'||

1960:
1961: BEGIN
1962: /*
1963: h_sql := 'SELECT table_name'||
1964: ' FROM bsc_db_tables_rels'||
1965: ' WHERE source_table_name = :1';
1966: OPEN h_cursor FOR h_sql USING x_input_table;
1967: FETCH h_cursor INTO h_table_name;
1968: CLOSE h_cursor;

Line 1972: FROM bsc_db_tables_rels

1968: CLOSE h_cursor;
1969: */
1970: SELECT table_name
1971: INTO h_table_name
1972: FROM bsc_db_tables_rels
1973: WHERE source_table_name = x_input_table;
1974:
1975: RETURN h_table_name;
1976:

Line 3464: FROM bsc_db_tables

3460:
3461: -- Get loading mode
3462: SELECT generation_type
3463: INTO h_loading_mode
3464: FROM bsc_db_tables
3465: WHERE table_name = x_input_table;
3466:
3467: -- Get dimension table type (1n or MN)
3468: h_dim_table_type := Get_Dim_Table_Type(x_dim_table);

Line 4932: ' FROM bsc_db_tables'||

4928:
4929: -- Get loading mode
4930: /*
4931: h_sql := 'SELECT generation_type'||
4932: ' FROM bsc_db_tables'||
4933: ' WHERE table_name = :1';
4934: OPEN h_cursor FOR h_sql USING x_input_table;
4935: FETCH h_cursor INTO h_loading_mode;
4936: CLOSE h_cursor;

Line 4940: FROM bsc_db_tables

4936: CLOSE h_cursor;
4937: */
4938: SELECT generation_type
4939: INTO h_loading_mode
4940: FROM bsc_db_tables
4941: WHERE table_name = x_input_table;
4942:
4943: h_null := BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'NULL');
4944: --Fix bug#2562867 The lookup can contain single quotes