DBA Data[Home] [Help]

APPS.FND_OAM_DASHBOARD_UTIL dependencies on FND_OAM_METVAL_VL

Line 108: from fnd_oam_metval_vl

104: --dbms_output.put_line('POR 2: ' || v_second_portion);
105: --dbms_output.put_line('POR 3: ' || v_third_portion);
106: if (p_message_type = 'MET') then
107: select metric_display_name into v_name
108: from fnd_oam_metval_vl
109: where metric_short_name=v_first_portion;
110: select meaning into v_threshold_oper
111: from fnd_lookups
112: where lookup_type = 'OAM_DASHBOARD_THRESHOLD_OPER'

Line 124: from fnd_oam_metval_vl

120:
121: if (v_third_portion is null) then
122: -- only two portions so this is dashboard status metric
123: select metric_display_name into v_name
124: from fnd_oam_metval_vl
125: where metric_short_name=v_first_portion;
126: select meaning into v_value
127: from fnd_lookups
128: where lookup_type = 'OAM_DASHBOARD_METRIC_STATUS'