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';

1 comment:

  1. select distinct lookup_code,meaning from fnd_lookup_values where lookup_type='CP_EXECUTION_METHOD_CODE'

    ReplyDelete