DBA Data[Home] [Help]

APPS.BSC_MO_INDICATOR_PKG dependencies on BSC_DB_MEASURE_BY_DIM_SET_V

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