APPS.FND_OAM_EM dependencies on FND_OAM_METVAL

Line 159: FROM fnd_oam_metval fom

155: (
156: SELECT fom.METRIC_SHORT_NAME metric_name,
157: fom.METRIC_VALUE value,
158: to_char(fom.LAST_UPDATE_DATE,'yyyy/MM/dd HH:mm:ss') last_update
159: FROM fnd_oam_metval fom
160: WHERE fom.METRIC_SHORT_NAME in
161: ('PATCHES','PROFILE_OPT','CONTEXT_FILES_EDITED','INVALID_OBJECTS')
162: )
163: LOOP

Line 208: FROM fnd_oam_metval fom

204: (
205: SELECT fom.METRIC_SHORT_NAME metric_name,
206: decode(to_char(fom.status_code),NULL,'NA','2','DOWN','0','UP','1','WARNING','3','NOT_STARTED','NA') value,
207: to_char(fom.LAST_UPDATE_DATE,'yyyy/MM/dd HH:mm:ss') last_update
208: FROM fnd_oam_metval fom
209: WHERE fom.GROUP_ID = 8
210: )
211: LOOP
212: EXIT WHEN SQL%NOTFOUND;

Line 264: FROM fnd_oam_metval fom

260: (
261: SELECT fom.METRIC_SHORT_NAME metric_name,
262: fom.METRIC_VALUE value,
263: to_char(fom.LAST_UPDATE_DATE,'yyyy/MM/dd HH:mm:ss') last_update
264: FROM fnd_oam_metval fom
265: WHERE fom.METRIC_SHORT_NAME in
266: ('CRIT_UNPR_EXCEP','CRIT_PR_EXCEP','CRIT_TOTAL_UNPR_EXCEP','OPEN_OCC')
267: )
268: LOOP

Line 870: FROM fnd_oam_metval_vl fsm,

866: to_char(fsmg.sequence),
867: fsmg.metric_group_display_name
868:
869:
870: FROM fnd_oam_metval_vl fsm,
871: fnd_oam_met_grps_vl fsmg,
872: FND_OAM_FNDNODES_VL fn
873: WHERE fsm.group_id = fsmg.metric_group_id
874: AND upper(fsm.node_name) = upper(fn.node_name (+))