Query to find value set name from concurrent program

  SELECT
    fcpl.user_concurrent_program_name,
    fcp.concurrent_program_name,
    fdfcuv.column_seq_num,
    fdfcuv.end_user_column_name,
    fdfcuv.form_left_prompt,
    fdfcuv.enabled_flag,
    fdfcuv.required_flag,
    fdfcuv.display_flag,
    fdfcuv.flex_value_set_id,
    ffvs.flex_value_set_name,
    flv.meaning,
    fdfcuv.default_value
FROM
    fnd_concurrent_programs      fcp,
    fnd_concurrent_programs_tl   fcpl,
    fnd_descr_flex_col_usage_vl  fdfcuv,
    fnd_flex_value_sets          ffvs,
    fnd_lookup_values            flv
WHERE
        fcp.concurrent_program_id = fcpl.concurrent_program_id
    AND fcpl.user_concurrent_program_name = 'concurrent_program_name'

    AND fdfcuv.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
    AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id
    AND flv.lookup_type (+) = 'FLEX_DEFAULT_TYPE'
    AND flv.lookup_code (+) = fdfcuv.default_type
    AND fcpl.language = userenv('LANG')
    AND flv.language (+) = userenv('LANG')
ORDER BY
    fdfcuv.column_seq_num;

Query to find concurrent program name from value set

 SELECT
    fdfcuv.flex_value_set_id,
    ffvs.flex_value_set_name,
    flv.meaning,
    fdfcuv.default_value,
    fcpl.user_concurrent_program_name,
    fcp.concurrent_program_name,
    fdfcuv.column_seq_num,
    fdfcuv.end_user_column_name,
    fdfcuv.form_left_prompt,
    fdfcuv.enabled_flag,
    fdfcuv.required_flag,
    fdfcuv.display_flag
FROM
    fnd_concurrent_programs      fcp,
    fnd_concurrent_programs_tl   fcpl,
    fnd_descr_flex_col_usage_vl  fdfcuv,
    fnd_flex_value_sets          ffvs,
    fnd_lookup_values            flv
WHERE
        fcp.concurrent_program_id = fcpl.concurrent_program_id
    AND fdfcuv.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
    AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id
    AND flv.lookup_type (+) = 'FLEX_DEFAULT_TYPE'
    AND flv.lookup_code (+) = fdfcuv.default_type
    AND fcpl.language = userenv('LANG')
    AND flv.language (+) = userenv('LANG')
    AND fdfcuv.enabled_flag = 'Y'
    AND ffvs.flex_value_set_name LIKE '%VALUE_SET_NAME%'
ORDER BY
    fcpl.user_concurrent_program_name;

Query to remove junk characters

select REGEXP_REPLACE (' SSS TEST ãallç', '[^ -~]', '') from dual;

Query to find package name from business event

select w_even.name
  ,w_even.status event_status
  ,w_e_subs.status subscription_status
  ,nvl(w_e_subs.phase,0) subscription_phase
  ,w_e_subs.rule_function
from wf_events w_even
  ,wf_event_subscriptions w_e_subs
where
  w_even.name like '%oracle.apps.ont%' -- Business Event name
  and w_e_subs.event_filter_guid = w_even.guid;

Command to find a files containing a text string in linux

 grep -rwli "string_to_search" xxsss/12.0.0/bin

Query to find out the concurrent program name from Request Set

SELECT DISTINCT frst.request_set_id,

  frst.user_request_set_name request_set,

  frst.description description,

  frsst.request_set_stage_id,

  frsst.user_stage_name stage_name,

  frsst.description stage_description,

  fcp.user_concurrent_program_name  

FROM apps.fnd_request_sets_tl frst,

  apps.fnd_request_set_stages_tl frsst,

  apps.fnd_request_set_programs frsp,

  apps.fnd_concurrent_programs_tl fcp

WHERE frst.application_id =frsst.set_application_id

AND frst.request_set_id   = frsst.request_set_id

AND frst.request_set_id = frsp.request_set_id

AND frsst.request_set_stage_id = frsp.request_set_stage_id

AND frsp.concurrent_program_id = fcp.concurrent_program_id

AND frst.language =userenv('LANG')

AND fcp.language =userenv('LANG')

AND upper(frst.user_request_set_name) like '%'||upper('Request Set Name')||'%'

order by frst.user_request_set_name, frsst.request_set_stage_id;

Query to findout the Request Set from concurrent program

SELECT DISTINCT frst.request_set_id,

  frst.user_request_set_name request_set,

  frst.description description,

  frsst.request_set_stage_id,

  frsst.user_stage_name stage_name,

  frsst.description stage_description,

  fcp.user_concurrent_program_name  

FROM apps.fnd_request_sets_tl frst,

  apps.fnd_request_set_stages_tl frsst,

  apps.fnd_request_set_programs frsp,

  apps.fnd_concurrent_programs_tl fcp

WHERE frst.application_id =frsst.set_application_id

AND frst.request_set_id   = frsst.request_set_id

AND frst.request_set_id = frsp.request_set_id

AND frsst.request_set_stage_id = frsp.request_set_stage_id

AND frsp.concurrent_program_id = fcp.concurrent_program_id

AND frst.language =userenv('LANG')

AND fcp.language =userenv('LANG')

AND upper(fcp.user_concurrent_program_name) LIKE '%'||upper('Concurrent Program Name')||'%'

order by frst.user_request_set_name, frsst.request_set_stage_id;