Showing posts with label How to Find and Script for the Value Set Name Using by Oracle Report or .rdf file in oracle apps EBS R12. Show all posts
Showing posts with label How to Find and Script for the Value Set Name Using by Oracle Report or .rdf file in oracle apps EBS R12. Show all posts

Sunday, 12 July 2015

How to Find and Script for the Value Set Name Using by Oracle Report or .rdf file in oracle apps EBS R12

---- How to Find and Script for the Value Set Name Using by Oracle Report or .rdf file in oracle apps EBS R12  ---

SELECT a.ucpname, a.cpname, a.param, f.flex_value_set_name, p_apromt_name, p_fpromt_name
  FROM (SELECT v.concurrent_program_name cpname,
               v.user_concurrent_program_name ucpname,
               NVL (vc.end_user_column_name, 'NULL PARAM') param,
               vc.form_above_prompt p_apromt_name,
               vc.form_left_prompt p_fpromt_name,
               NVL (vc.flex_value_set_id, 0) valueset
          FROM fnd_concurrent_programs_vl v, fnd_descr_flex_col_usage_vl vc
         WHERE v.user_concurrent_program_name LIKE '%'
           AND v.application_id = vc.application_id(+)
           AND vc.descriptive_flexfield_name(+) = '$SRS$.' || v.concurrent_program_name) a,
       fnd_flex_value_sets f
 WHERE a.valueset = f.flex_value_set_id(+)
--and f.FLEX_VALUE_SET_NAME like 'XX%'
    AND a.ucpname like '%Stock Ledger'

How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide)

  How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide) Introduction In Oracle E-Business Suite, it is a common requirem...