DBA Data[Home] [Help]

APPS.FND_OAM_EM dependencies on FND_OAM_FNDNODES_VL

Line 130: FND_OAM_FNDNODES_VL fn,

126: decode(fcq.manager_type,NULL,'N/A',fcq.manager_type)
127:
128: FROM fnd_oam_app_sys_status foa,
129: fnd_concurrent_queues_vl fcq,
130: FND_OAM_FNDNODES_VL fn,
131: fnd_lookups fl
132: WHERE foa.application_id = fcq.application_id (+)
133: AND foa.concurrent_queue_name = fcq.concurrent_queue_name (+)
134: AND upper(foa.node_name) = upper(fn.node_name (+))

Line 463: FND_OAM_FNDNODES_VL fn,

459: FOR pair_1 IN
460: ( SELECT foa.status_code sta
461: FROM fnd_oam_app_sys_status foa,
462: fnd_concurrent_queues_vl fcq,
463: FND_OAM_FNDNODES_VL fn,
464: fnd_lookups fl
465: WHERE foa.application_id = fcq.application_id (+)
466: AND foa.concurrent_queue_name = fcq.concurrent_queue_name (+)
467: AND upper(foa.node_name) = upper(fn.node_name (+))

Line 872: FND_OAM_FNDNODES_VL fn

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 (+))
875: ORDER BY fsmg.sequence, fsm.sequence;
876: