SELECT ffvs.flex_value_set_id,
ffvs.flex_value_set_name,
ffvs.description set_description ,
fl.meaning validation_type,
ffvt.value_column_name ,
ffvt.meaning_column_name ,
ffvt.id_column_name ,
ffvt.application_table_name ,
ffvt.additional_where_clause
FROM apps.fnd_flex_value_sets ffvs ,
apps.fnd_flex_validation_tables ffvt,
apps.fnd_lookups fl
WHERE ffvs.flex_value_set_id = ffvt.flex_value_set_id(+)
AND ffvs.flex_value_set_name LIKE NVL('&VALUE_SET_NAME_CASE_SENSITIVE','%')
and fl.lookup_type = 'SEG_VAL_TYPES'
AND fl.lookup_code = ffvs.validation_type
ffvs.flex_value_set_name,
ffvs.description set_description ,
fl.meaning validation_type,
ffvt.value_column_name ,
ffvt.meaning_column_name ,
ffvt.id_column_name ,
ffvt.application_table_name ,
ffvt.additional_where_clause
FROM apps.fnd_flex_value_sets ffvs ,
apps.fnd_flex_validation_tables ffvt,
apps.fnd_lookups fl
WHERE ffvs.flex_value_set_id = ffvt.flex_value_set_id(+)
AND ffvs.flex_value_set_name LIKE NVL('&VALUE_SET_NAME_CASE_SENSITIVE','%')
and fl.lookup_type = 'SEG_VAL_TYPES'
AND fl.lookup_code = ffvs.validation_type
No comments:
Post a Comment