SELECT
cpt.user_concurrent_program_name "Concurrent Program Name",
decode(rgu.request_unit_type, 'P', 'Program', 'S', 'Set',
rgu.request_unit_type) "Unit Type",
fcr.status_code status,
fcr.request_date prog_submitted_date,
fnr.responsibility_name,
fcr.argument1
|| '-'
|| fcr.argument2
|| '-'
|| fcr.argument3
|| '-'
|| fcr.argument4
|| '-'
|| fcr.argument5
|| '-'
|| fcr.argument6
|| '-'
|| fcr.argument7
|| '-'
|| fcr.argument8
|| '-'
|| fcr.argument9
|| '-'
|| fcr.argument10
|| '-'
|| fcr.argument11
|| '-'
|| fcr.argument12
|| '-'
|| fcr.argument13
|| '-'
|| fcr.argument14
|| '-'
|| fcr.argument15 parameters,
cp.concurrent_program_name "Concurrent Program Short Name",
rg.application_id "Application ID",
rg.request_group_name "Request Group Name",
fat.application_name "Application Name",
fa.application_short_name "Application Short Name",
fa.basepath "Basepath",
cpt.concurrent_program_id
FROM
fnd_request_groups rg,
fnd_request_group_units rgu,
fnd_concurrent_programs cp,
fnd_concurrent_programs_tl cpt,
fnd_application fa,
fnd_application_tl fat--,
,
fnd_concurrent_requests fcr,
fnd_responsibility_tl fnr
WHERE
rg.request_group_id = rgu.request_group_id
AND rgu.request_unit_id = cp.concurrent_program_id
AND cp.concurrent_program_id = cpt.concurrent_program_id
AND rg.application_id = fat.application_id
AND fa.application_id = fat.application_id
AND cpt.language = userenv('LANG')
AND fat.language = userenv('LANG')
AND cpt.concurrent_program_id = fcr.concurrent_program_id
AND fcr.responsibility_id = fnr.responsibility_id
AND cpt.user_concurrent_program_name = 'Concurrent program name'
ORDER BY
fcr.request_date DESC
cpt.user_concurrent_program_name "Concurrent Program Name",
decode(rgu.request_unit_type, 'P', 'Program', 'S', 'Set',
rgu.request_unit_type) "Unit Type",
fcr.status_code status,
fcr.request_date prog_submitted_date,
fnr.responsibility_name,
fcr.argument1
|| '-'
|| fcr.argument2
|| '-'
|| fcr.argument3
|| '-'
|| fcr.argument4
|| '-'
|| fcr.argument5
|| '-'
|| fcr.argument6
|| '-'
|| fcr.argument7
|| '-'
|| fcr.argument8
|| '-'
|| fcr.argument9
|| '-'
|| fcr.argument10
|| '-'
|| fcr.argument11
|| '-'
|| fcr.argument12
|| '-'
|| fcr.argument13
|| '-'
|| fcr.argument14
|| '-'
|| fcr.argument15 parameters,
cp.concurrent_program_name "Concurrent Program Short Name",
rg.application_id "Application ID",
rg.request_group_name "Request Group Name",
fat.application_name "Application Name",
fa.application_short_name "Application Short Name",
fa.basepath "Basepath",
cpt.concurrent_program_id
FROM
fnd_request_groups rg,
fnd_request_group_units rgu,
fnd_concurrent_programs cp,
fnd_concurrent_programs_tl cpt,
fnd_application fa,
fnd_application_tl fat--,
,
fnd_concurrent_requests fcr,
fnd_responsibility_tl fnr
WHERE
rg.request_group_id = rgu.request_group_id
AND rgu.request_unit_id = cp.concurrent_program_id
AND cp.concurrent_program_id = cpt.concurrent_program_id
AND rg.application_id = fat.application_id
AND fa.application_id = fat.application_id
AND cpt.language = userenv('LANG')
AND fat.language = userenv('LANG')
AND cpt.concurrent_program_id = fcr.concurrent_program_id
AND fcr.responsibility_id = fnr.responsibility_id
AND cpt.user_concurrent_program_name = 'Concurrent program name'
ORDER BY
fcr.request_date DESC
No comments:
Post a Comment