FLEX FIELDS

Keyflexfields and the tables in which they store their code combinations.
AccountingFlexfield GL_CODE_COMBINATIONS
CategoryFlexfield FA_CATEGORIES_B
Asset KeyFlexfield FA_ASSET_KEYWORDS
LocationFlexfield FA_LOCATIONS
Oracle Service ItemFlexfield MTL_SYSTEM_ITEMS_B
TerritoryFlexfield RA_TERRITORIES
Sales Tax LocationFlexfield AR_LOCATION_COMBINATIONS
Item Categories MTL_CATEGORIES_B
Account Aliases MTL_GENERIC_DISPOSITIONS
Item Catalogs MTL_ITEM_CATALOG_GROUPS
Sales Orders MTL_SALES_ORDERS
System Items MTL_SYSTEM_ITEMS_B
Stock Locators MTL_ITEM_LOCATIONS
GradeFlexfield PER_GRADE_DEFINITIONS
JobFlexfield PER_JOB_DEFINITIONS
Personal AnalysisFlexfield PER_ANALYSIS_CRITERIA
PositionFlexfield PER_POSITION_DEFINITIONS
Soft CodedKeyFlexfield HR_SOFT_CODING_KEYFLEX
Bank DetailsKeyFlexField PAY_EXTERNAL_ACCOUNTS
Cost AllocationFlexfield PAY_COST_ALLOCATION_KEYFLEX
People GroupFlexfield PAY_PEOPLE_GROUPS



Descriptive Flexfield and the tables in which they store their code combinations.
Accounting Calendar: Calendar GL_PERIOD_SETS
Accounting Calendar: Periods GL_PERIODS
AutoAccounting Rules GL_IEA_AUTOGEN_MAP
AutoAllocationBatch GL_AUTO_ALLOC_BATCHES
AutoPostCriteria GL_AUTOMATIC_POSTING_OPTIONS
AutoReversalCriteria GL_AUTOREVERSE_OPTIONS
Automatic Posting Sets GL_AUTOMATIC_POSTING_SETS
Budget Types GL_BUDGET_TYPES
Budget Versions GL_BUDGET_VERSIONS
Budgetary Control Group: Group GL_BC_OPTIONS
Budgetary Control Group: Rules GL_BC_OPTION_DETAILS
Common Stocks: Share Activity GL_SHARES_ACTIVITY
Conversion Rate Types GL_DAILY_CONVERSION_TYPES


Value Set Usage by KeyFlexfields

select flex_value_set_name "Value Set",

descriptive_flexfield_name "Flexfield",

descriptive_flex_context_code "Structure",

end_user_column_name "Column"

from apps.fnd_descr_flex_column_usages a,

apps.fnd_flex_value_sets b

where a.flex_value_set_id = b.flex_value_set_id

and descriptive_flexfield_name not like '$SRS$%'

order by flex_value_set_name,

descriptive_flexfield_name,

descriptive_flex_context_code;


Value Set Usage by DescriptiveFlexfields

select d.flex_value_set_name "Value Set",

a.id_flex_name "Flexfield",

e.id_flex_structure_name "Structure",

c.segment_name "Segment"

from apps.fnd_id_flexsa,

apps.fnd_id_flex_structures b,

apps.fnd_id_flex_segments c,

apps.fnd_flex_value_sets d,

apps.fnd_id_flex_structures_tle

where a.application_id = b.application_id

and a.id_flex_code = b.id_flex_code

and b.application_id = c.application_id

and b.id_flex_code = c.id_flex_code

and b.id_flex_num = c.id_flex_num

and c.flex_value_set_id = d.flex_value_set_id

and c.application_id = e.application_id

and c.id_flex_code = e.id_flex_code

order by d.flex_value_set_name, a.id_flex_name,

e.id_flex_structure_name;