eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MO_UI_PKG dependencies on BSC_DB_TABLES

Line 55: FROM BSC_DB_TABLES_RELS rels

51: If numTables > 0 Then
52: --insert the children
53: l_stmt := ' INSERT INTO '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND (session_id, variable_id, value_v)
54: SELECT distinct userenv(''SESSIONID''), 0, TABLE_NAME
55: FROM BSC_DB_TABLES_RELS rels
56: where source_table_name IN
57: (SELECT /*+ index(tmp bsc_tmp_big_in_cond_n1)*/
58: tmp.value_v
59: from bsc_tmp_big_in_cond tmp

Line 72: FROM BSC_DB_TABLES_RELS

68:
69: --insert the parents
70: l_stmt := 'INSERT INTO '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND (session_id, variable_id, value_v)
71: SELECT distinct userenv(''SESSIONID''), 0, SOURCE_TABLE_NAME
72: FROM BSC_DB_TABLES_RELS
73: WHERE table_name IN
74: (SELECT /*+ index(cond bsc_tmp_big_in_cond_n1)*/ value_v
75: from BSC_TMP_BIG_IN_COND WHERE session_id = userenv(''SESSIONID'') and variable_id = 0)
76: minus

Line 368: FROM BSC_DB_TABLES_RELS

364: INSTR(TABLE_NAME,''_'',1,3)-INSTR(TABLE_NAME,''_'',1,2)-1
365: )
366: ),
367: TABLE_NAME
368: FROM BSC_DB_TABLES_RELS
369: WHERE TABLE_NAME LIKE ''BSC_S%''
370: AND (SOURCE_TABLE_NAME LIKE ''BSC_B%''
371: OR SOURCE_TABLE_NAME LIKE ''BSC_T%'')';
372: execute immediate l_stmt;

Line 647: --BSC_DB_TABLES

643: return;
644: END IF;
645:
646:
647: --BSC_DB_TABLES
648: UPDATE BSC_DB_TABLES set table_name = pNew where table_name = pOld;
649:
650: --BSC_DB_TABLES_COLS
651: UPDATE BSC_DB_TABLES_COLS set table_name = pNew where table_name = pOld;

Line 648: UPDATE BSC_DB_TABLES set table_name = pNew where table_name = pOld;

644: END IF;
645:
646:
647: --BSC_DB_TABLES
648: UPDATE BSC_DB_TABLES set table_name = pNew where table_name = pOld;
649:
650: --BSC_DB_TABLES_COLS
651: UPDATE BSC_DB_TABLES_COLS set table_name = pNew where table_name = pOld;
652:

Line 650: --BSC_DB_TABLES_COLS

646:
647: --BSC_DB_TABLES
648: UPDATE BSC_DB_TABLES set table_name = pNew where table_name = pOld;
649:
650: --BSC_DB_TABLES_COLS
651: UPDATE BSC_DB_TABLES_COLS set table_name = pNew where table_name = pOld;
652:
653: --BSC_DB_TABLES_RELS
654: UPDATE BSC_DB_TABLES_RELS set source_table_name = pNew where source_table_name = pOld;

Line 651: UPDATE BSC_DB_TABLES_COLS set table_name = pNew where table_name = pOld;

647: --BSC_DB_TABLES
648: UPDATE BSC_DB_TABLES set table_name = pNew where table_name = pOld;
649:
650: --BSC_DB_TABLES_COLS
651: UPDATE BSC_DB_TABLES_COLS set table_name = pNew where table_name = pOld;
652:
653: --BSC_DB_TABLES_RELS
654: UPDATE BSC_DB_TABLES_RELS set source_table_name = pNew where source_table_name = pOld;
655:

Line 653: --BSC_DB_TABLES_RELS

649:
650: --BSC_DB_TABLES_COLS
651: UPDATE BSC_DB_TABLES_COLS set table_name = pNew where table_name = pOld;
652:
653: --BSC_DB_TABLES_RELS
654: UPDATE BSC_DB_TABLES_RELS set source_table_name = pNew where source_table_name = pOld;
655:
656: -- Need not update BSC_DB_CALCULATIONS as it wont have anything for Input tables
657: execute immediate 'alter table '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.'||pOld||' rename to '||pNew;

Line 654: UPDATE BSC_DB_TABLES_RELS set source_table_name = pNew where source_table_name = pOld;

650: --BSC_DB_TABLES_COLS
651: UPDATE BSC_DB_TABLES_COLS set table_name = pNew where table_name = pOld;
652:
653: --BSC_DB_TABLES_RELS
654: UPDATE BSC_DB_TABLES_RELS set source_table_name = pNew where source_table_name = pOld;
655:
656: -- Need not update BSC_DB_CALCULATIONS as it wont have anything for Input tables
657: execute immediate 'alter table '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.'||pOld||' rename to '||pNew;
658: begin

Line 836: FROM BSC_DB_TABLES

832: cRow cCols%ROWTYPE;
833: l_count NUMBER := 0;
834: CURSOR cTable (l_table IN VARCHAR2) IS
835: SELECT TABLE_NAME, TABLE_TYPE, PERIODICITY_ID, EDW_FLAG, TARGET_FLAG
836: FROM BSC_DB_TABLES
837: WHERE TABLE_TYPE <> 2
838: AND TABLE_NAME = l_table
839: ORDER BY TABLE_NAME;
840: cRow1 cTable%ROWTYPE;

Line 876: select count(1) into l_test from bsc_db_tables tab, bsc_db_tables_rels rels

872: End If;
873:
874: If BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV Then
875:
876: select count(1) into l_test from bsc_db_tables tab, bsc_db_tables_rels rels
877: where rels.table_name = l_table_name
878: and rels.source_table_name = tab.table_name
879: and tab.table_type = 0 ; -- input table
880: IF (l_test > 0) THEN

Line 1032: select Name from bsc_sys_dim_levels_vl, bsc_Db_tables_rels r

1028:
1029: cursor getDimObjName IS
1030: select Name from bsc_sys_dim_levels_vl where LEVEL_TABLE_NAME = pTableName
1031: UNION
1032: select Name from bsc_sys_dim_levels_vl, bsc_Db_tables_rels r
1033: where LEVEL_TABLE_NAME = r.table_name
1034: and r.source_table_name = pTableName;
1035:
1036: cursor getDimObjNameForMN(l_schema IN VARCHAR2) IS

Line 1045: bsc_sys_dim_levels_vl lvl, bsc_db_tables_rels r

1041: and cols.column_name = upper(lvl.level_pk_col)
1042: union
1043: select lvl.name, cols.column_name
1044: from all_tab_columns cols,
1045: bsc_sys_dim_levels_vl lvl, bsc_db_tables_rels r
1046: where r.source_table_name = pTableName
1047: and cols.table_name = r.TABLE_NAME
1048: and cols.owner = l_schema
1049: and cols.column_name = upper(lvl.level_pk_col)