Sunday, August 14, 2011

To find the parameters of the concurrent program from back end



      SELECT  *
  FROM  fnd_descr_flex_col_usage_vl ds,
        fnd_flex_value_sets         vs,
        (SELECT  meaning,
                 lookup_code
          FROM   fnd_lookup_values
         WHERE   lookup_type  =  'FLEX_DEFAULT_TYPE') lookup      
 WHERE  ds.descriptive_flexfield_name  LIKE '%'||'XXCAS_PRJ_PROJ%' ---Package name
   AND  ds.flex_value_set_id           =     vs.flex_value_set_id
   AND  ds.DEFAULT_TYPE                =     lookup.lookup_code (+)
ORDER BY ds.column_seq_num;

No comments:

Post a Comment