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