Oracle EBS ‘te Eşzamanlının Atandığı Sorumlulukları Bulan Sorgu (Find to Concurrent Program Responsibility Query in Oracle EBS)
Oracle EBS ‘te tanımlanan concurrentların aynı zamanda hangi sorumluluklara atandıklarını bulmak için aşağıdaki sorguyu kullanabiliriz.
|
1 |
WriteConcurrentShortName -> Bu alana concurrentın short namesini yazıyoruz. |
|
1 |
%WriteHerConcurrentProgramUserNAme% -> Bu alana concurrentın user yani ekran requests listesindeki adını yazıyoruz. Dikkat edilmesi gereken küçük büyük harf duyarlı olması ve başındaki sonundaki % işaretlerinin silinmemesidir. Bu da LIKE komutunun gerekliliğidir. |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
SELECT frt.responsibility_name, frg.request_group_name, frg.description FROM fnd_request_groups frg ,fnd_request_group_units frgu ,fnd_concurrent_programs fcp ,fnd_concurrent_programs_tl fcpt ,fnd_responsibility_tl frt ,fnd_responsibility frs WHERE frgu.unit_application_id = fcp.application_id AND frgu.request_unit_id = fcp.concurrent_program_id AND frg.request_group_id = frgu.request_group_id AND frg.application_id = frgu.application_id AND fcpt.source_lang = USERENV('LANG') AND fcp.application_id = fcpt.application_id AND fcp.concurrent_program_id = fcpt.concurrent_program_id AND frs.application_id = frt.application_id AND frs.responsibility_id = frt.responsibility_id AND frt.source_lang = USERENV('LANG') AND frs.request_group_id = frg.request_group_id AND frs.application_id = frg.application_id AND ( fcp.concurrent_program_name = 'WriteConcurrentShortName' OR fcpt.user_concurrent_program_name LIKE '%WriteHerConcurrentProgramUserNAme%') |