APPS.BSC_DBGEN_BSC_READER dependencies on BSC_DB_MEASURE_COLS_VL

Line 137: FROM BSC_DB_MEASURE_COLS_VL ms,

133: l_measure_null BSC_DBGEN_STD_METADATA.clsMeasure;
134: --BSC-PMF Integration: Need to filter out PMF measures
135: CURSOR c1 IS
136: SELECT ms.MEASURE_COL, ms.HELP, ms.MEASURE_GROUP_ID, ms.PROJECTION_ID, NVL(ms.MEASURE_TYPE, 1) MTYPE, sysm.source
137: FROM BSC_DB_MEASURE_COLS_VL ms,
138: BSC_SYS_MEASURES sysm
139: WHERE ms.measure_col = sysm.measure_col
140: ORDER BY MEASURE_COL;
141: cRow c1%ROWTYPE;

Line 567: FROM BSC_SYS_MEASURES M, BSC_DB_TABLES_COLS C, BSC_DB_MEASURE_COLS_VL COLS

563: NVL(BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :2 ),''N'') AS PAVGL,
564: BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :3) AS PAVGLTOTAL,
565: BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :4) AS PAVGLCOUNTER,
566: M.MEASURE_ID, nvl(cols.measure_type, 1) measure_type, m.source
567: FROM BSC_SYS_MEASURES M, BSC_DB_TABLES_COLS C, BSC_DB_MEASURE_COLS_VL COLS
568: WHERE M.MEASURE_COL(+) = C.COLUMN_NAME
569: AND COLS.measure_col(+) = c.column_name
570: AND C.COLUMN_TYPE = ''A''
571: AND C.TABLE_NAME LIKE ''BSC_S%'||p_fact||'_'||p_dim_set||'%'||'''

Line 1378: FROM BSC_DB_MEASURE_COLS_VL COLS , BSC_SYS_MEASURES sysm

1374: AND NVL(M.SOURCE, 'BSC') in('PMF', 'BSC');
1375:
1376: CURSOR cProperties(p_col VARCHAR2) IS
1377: SELECT sysm.measure_id, nvl(COLS.MEASURE_GROUP_ID,-1) measure_group_id, nvl(COLS.PROJECTION_ID, 0) projection_id , NVL(COLS.MEASURE_TYPE, 1) MEASURE_TYPE
1378: FROM BSC_DB_MEASURE_COLS_VL COLS , BSC_SYS_MEASURES sysm
1379: WHERE sysm.measure_col = cols.measure_col(+)
1380: AND sysm.measure_col = p_col;
1381: l_measure_row cProperties%ROWTYPE;
1382: ColMeasures BSC_DBGEN_STD_METADATA.tab_clsMeasure;

Line 1909: BSC_DB_MEASURE_COLS_VL measures,

1905: , NVL(measures.MEASURE_TYPE, 1) MEASURE_TYPE
1906: , sysm.MEASURE_ID
1907: From bsc_db_tables_cols s_table,
1908: bsc_db_tables_cols b_table,
1909: BSC_DB_MEASURE_COLS_VL measures,
1910: BSC_SYS_MEASURES sysm
1911: where s_table.table_name = p_s_table
1912: and b_table.table_name = p_base_table
1913: and s_table.column_name = b_table.column_name

Line 1925: BSC_DB_MEASURE_COLS_VL measures,

1921: sysm.MEASURE_ID
1922: from
1923: bsc_db_tables_cols s_table,
1924: bsc_db_tables_cols b_table,
1925: BSC_DB_MEASURE_COLS_VL measures,
1926: BSC_SYS_MEASURES sysm
1927: where s_table.table_name =p_s_table
1928: and b_table.table_name = p_base_table
1929: and s_table.column_name = b_table.column_name

Line 1940: BSC_DB_MEASURE_COLS_VL measures,

1936: sysm.MEASURE_ID
1937: from
1938: bsc_db_tables_cols s_table,
1939: bsc_db_tables_cols b_table,
1940: BSC_DB_MEASURE_COLS_VL measures,
1941: BSC_SYS_MEASURES sysm
1942: where s_table.table_name =p_s_table
1943: and b_table.table_name(+) = p_base_table
1944: and s_table.column_name = b_table.column_name(+)