APPS.FND_OAM_DASHBOARD_UTIL dependencies on FND_LOOKUPS

Line 111: from fnd_lookups

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'
113: and lookup_code = v_second_portion;
114: v_value := v_third_portion;
115:

Line 127: from fnd_lookups

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'
129: and lookup_code = v_second_portion;
130: else
131: -- three portions so this is a service instance

Line 137: from fnd_lookups

133: from fnd_concurrent_queues_vl
134: where to_char(application_id) = v_first_portion
135: and to_char(concurrent_queue_id) = v_second_portion;
136: select meaning into v_value
137: from fnd_lookups
138: where lookup_type = 'OAM_DASHBOARD_METRIC_STATUS'
139: and lookup_code = v_third_portion;
140: end if;
141:

Line 336: -- look_up codes from the fnd_lookups table

332: -- get_meaning
333: --
334: -- Purpose
335: -- Gets the meaning for the given lookup_type and comma seperated
336: -- look_up codes from the fnd_lookups table
337: --
338: -- Input Arguments
339: -- p_lookup_type - Look up type (String)
340: -- p_lookup_codes - Comma separated lookup codes with no space in between

Line 374: from fnd_lookups

370: --dbms_output.put_line('v_remainder: ' || v_remainder);
371: v_entity := substr(v_remainder,1,instr(v_remainder,',',1,1) -1);
372:
373: select meaning into v_status
374: from fnd_lookups
375: where lookup_type = p_lookup_type
376: and lookup_code = v_entity;
377:
378: