select resp.responsibility_name,
pr.user_concurrent_program_name,
ex.executable_name,
ex.application_name
from apps.FND_EXECUTABLES_FORM_V ex,
apps.FND_CONCURRENT_PROGRAMS_VL pr,
apps.FND_REQUEST_GROUP_UNITS rgu,
apps.FND_REQUEST_GROUPS rg,
apps.FND_RESPONSIBILITY_VL resp
where 1=1
and pr.executable_id=ex.executable_id
and rgu.request_group_id=rg.request_group_id
and rgu.request_unit_id=pr.concurrent_program_id
and resp.request_group_id=rg.request_group_id
and pr.user_concurrent_program_name like 'TNPL Export Sales Order Check List Report Internal'
pr.user_concurrent_program_name,
ex.executable_name,
ex.application_name
from apps.FND_EXECUTABLES_FORM_V ex,
apps.FND_CONCURRENT_PROGRAMS_VL pr,
apps.FND_REQUEST_GROUP_UNITS rgu,
apps.FND_REQUEST_GROUPS rg,
apps.FND_RESPONSIBILITY_VL resp
where 1=1
and pr.executable_id=ex.executable_id
and rgu.request_group_id=rg.request_group_id
and rgu.request_unit_id=pr.concurrent_program_id
and resp.request_group_id=rg.request_group_id
and pr.user_concurrent_program_name like 'TNPL Export Sales Order Check List Report Internal'
No comments:
Post a Comment