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'

No comments:

Post a Comment

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...