Skip to content

Instantly share code, notes, and snippets.

@jgilmour

jgilmour/OracleEBS-All-FlexField-Values.sql

Last active February 14, 2021 20:36
Show Gist options
  • Save jgilmour/4612542 to your computer and use it in GitHub Desktop.
Save jgilmour/4612542 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle EBS SQL Query to pull down all flexfield values based upon a specified flex value set name.
Raw
OracleEBS-All-FlexField-Values.sql
# Oracle EBS SQL Query to pull down all flexfield
# values based upon a specified flex value set name.
SELECT fv.*
FROM applsys.fnd_flex_values fv,applsys.fnd_flex_value_sets fvs
WHERE fvs.flex_value_set_id = fv.flex_value_set_id
AND fvs.flex_value_set_name = '<FLEX_FIELD_VALUE_NAME>';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment