Concurrent program details from back end

Concurrent Program Execution Methods

Below Query will give you the Concurrent Program/Execution Method

 
select b.concurrent_program_name||' - '||a.user_concurrent_program_name, a.description,
decode(b.execution_method_code,
'P', 'Oracle Reports',
'E' ,'Perl Concurrent Program',
'Q' ,'SQL*Plus',
'L' ,'SQL*Loader',
'A' ,'Spawned',
'B' ,'Request Set Stage Function',
'I' ,'PL/SQL Stored Procedure',
'K' ,'Java Concurrent Program',
'J' ,'Java Stored Procedure',
'S' ,'Immediate',
'H' ,'Host'
) Execution_Method
 from fnd_concurrent_programs_tl a, fnd_concurrent_programs b where
a.concurrent_program_id = b.concurrent_program_id
and b.enabled_flag = 'Y';

select * from  FND_CONCURRENT_PROGRAMS_VL
where user_CONCURRENT_PROGRAM_NAME like '%%'; -- program name

select * from FND_EXECUTABLES_FORM_V 
where executable_id = 123123; -- executable number

check status -

SELECT request_id,

DECODE(status_code,

'A','Waiting', 'B','Resuming', 'C','Normal', 'D','Cancelled', 'E','Error', 'F','Scheduled', 'G','Warning', 'H','On Hold',

'I','Normal', 'M','No Manager', 'Q','Standby', 'R','Normal', 'S','Suspended', 'T','Terminating', 'U','Disabled', 'W','Paused',

'X','Terminated', 'Z','Waiting') Status,

DECODE(PHASE_CODE, 'C','Completed', 'I','Inactive', 'P','Pending', 'R','Running', 'Others' ) PHASE,

TO_CHAR(REQUEST_DATE,'DD-MON-YYYY HH24:MI:SS') REQUEST_DATE,

REQUESTOR,

TO_CHAR(ACTUAL_START_DATE,'DD-MON-YYYY HH24:MI:SS') ACTUAL_START_DATE,

TO_CHAR(ACTUAL_COMPLETION_DATE,'DD-MON-YYYY HH24:MI:SS') ACTUAL_COMPLETION_DATE,

to_char(round((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)*1440,0))||' Mins '||to_char(round(mod((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)*86400,60),2))||' Secs' duration,

ARGUMENT_TEXT,RTL.RESPONSIBILITY_NAME,program,PROGRAM_SHORT_NAME,RTL.RESPONSIBILITY_ID,CONCURRENT_PROGRAM_ID,

priority_request_id,priority,printer,print_style,user_print_style,requested_start_date

from apps.FND_CONC_REQ_SUMMARY_V CONC , apps.FND_RESPONSIBILITY_TL RTL

where CONC.RESPONSIBILITY_ID=RTL.RESPONSIBILITY_ID

--and status_code = 'E'

and language='US'

and program like '%XYZUU%'--

--and request_id=12345679989

--and REQUESTOR = 'ABCDEFG'

--and ARGUMENT_TEXT ='1235, , 0, , , 4'

--and REQUEST_DATE > sysdate -10

order by REQUEST_DATE desc;