APPS.BSC_DBGEN_UTILS dependencies on BSC_DB_TABLES

Line 382: select source_table_name from bsc_db_tables_rels

378: END;
379:
380: FUNCTION get_source_table_names(p_table_name IN VARCHAR2) RETURN DBMS_SQL.VARCHAR2_TABLE IS
381: CURSOR cList IS
382: select source_table_name from bsc_db_tables_rels
383: connect by table_name = prior source_table_name
384: start with table_name = p_table_name;
385: l_list DBMS_SQL.VARCHAR2_TABLE;
386: BEGIN

Line 404: from bsc_db_tables tbl,

400: IS
401: l_table_type VARCHAR2(10);
402: CURSOR cTableType IS
403: select count(1)
404: from bsc_db_tables tbl,
405: bsc_db_tables_rels rels
406: where
407: rels.table_name = p_table_name
408: and rels.source_table_name = tbl.table_name

Line 405: bsc_db_tables_rels rels

401: l_table_type VARCHAR2(10);
402: CURSOR cTableType IS
403: select count(1)
404: from bsc_db_tables tbl,
405: bsc_db_tables_rels rels
406: where
407: rels.table_name = p_table_name
408: and rels.source_table_name = tbl.table_name
409: and tbl.table_type = 0;

Line 416: SELECT table_type INTO l_table_type FROM BSC_DB_TABLES where table_name = p_table_name;

412: IF (g_initialized=false) THEN
413: init;
414: END IF;
415: BEGIN
416: SELECT table_type INTO l_table_type FROM BSC_DB_TABLES where table_name = p_table_name;
417: EXCEPTION WHEN OTHERS THEN
418: SELECT count(1) INTO l_table_type FROM BSC_SYS_DIM_LEVELS_B where level_table_name = p_table_name;
419: IF l_table_type <>0 THEN
420: return 'D';

Line 545: from bsc_db_Tables_rels rels

541: CURSOR cTables IS
542: select distinct indicator from bsc_kpi_data_tables where
543: table_name in (
544: select distinct rels.table_name
545: from bsc_db_Tables_rels rels
546: connect by prior table_name=source_table_name
547: start with rels.source_table_name = p_b_table_name);
548:
549: BEGIN