Scripts

1. To get parameters, value set attached to concurrent programme

SELECT

  COLUMN_SEQ_NUM,

  END_USER_COLUMN_NAME,

  DESCRIPTION,

  (select FLEX_VALUE_SET_NAME from fnd_flex_value_sets  b where b.flex_value_set_id=a.FLEX_VALUE_SET_ID) value_set_name,

  ENABLED_FLAG,

  DEFAULT_VALUE,

  REQUIRED_FLAG,

  SECURITY_ENABLED_FLAG,

  RANGE_CODE,

  DISPLAY_FLAG,

  DISPLAY_SIZE,

  MAXIMUM_DESCRIPTION_LEN,

  CONCATENATION_DESCRIPTION_LEN,

  FORM_LEFT_PROMPT,

  SRW_PARAM,

  ROW_ID,

  CREATED_BY,

  DEFAULT_TYPE,

  FORM_ABOVE_PROMPT,

  DESCRIPTIVE_FLEX_CONTEXT_CODE,

  LAST_UPDATE_LOGIN,

  CREATION_DATE,

  LAST_UPDATED_BY,

  LAST_UPDATE_DATE,

  APPLICATION_COLUMN_NAME,

  APPLICATION_ID,

  DESCRIPTIVE_FLEXFIELD_NAME

FROM

   FND_DESCR_FLEX_COL_USAGE_VL a

WHERE (DESCRIPTIVE_FLEXFIELD_NAME='$SRS$.OVERDUE') order by column_seq_num

 ‘OVERDUE’ is the name of the concurrent programme

2. Sql to find the code written in the value sets

select * from fnd_flex_value_sets             

select * from  fnd_flex_validation_tables

3.To find out the responsibilities to which conc programme is attached

select distinct responsibility_name,description

from fnd_responsibility_vl

where (end_date is null or end_date>trunc(sysdate))

and  request_group_id IN (select REQUEST_GROUP_ID

                          from  fnd_request_group_units

                          where request_unit_id =

                              (select CONCURRENT_PROGRAM_ID  

                               from fnd_concurrent_programs_vl

                               where user_concurrent_program_name 

                               like'OVERDUE'))

4. To find out the concurrent programme attached to different request sets/groups

select distinct request_group_name,

                rs.request_set_name,

                rg.request_group_code,

                fa.application_short_name request_group_application

from  fnd_application fa,

      fnd_concurrent_programs_vl cp,

      FND_REQUEST_GROUP_UNITS rgu,

      FND_REQUEST_GROUPS rg,

      FND_REQUEST_SETS_VL  rs,

      FND_REQUEST_SET_PROGRAMS rsp

where rsp.request_set_id=rgu.request_unit_id

  and rg.request_group_id     = rgu.request_group_id

  and rg.application_id = fa.application_id

  and rsp.concurrent_program_id = cp.concurrent_program_id

  and rs.REQUEST_SET_ID =rsp.request_set_id

  and cp.user_concurrent_program_name   IN ('OVERDUE')

5. To find out the concurrent programme attached to the main concurrent programme for Incompatibility

select CONCURRENT_PROGRAM_NAME,USER_CONCURRENT_PROGRAM_NAME, DESCRIPTION from FND_CONCURRENT_PROGRAMS_VL

where CONCURRENT_PROGRAM_ID in

(select distinct TO_RUN_CONCURRENT_PROGRAM_ID                             FROM           FND_CONCURRENT_PROGRAM_SERIAL

        WHERE (RUNNING_CONCURRENT_PROGRAM_ID=

              (select CONCURRENT_PROGRAM_ID                                              from FND_CONCURRENT_PROGRAMS

                where CONCURRENT_PROGRAM_NAME                                             like'PADOWNLOADPATCHES' AND ENABLED_FLAG='Y')))

6. To find out the concurrent programme and executable details

select

  fcpv.concurrent_program_name "Concurrent Program Name"

 ,fcpv.user_concurrent_program_name "User Concurrent Program Name"

 ,fcpv.description "Concurrent Program Description"

 ,fev.execution_file_name "Execution File Name"

 ,fev.executable_name "Executable Assigned"

from

  fnd_concurrent_programs_vl fcpv

 ,fnd_executables_vl fev

 ,fnd_application fa

where user_concurrent_program_name = 'Altera UOM Principal + Dual'

  and fcpv.executable_id = fev.executable_id

  and fev.application_id = fa.application_id

7. To find out the Request_group details

select fa.application_short_name,frg.Request_group_name

from fnd_request_groups frg

    ,fnd_application fa

 where fa.application_id = frg.application_id

and request_group_id in

(select request_group_id

  from fnd_request_group_units

  where request_unit_id in

(select concurrent_program_id

   from fnd_concurrent_programs_vl

  where user_concurrent_program_name = 'XXPEPIB: Coste Ventas\Genero en  

                             Camino\\[100] Contenido documentos Burgos'

)

)