SELECT app.application_name,
dff_name.descriptive_flexfield_name,
dff_segments.end_user_column_name dff_column_name,
dff_segments.application_column_name attribute_column,
dff_segments.descriptive_flex_context_code
FROM fnd_descriptive_flexs_vl dff_name,
fnd_descr_flex_col_usage_vl dff_segments,
fnd_application_tl app
WHERE 1=1
--dff_name.application_id = 201
AND dff_name.application_id = dff_segments.application_id
AND dff_name.descriptive_flexfield_name =
dff_segments.descriptive_flexfield_name
AND dff_name.application_id = app.application_id
AND dff_name.application_id = app.application_id
AND dff_name.descriptive_flexfield_name NOT LIKE '$SRS$%'
-- AND dff_name.descriptive_flexfield_name LIKE 'PO%HEADE%'
ORDER BY dff_name.descriptive_flexfield_name,
dff_segments.end_user_column_name,
dff_segments.application_column_name
dff_name.descriptive_flexfield_name,
dff_segments.end_user_column_name dff_column_name,
dff_segments.application_column_name attribute_column,
dff_segments.descriptive_flex_context_code
FROM fnd_descriptive_flexs_vl dff_name,
fnd_descr_flex_col_usage_vl dff_segments,
fnd_application_tl app
WHERE 1=1
--dff_name.application_id = 201
AND dff_name.application_id = dff_segments.application_id
AND dff_name.descriptive_flexfield_name =
dff_segments.descriptive_flexfield_name
AND dff_name.application_id = app.application_id
AND dff_name.application_id = app.application_id
AND dff_name.descriptive_flexfield_name NOT LIKE '$SRS$%'
-- AND dff_name.descriptive_flexfield_name LIKE 'PO%HEADE%'
ORDER BY dff_name.descriptive_flexfield_name,
dff_segments.end_user_column_name,
dff_segments.application_column_name
No comments:
Post a Comment