SELECT fdfv.title, fdfv.application_table_name, fdfv.context_column_name,
fdfcu.descriptive_flexfield_name,
fdfcu.descriptive_flex_context_code, fdfcu.column_seq_num,
fdfcu.application_column_name, fdfcu.end_user_column_name
FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_descriptive_flexs_vl fdfv
WHERE fdfv.title = 'Line Transaction Flexfield'
AND fdfcu.descriptive_flexfield_name = fdfv.descriptive_flexfield_name
AND fdfcu.application_id = fdfv.application_id
ORDER BY fdfcu.descriptive_flexfield_name,
fdfcu.descriptive_flex_context_code,
fdfcu.column_seq_num;
No comments:
Post a Comment