Home » Applications » Oracle Fusion Apps & E-Business Suite » scheduled concurrent Program query
scheduled concurrent Program query [message #95372] Thu, 18 September 2003 14:57 Go to next message
Sudalaimani
Messages: 1
Registered: September 2003
Junior Member
Can any one help me, How to retrive the list of schedule concurrent Program name, frequency, user_id and etc...
Re: scheduled concurrent Program query [message #95374 is a reply to message #95372] Tue, 23 September 2003 08:25 Go to previous message
Daniel
Messages: 47
Registered: February 2000
Member
Hi there,

you can do it via the database should you have database access. here is something you can startup with.
Dany

-----------------------

SELECT fnd_application_tl.description,
fnd_responsibility_tl.responsibility_name, fnd_user.user_name,
fnd_user.description,
fnd_concurrent_programs_tl.user_concurrent_program_name,
fnd_concurrent_programs_tl.description, fnd_concurrent_requests.REQUEST_ID,
fnd_concurrent_requests.request_date,fnd_concurrent_requests.phase_code,
DECODE(fnd_concurrent_requests.phase_code,'C','Completed', DECODE(fnd_concurrent_requests.phase_code,'P',DECODE(fnd_concurrent_requests.phase_code,'R','Running','Pending'))) Phase,
DECODE(fnd_concurrent_requests.status_code,'C',DECODE(fnd_concurrent_requests.status_code, 'I','Normal','Completed'),fnd_concurrent_requests.status_code) Status,
fnd_concurrent_requests.priority,
fnd_concurrent_requests.requested_start_date,
fnd_concurrent_requests.hold_flag,
fnd_concurrent_requests.number_of_arguments,
fnd_concurrent_requests.number_of_copies,
fnd_concurrent_requests.save_output_flag,
fnd_concurrent_requests.printer,
fnd_concurrent_requests.parent_request_id,
fnd_concurrent_requests.description,
fnd_concurrent_requests.resubmit_time,
fnd_concurrent_requests.resubmit_end_date,
fnd_concurrent_requests.argument_text,
fnd_concurrent_requests.argument1, fnd_concurrent_requests.argument2,
fnd_concurrent_requests.argument3, fnd_concurrent_requests.argument4,
fnd_concurrent_requests.argument5, fnd_concurrent_requests.argument6,
fnd_concurrent_requests.argument7, fnd_concurrent_requests.argument8,
fnd_concurrent_requests.argument9 Org, fnd_concurrent_requests.argument10,
fnd_concurrent_requests.argument11, fnd_concurrent_requests.argument12,
fnd_concurrent_requests.argument13, fnd_concurrent_requests.argument14,
fnd_concurrent_requests.argument15, fnd_concurrent_requests.argument16,
fnd_concurrent_requests.argument17, fnd_concurrent_requests.argument18,
fnd_concurrent_requests.argument19, fnd_concurrent_requests.argument20,
fnd_concurrent_requests.argument21, fnd_concurrent_requests.argument22,
fnd_concurrent_requests.argument23, fnd_concurrent_requests.argument24,
fnd_concurrent_requests.argument25,
fnd_concurrent_requests.output_file_type,
fnd_concurrent_requests.cancel_or_hold,
fnd_concurrent_requests.completion_code,
fnd_concurrent_requests.ofile_size, fnd_concurrent_requests.lfile_size,
fnd_concurrent_requests.logfile_name,
fnd_concurrent_requests.logfile_node_name,
fnd_concurrent_requests.outfile_name,
fnd_concurrent_requests.outfile_node_name
FROM applsys.fnd_concurrent_requests,
applsys.fnd_user,
applsys.fnd_responsibility_tl,
applsys.fnd_application_tl,
applsys.fnd_concurrent_programs_tl
WHERE (fnd_user.user_id = fnd_concurrent_requests.requested_by)
AND (fnd_application_tl.application_id =
fnd_concurrent_requests.program_application_id
)
AND (fnd_concurrent_requests.concurrent_program_id =
fnd_concurrent_programs_tl.concurrent_program_id
)
AND (fnd_concurrent_requests.responsibility_id =
fnd_responsibility_tl.responsibility_id
)

AND applsys.fnd_application_tl.LANGUAGE = 'US'
AND fnd_responsibility_tl.LANGUAGE = 'US'

AND applsys.fnd_concurrent_programs_tl.LANGUAGE = 'US'


ORDER BY fnd_concurrent_requests.request_date DESC
Previous Topic: Setting up intercompanies
Next Topic: ORA-12203
Goto Forum:
  


Current Time: Thu Mar 28 16:52:04 CDT 2024