FLEX FIELDS

FLEX FIELDS

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;