APPS.BSC_MO_HELPER_PKG dependencies on BSC_SYS_DIM_LEVELS_B

Line 18: from bsc_sys_dim_levels_b sysdim,

14: -- Bug 4937922 change to new api which returns error message correctly
15: -- Moved API from PL/SQL for loop into SQL itself for performance
16: cursor cMissingViews is
17: select distinct sysdim.short_name, sysdim.level_view_name
18: from bsc_sys_dim_levels_b sysdim,
19: bsc_kpi_dim_levels_b kpidim,
20: bsc_tmp_opt_ui_kpis proc
21: where proc.process_id = bsc_metadata_optimizer_pkg.g_ProcessID
22: and proc.indicator=kpidim.indicator

Line 29: , bsc_sys_dim_levels_b sysdim

25: and BIS_UTILITIES_PVT.is_rolling_period_level(sysdim.short_name) = 0
26: minus
27: select sysdim.short_name, sysdim.level_view_name
28: from user_views vws
29: , bsc_sys_dim_levels_b sysdim
30: where vws.view_name=sysdim.level_view_name;
31:
32: x_return_status varchar2(1000);
33: x_msg_count number;

Line 6152: from bsc_sys_dim_levels_b lvl

6148:
6149: PROCEDURE drop_unused_mvlogs IS
6150: CURSOR cDropThese IS
6151: select distinct level_table_name
6152: from bsc_sys_dim_levels_b lvl
6153: , all_snapshot_logs log
6154: where log.log_owner=BSC_METADATA_OPTIMIZER_PKG.gBSCSchema
6155: and log.master = lvl.level_Table_name
6156: minus

Line 6158: from bsc_sys_dim_levels_b lvl

6154: where log.log_owner=BSC_METADATA_OPTIMIZER_PKG.gBSCSchema
6155: and log.master = lvl.level_Table_name
6156: minus
6157: select distinct level_table_name
6158: from bsc_sys_dim_levels_b lvl
6159: , all_snapshot_logs log
6160: , all_dependencies db
6161: , all_mviews mv
6162: where log.log_owner=BSC_METADATA_OPTIMIZER_PKG.gBSCSchema

Line 7117: FROM BSC_SYS_DIM_LEVELS_B S, BSC_DB_TABLES_RELS R

7113: cv CurTyp;
7114: cursor c1 is
7115: SELECT S.DIM_LEVEL_ID, S.LEVEL_TABLE_NAME, S.TABLE_TYPE, S.source,
7116: S.LEVEL_PK_COL, S.USER_KEY_SIZE, S.DISP_KEY_SIZE, NVL(S.EDW_FLAG, 0) AS EDW_FLAG, R.SOURCE_TABLE_NAME
7117: FROM BSC_SYS_DIM_LEVELS_B S, BSC_DB_TABLES_RELS R
7118: WHERE S.LEVEL_TABLE_NAME = R.TABLE_NAME (+)
7119: ORDER BY LEVEL_TABLE_NAME;
7120: cRow1 c1%ROWTYPE;
7121:

Line 7133: FROM BSC_SYS_DIM_LEVELS_B D, BSC_SYS_DIM_LEVEL_RELS R

7129:
7130:
7131: cursor C2 (p_dimID IN NUMBER, p_relation_type number)is
7132: SELECT D.LEVEL_TABLE_NAME, D.LEVEL_PK_COL
7133: FROM BSC_SYS_DIM_LEVELS_B D, BSC_SYS_DIM_LEVEL_RELS R
7134: WHERE D.DIM_LEVEL_ID = R.PARENT_DIM_LEVEL_ID
7135: AND R.DIM_LEVEL_ID = p_dimID
7136: AND R.RELATION_TYPE = p_relation_type;
7137:

Line 7162: FROM BSC_SYS_DIM_LEVELS_B A,

7158: SELECT A.LEVEL_TABLE_NAME AS TABLE_A,
7159: A.LEVEL_PK_COL AS PK_COL_A,
7160: B.LEVEL_TABLE_NAME AS TABLE_B,
7161: B.LEVEL_PK_COL AS PK_COL_B
7162: FROM BSC_SYS_DIM_LEVELS_B A,
7163: BSC_SYS_DIM_LEVEL_RELS R,
7164: BSC_SYS_DIM_LEVELS_B B
7165: WHERE
7166: A.DIM_LEVEL_ID = R.DIM_LEVEL_ID AND

Line 7164: BSC_SYS_DIM_LEVELS_B B

7160: B.LEVEL_TABLE_NAME AS TABLE_B,
7161: B.LEVEL_PK_COL AS PK_COL_B
7162: FROM BSC_SYS_DIM_LEVELS_B A,
7163: BSC_SYS_DIM_LEVEL_RELS R,
7164: BSC_SYS_DIM_LEVELS_B B
7165: WHERE
7166: A.DIM_LEVEL_ID = R.DIM_LEVEL_ID AND
7167: R.PARENT_DIM_LEVEL_ID = B.DIM_LEVEL_ID AND
7168: UPPER(R.RELATION_COL) = upper(pRelation);