APPS.BSC_MO_HELPER_PKG dependencies on BSC_DB_MEASURE_COLS_VL

Line 2894: --because in BSC_DB_MEASURE_COLS_VL are only BSC measures

2890:
2891: l_stmt varchar2(1000);
2892: FieldLOV BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;
2893: --BSC-PMF Integration: It is not necessary to filter out PMF measures
2894: --because in BSC_DB_MEASURE_COLS_VL are only BSC measures
2895: --CURSOR c1 IS
2896: --SELECT MEASURE_COL, HELP, MEASURE_GROUP_ID, PROJECTION_ID, NVL(MEASURE_TYPE, 1) MTYPE
2897: --FROM BSC_DB_MEASURE_COLS_VL ORDER BY MEASURE_COL ;
2898:

Line 2897: --FROM BSC_DB_MEASURE_COLS_VL ORDER BY MEASURE_COL ;

2893: --BSC-PMF Integration: It is not necessary to filter out PMF measures
2894: --because in BSC_DB_MEASURE_COLS_VL are only BSC measures
2895: --CURSOR c1 IS
2896: --SELECT MEASURE_COL, HELP, MEASURE_GROUP_ID, PROJECTION_ID, NVL(MEASURE_TYPE, 1) MTYPE
2897: --FROM BSC_DB_MEASURE_COLS_VL ORDER BY MEASURE_COL ;
2898:
2899: --BSC-PMF Integration: Need to filter out PMF measures
2900:
2901: /*CURSOR c1 IS

Line 2903: FROM BSC_DB_MEASURE_COLS_VL

2899: --BSC-PMF Integration: Need to filter out PMF measures
2900:
2901: /*CURSOR c1 IS
2902: SELECT MEASURE_COL, HELP, MEASURE_GROUP_ID, PROJECTION_ID, NVL(MEASURE_TYPE, 1) MTYPE
2903: FROM BSC_DB_MEASURE_COLS_VL
2904: WHERE MEASURE_COL NOT IN
2905: (
2906: SELECT MEASURE_COL FROM BSC_SYS_MEASURES M
2907: WHERE NVL(M.SOURCE, 'BSC') = 'PMF'

Line 2915: FROM BSC_DB_MEASURE_COLS_VL DB,

2911: --BSC autogen
2912:
2913: CURSOR c1 IS
2914: SELECT DB.MEASURE_COL, DB.HELP, DB.MEASURE_GROUP_ID, DB.PROJECTION_ID, NVL(DB.MEASURE_TYPE, 1) MTYPE, M.SOURCE
2915: FROM BSC_DB_MEASURE_COLS_VL DB,
2916: BSC_SYS_MEASURES M
2917: WHERE db.Measure_Col = m.measure_col
2918: AND M.SOURCE = 'BSC'
2919: UNION