<\/p>\n
SELECT ffvs.flex_value_set_id<\/span> <\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":" SELECT ffvs.flex_value_set_id \u00a0 \u00a0 \u00a0 ,ffvs.flex_value_set_name \u00a0 \u00a0 \u00a0 ,ffvs.description \u00a0 \u00a0 \u00a0 \u00a0 set_description \u00a0 \u00a0 \u00a0 ,ffvs.validation_type \u00a0 \u00a0 \u00a0 ,ffv.flex_value_id \u00a0 \u00a0… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[127,138],"tags":[],"class_list":["post-15619","post","type-post","status-publish","format-standard","hentry","category-applications","category-sql"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15619","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15619"}],"version-history":[{"count":1,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15619\/revisions"}],"predecessor-version":[{"id":15620,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15619\/revisions\/15620"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n\u00a0 \u00a0 \u00a0 ,ffvs.flex_value_set_name<\/span>
\n\u00a0 \u00a0 \u00a0 ,ffvs.description \u00a0 \u00a0 \u00a0 \u00a0 set_description<\/span>
\n\u00a0 \u00a0 \u00a0 ,ffvs.validation_type<\/span>
\n\u00a0 \u00a0 \u00a0 ,ffv.flex_value_id<\/span>
\n\u00a0 \u00a0 \u00a0 ,ffv.flex_value<\/span>
\n\u00a0 \u00a0 \u00a0 ,ffvt.flex_value_meaning<\/span>
\n\u00a0 \u00a0 \u00a0 ,ffvt.description \u00a0 \u00a0 \u00a0 \u00a0 value_description<\/span>
\n\u00a0 FROM fnd_flex_value_sets ffvs<\/span>
\n\u00a0 \u00a0 \u00a0 ,fnd_flex_values \u00a0 \u00a0 ffv<\/span>
\n\u00a0 \u00a0 \u00a0 ,fnd_flex_values_tl\u00a0 ffvt<\/span>
\n\u00a0WHERE ffvs.flex_value_set_name = ‘XXX_YES_NO’<\/span>
\n\u00a0\u00a0 AND ffvs.flex_value_set_id = ffv.flex_value_set_id<\/span>
\n\u00a0\u00a0 AND ffv.flex_value_id = ffvt.flex_value_id<\/span>
\n AND ffvt.language = USERENV(‘LANG’);<\/span><\/p>\n