Infolinks

Saturday 23 June 2012

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;

No comments:

Post a Comment