SELECT ffvs.creation_date "Created"
, 'vst/' || ffvs.flex_value_set_id || '.htm' href
, ffvs.flex_value_set_name "Value Set"
, CASE
WHEN validation_type = 'I' THEN 'Independent'
WHEN validation_type = 'F' THEN 'Table'
WHEN validation_type = 'D' THEN 'Dependent'
WHEN validation_type = 'P' THEN 'Pair'
WHEN validation_type = 'U' THEN 'Special'
WHEN validation_type = 'N' THEN 'None'
ELSE validation_type
END "Validation Type"
, ffvs.format_type "Format Type"
, ffvs.maximum_size "Size"
, ffvs.alphanumeric_allowed_flag "Alpha"
, ffvs.uppercase_only_flag "Uppercase"
, ffvs.numeric_mode_enabled_flag "Left Pad"
, ffvs.minimum_value "Min"
, ffvs.maximum_value "Max"
, usr.user_name "Created By"
FROM fnd_flex_value_sets ffvs
, fnd_user usr
WHERE usr.user_id = ffvs.created_by
-- and ffvs.flex_value_set_name LIKE 'XX%'
ORDER BY ffvs.creation_date ASC
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com
ReplyDeleteOracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
ReplyDelete