To Find DFF Flex field attributes
SELECT ffv.application_table_name, ffv.descriptive_flexfield_name,
ffv.context_column_name, ffv.title, att.application_column_name,
att.end_user_column_name, att.column_seq_num, att.enabled_flag,
att.required_flag, att.security_enabled_flag, att.display_flag,
att.flex_value_set_id, att.form_left_prompt, ffv.*
FROM fnd_descriptive_flexs_vl ffv, fnd_descr_flex_col_usage_vl att
WHERE ffv.descriptive_flexfield_name = att.descriptive_flexfield_name
-- AND ffv.descriptive_flexfield_name = 'PO_LINES'
AND (ffv.title) = 'Transaction Information'
SELECT b.application_table_name
ReplyDelete, b.descriptive_flexfield_name
, a.application_column_name
, a.end_user_column_name
FROM fnd_descr_flex_column_usages a
, fnd_descriptive_flexs_vl b
WHERE 1 = 1
AND b.descriptive_flexfield_name = a.descriptive_flexfield_name
AND b.application_id = a.application_id
AND A.CREATED_BY not in (0, 1,2, 5, 120, 121)
AND b.application_table_name != 'FND_SRS_MASTER'
GROUP BY b.application_table_name
, b.descriptive_flexfield_name
, a.application_column_name
, a.end_user_column_name
ORDER BY 1,4
Here is the query for custom DFFs with context values...
SELECT b.application_table_name
, b.descriptive_flexfield_name
, a.application_column_name
, a.end_user_column_name
, a.descriptive_flex_context_code
FROM fnd_descr_flex_column_usages a
, fnd_descriptive_flexs_vl b
WHERE 1 = 1
AND b.descriptive_flexfield_name = a.descriptive_flexfield_name
AND b.application_id = a.application_id
AND A.CREATED_BY not in (0, 1,2, 5, 120, 121)
AND b.application_table_name != 'FND_SRS_MASTER'
ORDER BY 1,4
This comment has been removed by the author.
ReplyDelete