select flex_vl.title,flex.descriptive_flexfield_name,
context_vl.descriptive_flex_context_code,context_vl.description,
col_usage_vl.application_column_name, col_usage_vl.end_user_column_name
from apps.FND_DESCRIPTIVE_FLEXS flex,
apps.FND_DESCRIPTIVE_FLEXS_vl flex_vl
,apps.FND_DESCR_FLEX_CONTEXTS_VL context_vl
,apps.FND_DESCR_FLEX_COL_USAGE_VL col_usage_vl
where flex_vl.application_id in (201,101)
and flex_vl.title = 'Approved Supplier List'
and flex.descriptive_flexfield_name = flex_vl.descriptive_flexfield_name
--'PO_APPROVED_SUPPLIER_LIST'
and flex.descriptive_flexfield_name = context_vl.descriptive_flexfield_name
and flex.descriptive_flexfield_name = col_usage_vl.descriptive_flexfield_name
and col_usage_vl.descriptive_flex_context_code = context_vl.descriptive_flex_context_code
order by col_usage_vl.descriptive_flex_context_code,col_usage_vl.application_column_name
context_vl.descriptive_flex_context_code,context_vl.description,
col_usage_vl.application_column_name, col_usage_vl.end_user_column_name
from apps.FND_DESCRIPTIVE_FLEXS flex,
apps.FND_DESCRIPTIVE_FLEXS_vl flex_vl
,apps.FND_DESCR_FLEX_CONTEXTS_VL context_vl
,apps.FND_DESCR_FLEX_COL_USAGE_VL col_usage_vl
where flex_vl.application_id in (201,101)
and flex_vl.title = 'Approved Supplier List'
and flex.descriptive_flexfield_name = flex_vl.descriptive_flexfield_name
--'PO_APPROVED_SUPPLIER_LIST'
and flex.descriptive_flexfield_name = context_vl.descriptive_flexfield_name
and flex.descriptive_flexfield_name = col_usage_vl.descriptive_flexfield_name
and col_usage_vl.descriptive_flex_context_code = context_vl.descriptive_flex_context_code
order by col_usage_vl.descriptive_flex_context_code,col_usage_vl.application_column_name
No comments:
Post a Comment