APPS.BSC_UPDATE_LOCK dependencies on BSC_DB_TABLES

Line 126: FROM bsc_db_tables

122: h_indicator NUMBER;
123:
124: CURSOR c_tables IS
125: SELECT table_name
126: FROM bsc_db_tables
127: WHERE periodicity_id IN (
128: SELECT periodicity_id
129: FROM bsc_sys_periodicities
130: WHERE calendar_id = x_calendar_id

Line 872: ' SELECT DISTINCT table_name FROM bsc_db_tables_rels'||

868:
869: -- Lock base tables used by the dimension or any of the child dimensions
870: h_sql := 'SELECT DISTINCT bt.table_name'||
871: ' FROM ('||
872: ' SELECT DISTINCT table_name FROM bsc_db_tables_rels'||
873: ' WHERE source_table_name IN ('||
874: ' SELECT table_name FROM bsc_db_tables WHERE table_type = :1)) bt,'||
875: ' bsc_db_tables_cols c'||
876: ' WHERE bt.table_name = c.table_name AND'||

Line 874: ' SELECT table_name FROM bsc_db_tables WHERE table_type = :1)) bt,'||

870: h_sql := 'SELECT DISTINCT bt.table_name'||
871: ' FROM ('||
872: ' SELECT DISTINCT table_name FROM bsc_db_tables_rels'||
873: ' WHERE source_table_name IN ('||
874: ' SELECT table_name FROM bsc_db_tables WHERE table_type = :1)) bt,'||
875: ' bsc_db_tables_cols c'||
876: ' WHERE bt.table_name = c.table_name AND'||
877: ' c.column_type = :2 AND c.column_name IN ('||
878: ' SELECT level_pk_col FROM bsc_sys_dim_levels_b'||

Line 875: ' bsc_db_tables_cols c'||

871: ' FROM ('||
872: ' SELECT DISTINCT table_name FROM bsc_db_tables_rels'||
873: ' WHERE source_table_name IN ('||
874: ' SELECT table_name FROM bsc_db_tables WHERE table_type = :1)) bt,'||
875: ' bsc_db_tables_cols c'||
876: ' WHERE bt.table_name = c.table_name AND'||
877: ' c.column_type = :2 AND c.column_name IN ('||
878: ' SELECT level_pk_col FROM bsc_sys_dim_levels_b'||
879: ' WHERE '||h_cond_for_base_tables||')';

Line 1193: from bsc_db_tables_rels

1189: h_i NUMBER;
1190:
1191: CURSOR c_indic_tables IS
1192: select distinct table_name
1193: from bsc_db_tables_rels
1194: start with table_name in (
1195: select distinct table_name
1196: from bsc_kpi_data_tables
1197: where indicator = x_indicator and

Line 1256: from bsc_db_tables_rels

1252: h_i NUMBER;
1253:
1254: CURSOR c_source_tables IS
1255: select distinct source_table_name
1256: from bsc_db_tables_rels
1257: where table_name = x_summary_table;
1258:
1259: h_table_name VARCHAR2(50);
1260:

Line 1313: from bsc_db_tables

1309: h_i NUMBER;
1310:
1311: CURSOR c_other_tables (p_like_name varchar2) IS
1312: select distinct table_name
1313: from bsc_db_tables
1314: where table_name like p_like_name;
1315:
1316: CURSOR c_source_tables (p_like_name varchar2) IS
1317: select distinct source_table_name

Line 1318: from bsc_db_tables_rels

1314: where table_name like p_like_name;
1315:
1316: CURSOR c_source_tables (p_like_name varchar2) IS
1317: select distinct source_table_name
1318: from bsc_db_tables_rels
1319: where table_name like p_like_name;
1320:
1321: h_table_name VARCHAR2(50);
1322: h_like_name VARCHAR2(50);

Line 1402: from bsc_db_tables_rels

1398: h_i NUMBER;
1399:
1400: CURSOR c_source_tables IS
1401: select distinct source_table_name
1402: from bsc_db_tables_rels
1403: where table_name = x_summary_table;
1404:
1405: h_table_name VARCHAR2(50);
1406: