AOL - APPLICATIONS OBJECT LIBRARY

FND – Application Object Library

Table Name Description 
FND_APPLICATION ======> Applications registered with Oracle Application Object Library
FND_CONCURRENT_PROGRAMS ======>Concurrent programs
FND_CONCURRENT_REQUESTS ======>Concurrent requests information
FND_CURRENCIES ======>Currencies enabled for use at your site
FND_DATA_GROUPS ======>Data groups registered with Oracle Application Object Library
FND_FLEX_VALUES ======>Valid values for flexfield segments
FND_FLEX_VALUE_HIERARCHIES ======>Child value ranges for key flexfield segment values
FND_FLEX_VALUE_SETS ======>Value sets used by both key and descriptive flexfields
FND_FORM ======>Application forms registered with Oracle Application Object Library
FND_FORM_FUNCTIONS ======>Functionality groupings
FND_ID_FLEXS ======>Registration information about key flexfields
FND_ID_FLEX_SEGMENTS ======>Key flexfield segments setup information and correspondences between table columns and key flexfield segments
FND_ID_FLEX_STRUCTURES ======>Key flexfield structure information
FND_LOOKUP_TYPES ======>Oracle Application Object Library QuickCodes
FND_LOOKUP_VALUES ======>QuickCode values
FND_MENUS ======>New menu tabl for Release 10SC
FND_PROFILE_OPTIONS ======>User profile options
FND_PROFILE_OPTION_VALUES ======>Values of user profile options defined at different profile levels
FND_REQUEST_SETS ======>Reports sets
FND_REQUEST_SET_PROGRAMS ======>Reports within report sets
FND_REQUEST_SET_STAGES ======>Stores request set stages
FND_RESPONSIBILITY ======>Responsibilities
FND_RESP_FUNCTIONS ======>Function Security
FND_USER ======>Application users

--Value Sets based on table:
select ffvs.flex_value_set_id ,
    ffvs.flex_value_set_name ,
    ffvs.description set_description ,
    ffvs.validation_type,
    ffvt.value_column_name ,
    ffvt.meaning_column_name ,
    ffvt.id_column_name ,
    ffvt.application_table_name ,
    ffvt.additional_where_clause
FROM fnd_flex_value_sets ffvs ,
    fnd_flex_validation_tables ffvt
WHERE ffvs.flex_value_set_id = ffvt.flex_value_set_id;

--Independent values
SELECT ffvs.flex_value_set_id ,
    ffvs.flex_value_set_name ,
    ffvs.description set_description ,
    ffvs.validation_type,
    ffv.flex_value_id ,
    ffv.flex_value ,
    ffvt.flex_value_meaning ,
    ffvt.description value_description
FROM fnd_flex_value_sets ffvs ,
    fnd_flex_values ffv ,
    fnd_flex_values_tl ffvt
WHERE
    ffvs.flex_value_set_id     = ffv.flex_value_set_id
    and ffv.flex_value_id      = ffvt.flex_value_id
    AND ffvt.language          = USERENV('LANG');