Oracle EBS FND-AOL Table Names and Description :-
FND_APPLICATION :- Applications registered with Oracle Application Object Library
FND_CONCURRENT_PROGRAMS :- stores information about concurrent programs. Each row includes a name and description of the concurrent program. Each row also includes the execution methods for the program
FND_CONCURRENT_REQUESTS :- stores information about individual concurrent requests, complete history of all concurrent requests
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, Each row also includes the customization level for the lookup type, the security group the lookup type belongs to and the application view through with the lookup type will be exposed
FND_LOOKUP_VALUES :- Lookup type values
FND_MENUS :- Table lists the menus that appear in the Navigate Window, as determined by the System Administrator when defining responsibilities for function security
FND_PROFILE_OPTIONS :- stores information about user profile options.Each row includes names (the actual profile option name and the more descriptive end-user name) and a description of the profile option. Each row also includes the LOV definition, if any, that this profile option uses to ensure that users enter a valid value for the option, as well as flags that indicate whether users can see or change its value and flags that indicate whether certain Oracle Application Object Library routines can manipulate this option
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 :- stores information about responsibilities. Each row includes the name and description of the responsibility, the application it belongs to, and values that identify the main menu, and the first form that it uses
FND_RESP_FUNCTIONS :- Function Security
FND_USER :- stores information about application users. Each row includes the user's username (what a user types in at the sign-on screen), password, and information on when the user should change the password
No comments:
Post a Comment