APPS.FND_OAM_EM dependencies on FND_OAM_APP_SYS_STATUS

Line 128: FROM fnd_oam_app_sys_status foa,

124: to_char(foa.last_update_date,'yyyy/MM/dd HH:mm:ss') last_update_date,
125: decode(foa.type,NULL,'N/A',foa.type),
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 (+)

Line 461: FROM fnd_oam_app_sys_status foa,

457: BEGIN
458:
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 (+)