SELECT
cpt.user_concurrent_program_name Nazwa_Programu,
cp.concurrent_program_name Skrot_programu,
frv.RESPONSIBILITY_NAME Autoryzacja,
frg.request_group_name Grupa_Zlecen,
fa.APPLICATION_NAME Modul
FROM
applsys.fnd_concurrent_programs cp,
applsys.fnd_concurrent_programs_tl cpt,
applsys.FND_REQUEST_GROUPS frg,
applsys.FND_REQUEST_GROUP_UNITS frgu,
apps.fnd_application_all_view fa,
apps.FND_RESPONSIBILITY_VL frv,
apps.FND_EXECUTABLES_FORM_V fefv,
apps.fnd_application_vl faa
WHERE cp.application_id=cpt.application_id
AND cpt.concurrent_program_id=cp.concurrent_program_id
AND cpt.language='PL'
AND frgu.application_id=frg.application_id
AND frg.request_group_id=frgu.request_group_id
AND frgu.request_unit_id=cp.concurrent_program_id
AND fa.application_id=frg.application_id
AND frv.REQUEST_GROUP_ID(+)=frg.request_group_id
AND fefv.EXECUTABLE_ID=cp.executable_id
AND fefv.EXECUTION_METHOD_CODE='P'
AND faa.APPLICATION_ID=cp.application_id
AND faa.APPLICATION_NAME='Rozszerzenia'
--and cp.concurrent_program_name = ˜XX_RAP_CR00434_AR'
AND cpt.user_concurrent_program_name LIKE 'XX: Wydruk zapotrzebowania na RW ODM' |
select
cpt.user_concurrent_program_name Nazwa_Programu,
cp.concurrent_program_name Skrot_programu,
frv.RESPONSIBILITY_NAME Autoryzacja,
frg.request_group_name Grupa_Zlecen,
fa.APPLICATION_NAME Modul
from
applsys.fnd_concurrent_programs cp,
applsys.fnd_concurrent_programs_tl cpt,
applsys.FND_REQUEST_GROUPS frg,
applsys.FND_REQUEST_GROUP_UNITS frgu,
apps.fnd_application_all_view fa,
apps.FND_RESPONSIBILITY_VL frv,
apps.FND_EXECUTABLES_FORM_V fefv,
apps.fnd_application_vl faa
where cp.application_id=cpt.application_id
and cpt.concurrent_program_id=cp.concurrent_program_id
and cpt.language='PL'
and frgu.application_id=frg.application_id
and frg.request_group_id=frgu.request_group_id
and frgu.request_unit_id=cp.concurrent_program_id
and fa.application_id=frg.application_id
and frv.REQUEST_GROUP_ID(+)=frg.request_group_id
and fefv.EXECUTABLE_ID=cp.executable_id
and fefv.EXECUTION_METHOD_CODE='P'
and faa.APPLICATION_ID=cp.application_id
and faa.APPLICATION_NAME='Rozszerzenia'
--and cp.concurrent_program_name = ˜XX_RAP_CR00434_AR'
and cpt.user_concurrent_program_name like 'XX: Wydruk zapotrzebowania na RW ODM'
słowa kluczowe: raport, program współbieżny, autoryzacja, autoryzacje, grupa zleceń
Ten wpis został opublikowany w kategorii
SQL-ki i oznaczony tagami
kolory,
wygląd. Dodaj zakładkę do
bezpośredniego odnośnika.