APPS.BSC_MO_INDICATOR_PKG dependencies on BSC_SYS_MEASURES

Line 974: FROM BSC_SYS_MEASURES M, '||BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||' I,

970:
971: PROCEDURE init_measure_counts(l_list IN DBMS_SQL.number_table) IS
972: l_dummy varchar2(1000);
973: l_stmt varchar2(4000) := 'SELECT kpi.indicator||''_''|| i.dim_set_id hash_index, COUNT(M.MEASURE_COL) NUM_DATA_COLUMNS
974: FROM BSC_SYS_MEASURES M, '||BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||' I,
975: BSC_KPIS_VL kpi
976: WHERE I.MEASURE_ID = M.MEASURE_ID
977: AND kpi.indicator = i.indicator
978: AND M.TYPE = 0

Line 1014: FROM BSC_SYS_MEASURES M, '||BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||' I

1010: Function GetNumDataColumns(Indic IN NUMBER, DimSet IN NUMBER) RETURN NUMBER IS
1011:
1012: l_stmt varchar2(10000) :=
1013: 'SELECT COUNT(M.MEASURE_COL) NUM_DATA_COLUMNS
1014: FROM BSC_SYS_MEASURES M, '||BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||' I
1015: WHERE I.MEASURE_ID = M.MEASURE_ID
1016: AND I.DIM_SET_ID = :1
1017: AND I.INDICATOR = :2
1018: AND M.TYPE = 0

Line 1028: FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I

1024: select count(1) from user_objects where object_name = BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table;
1025:
1026: CURSOR cNumCols(pIgnore VARCHAR2) IS
1027: SELECT COUNT(M.MEASURE_COL) NUM_DATA_COLUMNS
1028: FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I
1029: WHERE I.MEASURE_ID = M.MEASURE_ID
1030: AND I.DIM_SET_ID = DimSet
1031: AND I.INDICATOR = Indic
1032: AND M.TYPE = 0

Line 3191: UPDATE BSC_SYS_MEASURES

3187: IS
3188: l_stmt VARCHAR2(1000);
3189:
3190: BEGIN
3191: UPDATE BSC_SYS_MEASURES
3192: SET S_COLOR_FORMULA = BSC_APPS.SET_PROPERTY_VALUE(S_COLOR_FORMULA, propertyName, propertyValue)
3193: WHERE UPPER(MEASURE_COL) = upper(dataColumn)
3194: AND TYPE = 0 AND NVL(SOURCE, 'BSC') = 'BSC';
3195:

Line 3221: FROM BSC_SYS_MEASURES

3217: SELECT NVL(OPERATION, 'SUM') AS OPER,
3218: NVL(BSC_APPS.GET_PROPERTY_VALUE(S_COLOR_FORMULA, p1),'N') AS PAVGL,
3219: BSC_APPS.GET_PROPERTY_VALUE(S_COLOR_FORMULA, p2) AS PAVGLTOTAL,
3220: BSC_APPS.GET_PROPERTY_VALUE(S_COLOR_FORMULA, p3) AS PAVGLCOUNTER
3221: FROM BSC_SYS_MEASURES
3222: WHERE UPPER(MEASURE_COL) = UPPER(p4)
3223: AND TYPE = 0
3224: AND NVL(SOURCE, 'BSC') = 'BSC';
3225:

Line 3480: FROM BSC_SYS_MEASURES M, '||BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||' I

3476: BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :3) AS PAVGLTOTAL,
3477: BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :4) AS PAVGLCOUNTER '||
3478: -- BSC Autogen
3479: ', nvl(M.SOURCE, ''BSC'')
3480: FROM BSC_SYS_MEASURES M, '||BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||' I
3481: WHERE I.MEASURE_ID = M.MEASURE_ID
3482: AND I.DIM_SET_ID = :5
3483: AND I.INDICATOR = :6
3484: AND M.TYPE = 0';