Oracle E-Business Suite: R12 Önemli Sorgular

Request Group'larının ve Concurrent Programs'larının  Bulunması:

Concurrent  Program koşulu burada çıkarılmıştır. Kullanılırken dikkat edilmelidir.

SELECT g.request_group_name, c.user_concurrent_program_name,
a.application_name, g.application_id, g.request_group_id,
u.unit_application_id, u.request_unit_id
FROM fnd_request_groups g,
fnd_request_group_units u,
fnd_application_tl a,
fnd_concurrent_programs_tl c
WHERE g.request_group_id = u.request_group_id
AND u.unit_application_id = a.application_id
AND u.request_unit_id = c.concurrent_program_id
–and c.USER_CONCURRENT_PROGRAM_NAME like ‘%Custom%’
ORDER BY C.user_concurrent_program_name, A.application_name, g.request_group_id;

Çalışan Uygulamaların Bulunması:

Bu sorguyla çalışan uygulamaları ve id'lerini bulabiliriz. Burada application_name kısmını çıkarttım ama siz kullanabilirsiniz.


SELECT application_id,APPLICATION_NAME
FROM fnd_application_tl
WHERE-- application_name = ‘Purchasing’ AND
rownum = 1;

Concurrent Manager Tarafından Çalıştırılan Request'lerin Bulunması:


select b.user_concurrent_queue_name, c.request_id
from fnd_concurrent_processes a, fnd_concurrent_queues_vl b, fnd_concurrent_requests c
where a.concurrent_queue_id = b.concurrent_queue_id
and a.concurrent_process_id = c.controlling_manager;

Belirli Bir Kullanıcıya Atanmış Sorumlulukların Bulunması:

Bu sorguyla belirli bir anda kısayoldan kişinin sorumlulukları bulunabilinir.


SELECT b.responsibility_name NAME
FROM apps.fnd_user_resp_groups a,
apps.fnd_responsibility_vl b,
apps.fnd_user u
WHERE a.user_id = u.user_id
AND u.user_id = (select user_id from FND_USER where user_name=:User_name)
AND a.responsibility_id = b.responsibility_id
AND a.responsibility_application_id = b.application_id
AND SYSDATE BETWEEN a.start_date AND NVL (a.end_date, SYSDATE + 1)
AND b.end_date IS NULL
AND u.end_date IS NULL