DBA Data[Home] [Help]

APPS.FND_OAM_EM dependencies on FND_LOOKUPS

Line 131: fnd_lookups fl

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 (+))
135: AND nvl(fn.platform_code, '-x') = fl.lookup_code(+)

Line 464: fnd_lookups fl

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 (+))
468: AND nvl(fn.platform_code, '-x') = fl.lookup_code(+)