/* Formatted on 7/17/2014 1:05:43 PM (QP5 v5.115.810.9015) */
SELECT flex_value_set_name,
vt.meaning validation_type_meaning,
ft.meaning format_type_meaning,
v.description,
v.flex_value_set_id
FROM fnd_flex_value_sets v,
fnd_lookups vt,
fnd_lookups ft,
fnd_flex_validation_tables t
WHERE (UPPER (flex_value_set_name) LIKE :1
AND ( flex_value_set_name LIKE :2
OR flex_value_set_name LIKE :3
OR flex_value_set_name LIKE :4
OR flex_value_set_name LIKE :5))
AND ( vt.lookup_type = 'SEG_VAL_TYPES'
AND vt.lookup_code = v.validation_type
AND ft.lookup_type = 'FIELD_TYPE'
AND ft.lookup_code = v.format_type
AND v.flex_value_set_id = t.flex_value_set_id(+)
AND v.flex_value_set_name NOT LIKE '$FLEX$.%'
AND v.validation_type IN ('I', 'F')
AND v.format_type = 'C'
AND v.alphanumeric_allowed_flag = 'Y'
AND v.uppercase_only_flag = 'N'
AND v.numeric_mode_enabled_flag = 'N'
AND ( (v.validation_type = 'I' AND v.maximum_size <= 30)
OR ( v.validation_type = 'F'
AND v.maximum_size <= 80
AND t.id_column_type IN ('C', 'V')
AND t.id_column_size <= 30
AND t.value_column_type IN ('C', 'V')
AND t.value_column_size <= 80)))
ORDER BY v.flex_value_set_name
SELECT flex_value_set_name,
vt.meaning validation_type_meaning,
ft.meaning format_type_meaning,
v.description,
v.flex_value_set_id
FROM fnd_flex_value_sets v,
fnd_lookups vt,
fnd_lookups ft,
fnd_flex_validation_tables t
WHERE (UPPER (flex_value_set_name) LIKE :1
AND ( flex_value_set_name LIKE :2
OR flex_value_set_name LIKE :3
OR flex_value_set_name LIKE :4
OR flex_value_set_name LIKE :5))
AND ( vt.lookup_type = 'SEG_VAL_TYPES'
AND vt.lookup_code = v.validation_type
AND ft.lookup_type = 'FIELD_TYPE'
AND ft.lookup_code = v.format_type
AND v.flex_value_set_id = t.flex_value_set_id(+)
AND v.flex_value_set_name NOT LIKE '$FLEX$.%'
AND v.validation_type IN ('I', 'F')
AND v.format_type = 'C'
AND v.alphanumeric_allowed_flag = 'Y'
AND v.uppercase_only_flag = 'N'
AND v.numeric_mode_enabled_flag = 'N'
AND ( (v.validation_type = 'I' AND v.maximum_size <= 30)
OR ( v.validation_type = 'F'
AND v.maximum_size <= 80
AND t.id_column_type IN ('C', 'V')
AND t.id_column_size <= 30
AND t.value_column_type IN ('C', 'V')
AND t.value_column_size <= 80)))
ORDER BY v.flex_value_set_name
No comments:
Post a Comment