APPS.BSC_MO_DOC_PKG dependencies on BSC_DB_TABLES_RELS

Line 1136: ( select table_name from bsc_db_tables_rels

1132: 'WITH main_indics AS
1133: (select distinct to_number(substr(table_name, instr(table_name, ''_'', 1, 2)+1,
1134: instr(table_name,''_'',1,3)-instr(table_name,''_'',1,2)-1)) indicator
1135: from
1136: ( select table_name from bsc_db_tables_rels
1137: where source_table_name not like ''BSC_S%''
1138: and table_name like ''BSC_S%''
1139: connect by source_table_name = prior table_name
1140: start with source_table_name = :l_table_name)

Line 1257: FROM BSC_DB_TABLES_RELS

1253: cRow2 c2%ROWTYPE;
1254:
1255: CURSOR c3(p1 VARCHAR2, p2 IN NUMBER) IS
1256: SELECT SOURCE_TABLE_NAME
1257: FROM BSC_DB_TABLES_RELS
1258: WHERE TABLE_NAME = p1
1259: AND RELATION_TYPE = p2
1260: ORDER BY SOURCE_TABLE_NAME;
1261: cRow3 c3%ROWTYPE;

Line 1302: SELECT SOURCE_TABLE_NAME FROM BSC_DB_TABLES_RELS

1298: if (BSC_METADATA_OPTIMIZER_PKG.gGAA_RUN_MODE<>0) then
1299: l_stmt := l_stmt||
1300: ' and table_name in
1301: (
1302: SELECT SOURCE_TABLE_NAME FROM BSC_DB_TABLES_RELS
1303: CONNECT BY TABLE_NAME=prior SOURCE_TABLE_NAME
1304: START WITH table_name in
1305: (
1306: select table_name from bsc_db_tables dbtbl, bsc_tmp_opt_ui_kpis