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_SYS_DIM_LEVELS_VL

Line 825: bsc_sys_dim_levels_vl lvl

821:
822: FUNCTION GetDescriptionForColumn(pTableName IN VARCHAR2, pColumnName IN VARCHAR2) RETURN VARCHAR2 IS
823: cursor cCols IS
824: select lvl.help description from
825: bsc_sys_dim_levels_vl lvl
826: where
827: upper(pColumnName) = upper(lvl.level_pk_col)
828: UNION
829: select measure.help description from

Line 997: bsc_sys_dim_levels_vl lvl

993: cursor cDims (l_schema IN VARCHAR2) IS
994: select lvl.name, cols.column_name
995: from
996: all_tab_columns cols,
997: bsc_sys_dim_levels_vl lvl
998: where cols.table_name = pTableName
999: and cols.owner = l_schema
1000: and cols.column_name = upper(lvl.level_pk_col)
1001: and cols.column_name not in ('YEAR', 'TYPE', 'PERIOD', 'TIME_FK', 'PERIODICITY_ID', 'PERIOD_TYPE_ID')

Line 1023: bsc_sys_dim_levels_vl lvl

1019: and cols.column_name not in
1020: (select cols.column_name
1021: from
1022: all_tab_columns cols,
1023: bsc_sys_dim_levels_vl lvl
1024: where cols.table_name = pTableName
1025: and cols.owner = l_schema
1026: and cols.column_name = upper(lvl.level_pk_col))
1027: order by datasets.name,cols.column_name; --order by clause for bug 3869698

Line 1030: select Name from bsc_sys_dim_levels_vl where LEVEL_TABLE_NAME = pTableName

1026: and cols.column_name = upper(lvl.level_pk_col))
1027: order by datasets.name,cols.column_name; --order by clause for bug 3869698
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;

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 1038: from all_tab_columns cols, bsc_sys_dim_levels_vl lvl

1034: and r.source_table_name = pTableName;
1035:
1036: cursor getDimObjNameForMN(l_schema IN VARCHAR2) IS
1037: select lvl.name, cols.column_name
1038: from all_tab_columns cols, bsc_sys_dim_levels_vl lvl
1039: where cols.table_name = pTableName
1040: and cols.owner = l_schema
1041: and cols.column_name = upper(lvl.level_pk_col)
1042: union

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)