Wednesday 28 December 2011

Decriptive flexfield registration details

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