APPS.INV_DIAG_OBJ dependencies on FND_APPLICATION

Line 55: from FND_APPLICATION

51:
52: if l_app_id is null then
53: select APPLICATION_ID
54: into l_app_id
55: from FND_APPLICATION
56: where APPLICATION_SHORT_NAME='INV';
57: reportStr := ' INV';
58: l_app :='INV';
59: else

Line 62: from FND_APPLICATION

58: l_app :='INV';
59: else
60: select trim(APPLICATION_SHORT_NAME)
61: into l_app
62: from FND_APPLICATION
63: where APPLICATION_ID=l_app_id;
64: reportStr := ' '||l_app;
65: end if;
66:

Line 109: ' , fnd_application h '||

105: ' , fnd_profile_option_values c '||
106: ' , fnd_user d '||
107: ' , fnd_user e '||
108: ' , fnd_responsibility_vl g '||
109: ' , fnd_application h '||
110: 'WHERE a.application_id = '||l_app_id||
111: ' AND a.profile_option_name = b.profile_option_name '||
112: ' AND a.profile_option_id = c.profile_option_id '||
113: ' AND a.application_id = c.application_id '||

Line 296: ' , fnd_application_vl fa '||

292: ' , NVL( fcq.target_node,''n/a'') "Node" '||
293: ' , fcq.running_processes "Actual" '||
294: ' , fcq.max_processes "Target" '||
295: ' FROM fnd_concurrent_queues_vl fcq '||
296: ' , fnd_application_vl fa '||
297: ' , fnd_concurrent_processors fcp '||
298: 'WHERE fa.application_id = fcq.application_id '||
299: ' AND fcq.application_id = fcp.application_id '||
300: ' AND fcq.concurrent_processor_id = fcp.concurrent_processor_id '||

Line 388: ' , fnd_application h '||

384: ' , fnd_profile_options_vl b '||
385: ' , fnd_profile_option_values c '||
386: ' , fnd_user d , fnd_user e '||
387: ' , fnd_responsibility_vl g '||
388: ' , fnd_application h '||
389: 'WHERE a.profile_option_name = b.profile_option_name '||
390: ' AND a.profile_option_id = c.profile_option_id '||
391: ' AND a.application_id = c.application_id '||
392: ' AND c.last_updated_by = d.user_id (+) '||