SELECT title
      , application_table_name
      , descriptive_flexfield_name
      , context_column_name
 FROM fnd_descriptive_flexs_vl
WHERE title = :p_title
 2.DECRIPTIVE FLEXFIELD CONTEXT DETAILS
 SELECT   descriptive_flex_context_code
       , descriptive_flex_context_name
       , description
       , enabled_flag
       , application_id
       , descriptive_flexfield_name
       , global_flag
  FROM fnd_descr_flex_contexts_vl
 WHERE descriptive_flexfield_name    = p_descriptive_flexfield_name
 
 
No comments:
Post a Comment