My FND Table Descriptions hand book (I have big hands) part3

Application Object Library - FND_FLEX_VALUE_RULES	Security rules for flexfield values
Column Name	Descritpion
FLEX_VALUE_RULE_ID	The identifier for the flexfield value security rule
PARENT_FLEX_VALUE_LOW	The independent value upon which the dependent value depends
PARENT_FLEX_VALUE_HIGH	Not currently used
FLEX_VALUE_RULE_NAME	The name of the security rule
FLEX_VALUE_SET_ID	Flexfield value set identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Application Object Library - FND_FLEX_VALUE_RULE_LINES	Rule elements for flexfield value security rules
Column Name	Descritpion
FLEX_VALUE_RULE_ID	The identifier of the flexfield value security rule
LAST_UPDATE_LOGIN	Standard Who column
INCLUDE_EXCLUDE_INDICATOR	Flag to indicate if the element is an include or exclude rule element
FLEX_VALUE_LOW	The low segment value for the range included or excluded by the rule element
FLEX_VALUE_HIGH	The high segment value for the range included or excluded by the rule element
PARENT_FLEX_VALUE_LOW	The independent value upon which the dependent value depends
PARENT_FLEX_VALUE_HIGH	Not currently used
FLEX_VALUE_SET_ID	Flexfield value set identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_LANGUAGES	National dialects
Column Name	Descritpion
LANGUAGE_ID	Language identifier
NLS_LANGUAGE	Language name
NLS_TERRITORY	The territory using the language
ISO_LANGUAGE	The ISO symbol for the language
ISO_TERRITORY	The ISO symbol for the territory
NLS_CODESET	The code set for the language
INSTALLED_FLAG	Flag to indicate if the language is installed and available for use
CREATED_BY	Standard Who column
LANGUAGE_CODE	Language code
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LOCAL_DATE_LANGUAGE	Language name used to represent month part of date
UTF8_DATE_LANGUAGE	Language to use if running UNICODE
ISO_LANGUAGE_3	3 letter language code

Application Object Library - FND_LOGINS	Sign-On Audit information about who signs on to an application and when
Column Name	Descritpion
LOGIN_ID	Identifier of login session
SUBMITTED_LOGIN_ID	The user who submitted the concurrent request that starts this sign-on session
SERIAL#	Serial number
PROCESS_SPID	SPID of process
LOGIN_TYPE	Type of session
USER_ID	User identifier
START_TIME	The starting time of this login session
END_TIME	Time when this login session ends
PID	Oracle process identifier
SPID	Operating system process identifier
TERMINAL_ID	Terminal identifier from which user starts this session
LOGIN_NAME	The username used to sign on to Oracle Applications
SESSION_NUMBER	The number of times the user has signed on to an application since you upgraded Oracle Applications to Release 7

Application Object Library - FND_LOGIN_RESPONSIBILITIES	Sign-On Audit information about when and who changes responsibilities in an application
Column Name	Descritpion
LOGIN_ID	Identifier of the user's login session
LOGIN_RESP_ID	The responsibility to which the user signed on
RESP_APPL_ID	The application identifier with which the responsibility is defined
RESPONSIBILITY_ID	Responsibility identifier
START_TIME	The time when the user is in the responsibility
END_TIME	The time when the user left the responsibility
AUDSID	db audsid (v$session.audsid)
RESOURCE_CONSUMER_GROUP	Resource consumer group

Application Object Library - FND_LOGIN_RESP_FORMS	Sign-On Audit information about when and who used which forms in an application
Column Name	Descritpion
LOGIN_ID	Identifier of the user's login session
LOGIN_RESP_ID	The responsibility to which the user signs on
FORM_APPL_ID	The identifier of the application the user is in
FORM_ID	Form identifier
START_TIME	The time the session begins
END_TIME	The time the session ends
ZOOM_LEVEL	The zoom level the user is in
AUDSID	db audsid (v$session.audsid)
RESOURCE_CONSUMER_GROUP	Resource consumer group

Application Object Library - FND_FLEX_VALUE_RULE_USAGES	Flexfield security rules assigned to responsibilities
Column Name	Descritpion
APPLICATION_ID	Application identifier
LAST_UPDATE_LOGIN	Standard Who column
FLEX_VALUE_SET_ID	Flexfield value set identifier
PARENT_FLEX_VALUE_LOW	The independent value upon which the dependent value depends
PARENT_FLEX_VALUE_HIGH	Not currently used
RESPONSIBILITY_ID	Responsibility identifier
FLEX_VALUE_RULE_ID	Flexfield value security rule identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_FLEX_HIERARCHIES	Flexfield hierarchy name for flexfield values
Column Name	Descritpion
FLEX_VALUE_SET_ID	Flexfield value set identifier
LAST_UPDATE_LOGIN	Standard Who column
HIERARCHY_CODE	Developer key for flexfield hierarchy
HIERARCHY_ID	Hierarchy identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_FLEX_VALUE_NORM_HIERARCHY	Multiple level hierarchies
Column Name	Descritpion
FLEX_VALUE_SET_ID	Flexfield value set identifier
LAST_UPDATE_LOGIN	Standard Who column
START_DATE_ACTIVE	Obsolete, no longer used Table
END_DATE_ACTIVE	Obsolete, no longer used
PARENT_FLEX_VALUE	The parent value to which the range belongs
RANGE_ATTRIBUTE	Flag to distinguish a child value from a parent value
CHILD_FLEX_VALUE_LOW	The low value of the range of child values
CHILD_FLEX_VALUE_HIGH	The high value of the range of child values
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_NODES	Nodes or machines used to install and run Oracle Applications
Column Name	Descritpion
NODE_ID	NODE_ID
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PLATFORM_CODE	Make of the node/machine
DESCRIPTION	Description
BASEPATH	The variable on R10SC clients that contains platform dependent information used for locating files written by Concurrent Managers on this node
SUPPORT_CP	Indicates that on this node Concurrent Processing is running
SUPPORT_FORMS	Indicates that on this node Forms server is running
SUPPORT_WEB	Indicates that on this node Apache server is running
SUPPORT_ADMIN	Indicates that on this node Admin is running
STATUS	Encapsulates the status of a node
SERVER_ID	SERVER_D
PING_RESPONSE	Response received on pinging the node
LAST_MONITORED_TIME	Timestamp of most recent ping
NODE_MODE	Different states of the node such as enabled, disabled.
WEBHOST	WEBHOST
VIRTUAL_IP	stores virtual ip address
SUPPORT_DB	This node supports database instance or not valid values or Y/N
APPLTOP_ID	APPLTOP accessed on this node
SERVER_ADDRESS	SERVER_ADDRESS
HOST	HOST
DOMAIN	DOMAIN
NODE_NAME	Node/Machine name
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Application Object Library - FND_FOREIGN_KEYS	Foreign keys registered with Oracle Application Object Library
Column Name	Descritpion
APPLICATION_ID	Application identifier
PRIMARY_KEY_APPLICATION_ID	Primary key application identifier
PRIMARY_KEY_TABLE_ID	Primary key table identifier
PRIMARY_KEY_ID	Primary key identifier
CASCADE_BEHAVIOR	Cascade behavior
FOREIGN_KEY_RELATION	Foreign key relation
TABLE_ID	Table identifier
DESCRIPTION	Description
CONDITION	Condition statement for conditional foreign keys (arc relationships)
ENABLED_FLAG	Determines whether this key will be created as an enabled or disabled constraint
FOREIGN_KEY_ID	Foreign key identifier
FOREIGN_KEY_NAME	Foreign key name
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Application Object Library - FND_FOREIGN_KEY_COLUMNS	Foreign key columns registered with Oracle Application Object Library
Column Name	Descritpion
APPLICATION_ID	Application identifier
LAST_UPDATE_LOGIN	Standard Who column
CASCADE_VALUE	Cascade value
TABLE_ID	Table identifier
FOREIGN_KEY_ID	Foreign key identifier
FOREIGN_KEY_SEQUENCE	Sequence of the column in the foreign key
COLUMN_ID	Column identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_INDEX_COLUMNS	Index columns registered with Oracle Application Object Library
Column Name	Descritpion
APPLICATION_ID	Application identifier
LAST_UPDATE_LOGIN	Standard Who column
TABLE_ID	Table identifier
INDEX_ID	Index identifier
COLUMN_SEQUENCE	The position of the column in the index
COLUMN_ID	Column identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_FLEX_VALIDATION_EVENTS	Validation events for special validated value sets
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
USER_EXIT	The user exit call for the event
FLEX_VALUE_SET_ID	Flexfield value set identifier
EVENT_CODE	Type of the event
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_FLEXBUILDER_FUNCTIONS	Flexbuilder functions setup information
Column Name	Descritpion
APPLICATION_ID	Application identifier
ID_FLEX_CODE	Key flexfield code
DESCRIPTION	Description
FUNCTION_CODE	Flexbuilder function code
FUNCTION_NAME	Flexbuilder function name
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FLEXFIELD_APPLICATION_ID	Flexfield application identifier

Application Object Library - FND_FLEXBUILDER_PARAMETERS	Flexbuilder parameters
Column Name	Descritpion
APPLICATION_ID	Application identifier
LAST_UPDATE_LOGIN	Standard Who column
ASSIGNMENT_TYPE	Type of assignment
PARAMETER_TYPE	Type of parameter
PROTECTED_FLAG	Flag to indicate whether this flexbuilder parameter is protected against update
DESCRIPTION	Description
FUNCTION_CODE	Flexbuilder function code
APPLICATION_COLUMN_NAME	Column name
SEGMENT_ATTRIBUTE_TYPE	Flexfield identifier for identifying segments in the flexfield
CONDITIONAL_PARAMETER	Parameter name used to conditionally derive the value of the parameter
CONDITIONAL_VALUE	Value of the conditional parameter
CONSTANT_VALUE	Constant value for the parameter
FLEXFIELD_APPLICATION_ID	Identifier of the application with which the flexfield is registered
FLEX_VALUE_SET_ID	Flexfield value set identifier
ASSIGNMENT_VALUE_SET_ID	Assignment value set identifier
VALUE_SET_MATCH_REQUIRED_FLAG	DECODE(parameter_type, 'D', 'Y', NULL)
ID_FLEX_CODE	Key flexfield code
SEQUENCE	The sequence in which the parameter is to be derived
ID_FLEX_NUM	Key flexfield number
ID_PARAMETER	Source parameter for identifying a code combination
OUTPUT_COLUMN	Output column of the value set
SOURCE_PARAMETER	Source parameter to identify a value in the value set
PARAMETER_NAME	Parameter name
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_INDEXES	Unique and non-unique indexes registered with Oracle Application Object Library
Column Name	Descritpion
APPLICATION_ID	Application identifier
AUTO_SIZE	Is this index automatically sized during an install?
INI_TRANS	Initial number of transactions
MAX_TRANS	Maximum number of transactions
INITIAL_EXTENT	Initial extent
NEXT_EXTENT	Next extent
MIN_EXTENTS	Minimum extent
MAX_EXTENTS	Maximum extent
PCT_FREE	Percent of free space
PCT_INCREASE	Percent of free space to increase
TABLE_ID	Table identifier
UNIQUENESS	Uniqueness
DESCRIPTION	Description
INDEX_ID	Index identifier
INDEX_NAME	Index name
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Application Object Library - FND_FLEX_VALIDATION_RULES	Key flexfield cross-validation rules or line detail
Column Name	Descritpion
APPLICATION_ID	select t.application_id from fnd_tables t, fnd_id_flexs f where t.table_name = f.application_table_name and f.id_flex_code = fnd_flex_validation_rules.id_flex_code and rownum = 1
LAST_UPDATE_LOGIN	Standard Who column
ENABLED_FLAG	Flag to indicate whether the cross-validation rule is enabled
ID_FLEX_CODE	Key flexfield code
ERROR_SEGMENT_COLUMN_NAME	The column name corresponding to the segment causing the cross-validation rule to fail
START_DATE_ACTIVE	The date the cross-validation rule becomes active
END_DATE_ACTIVE	The date the cross-validation rule expires
ID_FLEX_NUM	Key flexfield structure number
FLEX_VALIDATION_RULE_NAME	Name of the cross-validation rule
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_NEW_MESSAGES	Application messages for Oracle Applications in GUI mode
Column Name	Descritpion
LANGUAGE_CODE	Language code
MESSAGE_NUMBER	The message number
MESSAGE_NAME	Message name
MESSAGE_TEXT	The short message
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
APPLICATION_ID	Application identifier
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description
TYPE	Message type
MAX_LENGTH	Maximum number of display characters the translators can use to translate the message
CATEGORY	'SYSTEM', 'PRODUCT', or null - This will allow user interfaces and other programs to filter exception messages based on category
SEVERITY	'CRITICAL', 'ERROR', 'WARNING', or null - This will allow user interfaces and other programs to filter exception messages based on severity
FND_LOG_SEVERITY	Severity to log message at

Application Object Library - FND_FOLDERS	Customized folder definitions
Column Name	Descritpion
PUBLIC_FLAG	Flag to indicate if the folder can be opened by users other than the owner
AUTOQUERY_FLAG	Flag to indicate whether to perform autoquery when the folder is opened
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
FOLDER_ID	Folder identifier
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
WHERE_CLAUSE	Where clause
ORDER_BY	Order by clause
LANGUAGE	Language code. Language for which folder definition applies
OBJECT	Folder object
NAME	Folder name
WINDOW_WIDTH	Width

Application Object Library - FND_FOLDER_COLUMNS	Displayed columns in folders
Column Name	Descritpion
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FOLDER_ID	Folder identifier
ITEM_WIDTH	Item width in inches
ITEM_PROMPT	Display prompt for the item
X_POSITION	Screen position of the field when user last saved folder
Y_POSITION	Screen position of the field when user last saved folder
DISPLAY_MODE	Always 'N'
ITEM_NAME	Item name
SEQUENCE	Sequence

Application Object Library - FND_FLEX_VALIDATION_QUALIFIERS	Assignment information for flexfield qualifiers
Column Name	Descritpion
SEGMENT_ATTRIBUTE_TYPE	Flexfield qualifier
VALUE_ATTRIBUTE_TYPE	Segment qualifier
ASSIGNMENT_DATE	When the qualifier was assigned to this value set
FLEX_VALUE_SET_ID	The flexfield value set identifier
ID_FLEX_APPLICATION_ID	Key flexfield application identifier
ID_FLEX_CODE	Key flexfield code

Application Object Library - FND_FLEXBUILDER_PARAMS_TL	Translations for FND_FLEXBUILDER_PARAMETERS
Column Name	Descritpion
LANGUAGE	Language
USER_PARAMETER_NAME	The descriptive title of the parameter
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
APPLICATION_ID	Application identifier
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
FUNCTION_CODE	Flexbuilder function code
SEQUENCE	The sequence in which the parameter is to be derived
PARAMETER_NAME	Parameter name

Application Object Library - FND_FLEX_VALUES_TL	Translations for FND_FLEX_VALUES
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FLEX_VALUE_ID	Flexfield segment value identifier
DESCRIPTION	Description
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
FLEX_VALUE_MEANING	Flexfield segment value meaning
LANGUAGE	Language

Application Object Library - FND_FLEX_HIERARCHIES_TL	Translations for FND_FLEX_HIERARCHIES
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
FLEX_VALUE_SET_ID	Flexfield value set identifier
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
HIERARCHY_ID	Hierarchy identifier
HIERARCHY_NAME	Hierarchy name
LANGUAGE	Language

Application Object Library - FND_FLEX_VDATION_RULES_TL	Translations for FND_FLEX_VALIDATION_RULES
Column Name	Descritpion
LANGUAGE	Language
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
APPLICATION_ID	Application identifier
LAST_UPDATE_LOGIN	Standard Who column
ERROR_MESSAGE_TEXT	The error message to be displayed when the rule is violated
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
DESCRIPTION	Description
ID_FLEX_CODE	Key flexfield code
ID_FLEX_NUM	Key flexfield structure number
FLEX_VALIDATION_RULE_NAME	Name of the cross-validation rule

Application Object Library - FND_FLEX_VALUE_RULES_TL	Translations for FND_FLEX_VALUE_RULES
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FLEX_VALUE_RULE_ID	Flexfield value security rule identifier
ERROR_MESSAGE	The message to display when the security rule is being violated
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
DESCRIPTION	Description
LANGUAGE	Language
LAST_UPDATE_DATE	Standard Who column

Application Object Library - FND_FORM_TL	Translations for FND_FORM
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
APPLICATION_ID	Application identifier
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
FORM_ID	Form identifier
LANGUAGE	Language
USER_FORM_NAME	Form title

Application Object Library - FND_ID_FLEX_STRUCTURES_TL	Translations for FND_ID_FLEX_STRUCTURES
Column Name	Descritpion
LANGUAGE	Language
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
APPLICATION_ID	Application identifier
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ID_FLEX_STRUCTURE_NAME	Key flexfield structure name
DESCRIPTION	Description
SHORTHAND_PROMPT	The display prompt for shorthand window
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
ID_FLEX_CODE	Key flexfield code
ID_FLEX_NUM	Key flexfield structure number

Application Object Library - FND_ID_FLEX_SEGMENTS_TL	Translations for FND_ID_FLEX_SEGMENTS
Column Name	Descritpion
LANGUAGE	Language
LAST_UPDATE_DATE	Standard Who column
APPLICATION_ID	Application identifier
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FORM_LEFT_PROMPT	The left prompt for the segment in the flexfield window
FORM_ABOVE_PROMPT	The above prompt for the segment in the flexfield window
DESCRIPTION	Description
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
ID_FLEX_CODE	Key flexfield code
ID_FLEX_NUM	Key flexfield structure number
APPLICATION_COLUMN_NAME	Flexfield column name

Application Object Library - FND_LOOKUP_TYPES	Oracle Application Object Library QuickCodes
Column Name	Descritpion
CUSTOMIZATION_LEVEL	Customization level
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SECURITY_GROUP_ID	Security group identifier
VIEW_APPLICATION_ID	Application identifier of view (_LOOKUPS) through which the lookup type will be exposed
ASSIGN_LEAF_ONLY	Assign Leaf Only Flag
APPLICATION_ID	Application identifier
LOOKUP_TYPE	QuickCode lookup type

Application Object Library - FND_LOOKUP_VALUES	QuickCode values
Column Name	Descritpion
DESCRIPTION	Description
ATTRIBUTE11	Attribute
ATTRIBUTE12	Attribute
ATTRIBUTE13	Attribute
ATTRIBUTE14	Attribute
ENABLED_FLAG	Enabled flag
ATTRIBUTE15	Attribute
TAG	Optional additional category for lookup values
LEAF_NODE	Leaf Node Flag
START_DATE_ACTIVE	The date when the QuickCode becomes active
END_DATE_ACTIVE	The date when the QuickCode becomes inactive
CREATED_BY	Standard Who column
LOOKUP_TYPE	QuickCode lookup type
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LAST_UPDATE_DATE	Standard Who column
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
SECURITY_GROUP_ID	Security group identifier
VIEW_APPLICATION_ID	Identifies which application's view will include the lookup values
LANGUAGE	Language
TERRITORY_CODE	Territory code of territory using the language
ATTRIBUTE_CATEGORY	Attribute category
ATTRIBUTE1	Attribute
ATTRIBUTE2	Attribute
LOOKUP_CODE	QuickCode code
ATTRIBUTE3	Attribute
ATTRIBUTE4	Attribute
ATTRIBUTE5	Attribute
ATTRIBUTE6	Attribute
MEANING	QuickCode meaning
ATTRIBUTE7	Attribute
ATTRIBUTE8	Attribute
ATTRIBUTE9	Attribute
ATTRIBUTE10	Attribute

Application Object Library - FND_LANGUAGES_TL	Translations for FND_LANGUAGES
Column Name	Descritpion
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LANGUAGE_CODE	Language code
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
LANGUAGE	Language
DESCRIPTION	Description
CREATED_BY	Standard Who column

Application Object Library - FND_FORM_FUNCTIONS	Functionality groupings
Column Name	Descritpion
REGION_CODE	REGIONS_CODE
MAINTENANCE_MODE_SUPPORT	Whether this function supports limited functionalitywhile the environment is partially down
FUNCTION_NAME	Function name
CONTEXT_DEPENDENCE	What aspect of the current context this function'sbehavior depends on
JRAD_REF_PATH	JRAD_REF_PATH
IREP_METHOD_NAME	Native Method Name
IREP_OVERLOAD_SEQUENCE	Overload Sequence
IREP_SCOPE	Scope
IREP_LIFECYCLE	Lifecycle
IREP_DESCRIPTION	Full Description
IREP_COMPATIBILITY	Compatability Flag
IREP_INBOUND_XML_DESCRIPTION	Inbound XML Schema
IREP_OUTBOUND_XML_DESCRIPTION	Outbound XML Schema
IREP_SYNCHRO	Synchronicity
APPLICATION_ID	Application identifier
IREP_DIRECTION	Map Direction
IREP_ASSOC_FUNCTION_NAME	Base Method
IREP_CLASS_ID	Parent Interface
IREP_SCHEMA_VALIDATION_FLAG	Flag used for schema validation
FORM_ID	Form identifier
PARAMETERS	Parameters
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
TYPE	Function type
FUNCTION_ID	Function identifier
WEB_HOST_NAME	IP address or alias of machine where the Webserver is running. Defaults to the last agent used
WEB_AGENT_NAME	Name of Oracle Web Agent. Defaults to the last agent used
WEB_HTML_CALL	Contains the URL to activate this function. It may be either a static page or a procedure
WEB_ENCRYPT_PARAMETERS	Flag signifies when encrypt parameters are on a web page
WEB_SECURED	Indicates whether a function can be run without authentication the user
WEB_ICON	Icon name for OSSWA menu display
OBJECT_ID	OBJECT_ID
REGION_APPLICATION_ID	REGION_APPLICATION_ID

Application Object Library - FND_FORM_FUNCTIONS_TL	Translations for FND_FORM_FUNCTIONS
Column Name	Descritpion
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description
LANGUAGE	Language
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
FUNCTION_ID	Function identifier
USER_FUNCTION_NAME	Function title
CREATION_DATE	Standard Who column

Application Object Library - FND_MENUS	New menu tabl for Release 10SC
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
MENU_ID	Menu identifier
MENU_NAME	Menu name
TYPE	TYPE
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Application Object Library - FND_MENUS_TL	Translations for FND_MENUS
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LANGUAGE	Language
DESCRIPTION	Description
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
MENU_ID	Menu identifier
USER_MENU_NAME	Displayed name of menu

Application Object Library - FND_MENU_ENTRIES	Individual entries in navigate window menus for Release 10SC
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
SUB_MENU_ID	Submenu attached to the entry
FUNCTION_ID	Function attached to the entry
MENU_ID	Menu identifier
GRANT_FLAG	GRANT_FLAG
ENTRY_SEQUENCE	The order the menu entry will be shown in the menu
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Application Object Library - FND_MENU_ENTRIES_TL	Translations for FND_MENU_ENTRIES
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LANGUAGE	Language
PROMPT	Navigate window prompt
DESCRIPTION	Description
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
MENU_ID	Menu identifier from FND_MENU_ENTRIES
ENTRY_SEQUENCE	Entry sequence from FND_MENU_ENTRIES

Application Object Library - FND_FLEX_VALIDATION_RULE_LINES	Cross-validation rule elements for key flexfields
Column Name	Descritpion
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ENABLED_FLAG	Flag to indicate whether the cross-validation rule element is enabled
CONCATENATED_SEGMENTS_LOW	Concatenated set of low segment values that make up the range included or excluded by the rule element
CONCATENATED_SEGMENTS_HIGH	The concatenated set of high segment values that make up the range included or excluded by the rule element
INCLUDE_EXCLUDE_INDICATOR	Code to indicate whether the element is an include or exclude element
DESCRIPTION	Description
RULE_LINE_ID	fnd_flex_val_rule_lines_s.nextval
APPLICATION_ID	select t.application_id from fnd_tables t, fnd_id_flexs f where t.table_name = f.application_table_name and f.id_flex_code = fnd_flex_validation_rule_lines.id_flex_code and rownum = 1
ID_FLEX_CODE	Key flexfield code
ID_FLEX_NUM	Key flexfield structure number
FLEX_VALIDATION_RULE_NAME	Name of cross-validation rule
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Application Object Library - FND_FLEX_VALIDATION_TABLES	Flexfield validation tables
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
VALUE_COLUMN_NAME	Value column name
VALUE_COLUMN_TYPE	Value column type
VALUE_COLUMN_SIZE	Size of value column
COMPILED_ATTRIBUTE_COLUMN_NAME	The column name COMPILED_VALUE_ATTRIBUTES if the column exists in the validation table
ENABLED_COLUMN_NAME	The column name ENABLED_FLAG if the column exists in the validation table
HIERARCHY_LEVEL_COLUMN_NAME	The column name STRUCTURED_HIERARCHY_LEVEL if the column exists in the validation table
START_DATE_COLUMN_NAME	The column name START_DATE_ACTIVE if the column exists in the validation table
END_DATE_COLUMN_NAME	The column name END_DATE_ACTIVE if the column exists in the validation table
SUMMARY_ALLOWED_FLAG	Flag to indicate whether the parent value is allowed to be stored in the FND_FLEX_VALUES table and displayed in the LOV for a segment using this value set
SUMMARY_COLUMN_NAME	The column name SUMMARY_FLAG if the column exists in the validation table
ID_COLUMN_NAME	Hidden ID column name
ID_COLUMN_SIZE	Size of ID column
ID_COLUMN_TYPE	ID column type
MEANING_COLUMN_NAME	Meaning column name
MEANING_COLUMN_SIZE	Size of meaning column
MEANING_COLUMN_TYPE	Meaning column type
FLEX_VALUE_SET_ID	Flexfield value set identifier
TABLE_APPLICATION_ID	Table application identifier
ADDITIONAL_WHERE_CLAUSE	The SQL WHERE clause
ADDITIONAL_QUICKPICK_COLUMNS	Additional columns to display in the LOV list
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
APPLICATION_TABLE_NAME	Table name

Application Object Library - FND_FLEX_VALUES	Valid values for flexfield segments
Column Name	Descritpion
FLEX_VALUE_SET_ID	Flexfield value set identifier
LAST_UPDATE_LOGIN	Standard Who column
ENABLED_FLAG	Flag to indicate if the flexfield segment value is enabled
SUMMARY_FLAG	Flag to indicate if the value is a parent value with child values
START_DATE_ACTIVE	The date the value becomes active
END_DATE_ACTIVE	The date the value expires
FLEX_VALUE_ID	Flexfield segment value identifier
PARENT_FLEX_VALUE_LOW	Independent value that is depended upon by the dependent segment value
PARENT_FLEX_VALUE_HIGH	Not currently used
STRUCTURED_HIERARCHY_LEVEL	The rollup group to which the parent value belongs
HIERARCHY_LEVEL	Hierarchy level
COMPILED_VALUE_ATTRIBUTES	The compiled values of any segment qualifier assigned to the segment value
VALUE_CATEGORY	The context column that contains the flexfield structure
FLEX_VALUE	Flexfield segment value
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE16	Descriptive flexfield segment
ATTRIBUTE17	Descriptive flexfield segment
ATTRIBUTE18	Descriptive flexfield segment
ATTRIBUTE19	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE20	Descriptive flexfield segment
ATTRIBUTE21	Descriptive flexfield segment
ATTRIBUTE22	Descriptive flexfield segment
ATTRIBUTE23	Descriptive flexfield segment
ATTRIBUTE24	Descriptive flexfield segment
ATTRIBUTE25	Descriptive flexfield segment
ATTRIBUTE26	Descriptive flexfield segment
ATTRIBUTE27	Descriptive flexfield segment
ATTRIBUTE28	Descriptive flexfield segment
ATTRIBUTE29	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE30	Descriptive flexfield segment
ATTRIBUTE31	Descriptive flexfield segment
ATTRIBUTE32	Descriptive flexfield segment
ATTRIBUTE33	Descriptive flexfield segment
ATTRIBUTE34	Descriptive flexfield segment
ATTRIBUTE35	Descriptive flexfield segment
ATTRIBUTE36	Descriptive flexfield segment
ATTRIBUTE37	Descriptive flexfield segment
ATTRIBUTE38	Descriptive flexfield segment
ATTRIBUTE39	Descriptive flexfield segment
CREATION_DATE	Standard Who column
ATTRIBUTE40	Descriptive flexfield segment
ATTRIBUTE41	Descriptive flexfield segment
ATTRIBUTE42	Descriptive flexfield segment
ATTRIBUTE43	Descriptive flexfield segment
ATTRIBUTE44	Descriptive flexfield segment
ATTRIBUTE45	Descriptive flexfield segment
ATTRIBUTE46	Descriptive flexfield segment
ATTRIBUTE47	Descriptive flexfield segment
ATTRIBUTE48	Descriptive flexfield segment
ATTRIBUTE49	Descriptive flexfield segment
CREATED_BY	Standard Who column
ATTRIBUTE50	Descriptive flexfield segment
ATTRIBUTE_SORT_ORDER	Sort Order for Flex Values

Application Object Library - FND_FLEX_HASH	Prevents conflicts when creating new flexfield combinations
Column Name	Descritpion
HASH_VALUE	Hash value
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Application Object Library - FND_FLEX_VALUE_HIERARCHIES	Child value ranges for key flexfield segment values
Column Name	Descritpion
FLEX_VALUE_SET_ID	Flexfield value set identifier
LAST_UPDATE_LOGIN	Standard Who column
START_DATE_ACTIVE	The date the value hierarchy becomes active
END_DATE_ACTIVE	The date the value hierarchy expires
PARENT_FLEX_VALUE	The parent value to which the range belongs
CHILD_FLEX_VALUE_LOW	The low value of the range of child values
CHILD_FLEX_VALUE_HIGH	The high value of the range of child values
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_FLEX_EXCLUDE_RULE_LINES	Stores cross-validation rule elements
Column Name	Descritpion
RULE_LINE_ID	Rule line identifier
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SEGMENT1_LOW	Minimum value to exclude
SEGMENT1_HIGH	Maximum value to exclude
SEGMENT2_LOW	Minimum value to exclude
SEGMENT2_HIGH	Maximum value to exclude
SEGMENT3_LOW	Minimum value to exclude
SEGMENT3_HIGH	Maximum value to exclude
SEGMENT4_LOW	Minimum value to exclude
SEGMENT4_HIGH	Maximum value to exclude
APPLICATION_ID	Application identifier
SEGMENT5_LOW	Minimum value to exclude
SEGMENT5_HIGH	Maximum value to exclude
SEGMENT6_LOW	Minimum value to exclude
SEGMENT6_HIGH	Maximum value to exclude
SEGMENT7_LOW	Minimum value to exclude
SEGMENT7_HIGH	Maximum value to exclude
SEGMENT8_LOW	Minimum value to exclude
SEGMENT8_HIGH	Maximum value to exclude
SEGMENT9_LOW	Minimum value to exclude
SEGMENT9_HIGH	Maximum value to exclude
ID_FLEX_CODE	Key flexfield code
SEGMENT10_LOW	Minimum value to exclude
SEGMENT10_HIGH	Maximum value to exclude
SEGMENT11_LOW	Minimum value to exclude
SEGMENT11_HIGH	Maximum value to exclude
SEGMENT12_LOW	Minimum value to exclude
SEGMENT12_HIGH	Maximum value to exclude
SEGMENT13_LOW	Minimum value to exclude
SEGMENT13_HIGH	Maximum value to exclude
SEGMENT14_LOW	Minimum value to exclude
SEGMENT14_HIGH	Maximum value to exclude
ID_FLEX_NUM	Structure number of the key flexfield structure
SEGMENT15_LOW	Minimum value to exclude
SEGMENT15_HIGH	Maximum value to exclude
SEGMENT16_LOW	Minimum value to exclude
SEGMENT16_HIGH	Maximum value to exclude
SEGMENT17_LOW	Minimum value to exclude
SEGMENT17_HIGH	Maximum value to exclude
SEGMENT18_LOW	Minimum value to exclude
SEGMENT18_HIGH	Maximum value to exclude
SEGMENT19_LOW	Minimum value to exclude
SEGMENT19_HIGH	Maximum value to exclude
FLEX_VALIDATION_RULE_NAME	Name of cross-validation rule
SEGMENT20_LOW	Minimum value to exclude
SEGMENT20_HIGH	Maximum value to exclude
SEGMENT21_LOW	Minimum value to exclude
SEGMENT21_HIGH	Maximum value to exclude
SEGMENT22_LOW	Minimum value to exclude
SEGMENT22_HIGH	Maximum value to exclude
SEGMENT23_LOW	Minimum value to exclude
SEGMENT23_HIGH	Maximum value to exclude
SEGMENT24_LOW	Minimum value to exclude
SEGMENT24_HIGH	Maximum value to exclude
ENABLED_FLAG	Indicates whether this rule is enabled
SEGMENT25_LOW	Minimum value to exclude
SEGMENT25_HIGH	Maximum value to exclude
SEGMENT26_LOW	Minimum value to exclude
SEGMENT26_HIGH	Maximum value to exclude
SEGMENT27_LOW	Minimum value to exclude
SEGMENT27_HIGH	Maximum value to exclude
SEGMENT28_LOW	Minimum value to exclude
SEGMENT28_HIGH	Maximum value to exclude
SEGMENT29_LOW	Minimum value to exclude
SEGMENT29_HIGH	Maximum value to exclude
LAST_UPDATE_DATE	Standard Who column
SEGMENT30_LOW	Minimum value to exclude
SEGMENT30_HIGH	Maximum value to exclude
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Application Object Library - FND_FLEX_INCLUDE_RULE_LINES	Store cross-validation rule elements
Column Name	Descritpion
RULE_LINE_ID	Rule line identifier
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SEGMENT1_LOW	Minimum value to include
SEGMENT1_HIGH	Maximum value to include
SEGMENT2_LOW	Minimum value to include
SEGMENT2_HIGH	Maximum value to include
SEGMENT3_LOW	Minimum value to include
SEGMENT3_HIGH	Maximum value to include
SEGMENT4_LOW	Minimum value to include
SEGMENT4_HIGH	Maximum value to include
APPLICATION_ID	Application identifier
SEGMENT5_LOW	Minimum value to include
SEGMENT5_HIGH	Maximum value to include
SEGMENT6_LOW	Minimum value to include
SEGMENT6_HIGH	Maximum value to include
SEGMENT7_LOW	Minimum value to include
SEGMENT7_HIGH	Maximum value to include
SEGMENT8_LOW	Minimum value to include
SEGMENT8_HIGH	Maximum value to include
SEGMENT9_LOW	Minimum value to include
SEGMENT9_HIGH	Maximum value to include
ID_FLEX_CODE	Key flexfield code
SEGMENT10_LOW	Minimum value to include
SEGMENT10_HIGH	Maximum value to include
SEGMENT11_LOW	Minimum value to include
SEGMENT11_HIGH	Maximum value to include
SEGMENT12_LOW	Minimum value to include
SEGMENT12_HIGH	Maximum value to include
SEGMENT13_LOW	Minimum value to include
SEGMENT13_HIGH	Maximum value to include
SEGMENT14_LOW	Minimum value to include
SEGMENT14_HIGH	Maximum value to include
ID_FLEX_NUM	Structure number of the key flexfield structure
SEGMENT15_LOW	Minimum value to include
SEGMENT15_HIGH	Maximum value to include
SEGMENT16_LOW	Minimum value to include
SEGMENT16_HIGH	Maximum value to include
SEGMENT17_LOW	Minimum value to include
SEGMENT17_HIGH	Maximum value to include
SEGMENT18_LOW	Minimum value to include
SEGMENT18_HIGH	Maximum value to include
SEGMENT19_LOW	Minimum value to include
SEGMENT19_HIGH	Maximum value to include
FLEX_VALIDATION_RULE_NAME	Name of cross-validation rule
SEGMENT20_LOW	Minimum value to include
SEGMENT20_HIGH	Maximum value to include
SEGMENT21_LOW	Minimum value to include
SEGMENT21_HIGH	Maximum value to include
SEGMENT22_LOW	Minimum value to include
SEGMENT22_HIGH	Maximum value to include
SEGMENT23_LOW	Minimum value to include
SEGMENT23_HIGH	Maximum value to include
SEGMENT24_LOW	Minimum value to include
SEGMENT24_HIGH	Maximum value to include
ENABLED_FLAG	Indicates whether this rule is enabled
SEGMENT25_LOW	Minimum value to include
SEGMENT25_HIGH	Maximum value to include
SEGMENT26_LOW	Minimum value to include
SEGMENT26_HIGH	Maximum value to include
SEGMENT27_LOW	Minimum value to include
SEGMENT27_HIGH	Maximum value to include
SEGMENT28_LOW	Minimum value to include
SEGMENT28_HIGH	Maximum value to include
SEGMENT29_LOW	Minimum value to include
SEGMENT29_HIGH	Maximum value to include
LAST_UPDATE_DATE	Standard Who column
SEGMENT30_LOW	Minimum value to include
SEGMENT30_HIGH	Maximum value to include
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Application Object Library - FND_FLEX_VALIDATION_RULE_STATS	Statistics on the number of key flexfield cross-validation rules
Column Name	Descritpion
APPLICATION_ID	Application identifier
INCLUDE_LINE_COUNT	Number of include rule lines
EXCLUDE_LINE_COUNT	Number of exclude rule lines
ID_FLEX_CODE	Key flexfield code
ID_FLEX_NUM	Key flexfield structure number
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RULE_COUNT	Number of cross-validation rules

Application Object Library - FND_LOCK_HOLDERS	- Retrofitted
Column Name	Descritpion
WAITING_SESSION	- Retrofitted
HOLDING_SESSION	- Retrofitted
LOCK_TYPE	- Retrofitted
MODE_HELD	- Retrofitted
MODE_REQUESTED	- Retrofitted
LOCK_ID1	- Retrofitted
LOCK_ID2	- Retrofitted

Application Object Library - FND_FLEX_VALUE_SETS	Value sets used by both key and descriptive flexfields
Column Name	Descritpion
VALIDATION_TYPE	Validation type
PROTECTED_FLAG	Flag to indicate if this is a protected value set
SECURITY_ENABLED_FLAG	Flag to indicate whether the flexfield security rules for the value set are enabled
LONGLIST_FLAG	Flag to indicate whether the LOV LongList feature for the value set is enabled
FORMAT_TYPE	Format type
MAXIMUM_SIZE	The maximum size of values in the value set
ALPHANUMERIC_ALLOWED_FLAG	Flag to indicate whether values with alphanumeric characters can be in the value set
UPPERCASE_ONLY_FLAG	Flag to indicate if all the values in the value set should all be in uppercase
NUMERIC_MODE_ENABLED_FLAG	Flag to indicate if Oracle Application Object Library should right-justify and zero-fill values for segments that use the value set
FLEX_VALUE_SET_ID	Flexfield value set identifier
DESCRIPTION	Description
DEPENDANT_DEFAULT_VALUE	The default value for the dependent value set
DEPENDANT_DEFAULT_MEANING	Descritpion of default value
PARENT_FLEX_VALUE_SET_ID	The independent value set on which the dependent value set depends
MINIMUM_VALUE	Minimum value
MAXIMUM_VALUE	Maximum value
NUMBER_PRECISION	Precision
FLEX_VALUE_SET_NAME	Value set name
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Application Object Library - FND_FORM	Application forms registered with Oracle Application Object Library
Column Name	Descritpion
APPLICATION_ID	Application identifier
LAST_UPDATE_LOGIN	Standard Who column
AUDIT_ENABLED_FLAG	Flag to indicate if this form is included in the AuditTrial audit set
FORM_ID	Form identifier
FORM_NAME	Form name
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_FLEX_WORKFLOW_PROCESSES	Workflow to generate flexfield code combinations
Column Name	Descritpion
APPLICATION_ID	Key Flexfield Application Identifier
LAST_UPDATE_LOGIN	Standard Who column
ID_FLEX_CODE	Key Flexfield Code
ID_FLEX_NUM	Key Flexfield Structure Number
WF_ITEM_TYPE	Oracle Workflow item type
WF_PROCESS_NAME	Oracle Workflow process name
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_ID_FLEXS	Registration information about key flexfields
Column Name	Descritpion
APPLICATION_ID	select application_id from fnd_tables where table_name = fnd_id_flexs.application_table_name and rownum = 1
TABLE_APPLICATION_ID	select application_id from fnd_tables where table_name = fnd_id_flexs.application_table_name and rownum = 1
APPLICATION_TABLE_NAME	Name of combination table
ALLOW_ID_VALUESETS	Flag to indicate whether to allow ID type value set
DYNAMIC_INSERTS_FEASIBLE_FLAG	Flag to indicate if dynamic insert is allowed for the flexfield
INDEX_FLAG	Flag to indicate whether to lock the code combination table in exclusive mode before performing inserts
UNIQUE_ID_COLUMN_NAME	The name of the unique ID column in the combinations table
ID_FLEX_CODE	Key flexfield code
DESCRIPTION	Description
APPLICATION_TABLE_TYPE	Falg to indicate if the combination table is generic or specific
SET_DEFINING_COLUMN_NAME	The name of the structure defining multi-flex column for the flexfield
MAXIMUM_CONCATENATION_LEN	The maximum length for the concatenated flexfield combination
CONCATENATION_LEN_WARNING	The warning message displayed when a concatenated segment length is greater than the maximum concatenation length
CONCATENATED_SEGS_VIEW_NAME	KFV view name
ID_FLEX_NAME	Key flexfield structure identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Application Object Library - FND_ID_FLEX_SEGMENTS	Key flexfield segments setup information and correspondences between table columns and key flexfield segments
Column Name	Descritpion
APPLICATION_ID	Application identifier
LAST_UPDATE_LOGIN	Standard Who column
SEGMENT_NUM	Segment number
APPLICATION_COLUMN_INDEX_FLAG	Flag to indicate if the flexfield column is indexed
RUNTIME_PROPERTY_FUNCTION	RUNTIME_PROPERTY_FUNCTION
ADDITIONAL_WHERE_CLAUSE	Additional where clause
ENABLED_FLAG	Flag to indicate if the segment is enabled
REQUIRED_FLAG	Flag to indicate if a value must be entered for this segment
DISPLAY_FLAG	Flag to indicate if the segment should be displayed
DISPLAY_SIZE	The display size of the segment
SECURITY_ENABLED_FLAG	Flag to indicate if security is enabled for the segment
MAXIMUM_DESCRIPTION_LEN	The maximum description size for the segment
ID_FLEX_CODE	Key flexfield code
CONCATENATION_DESCRIPTION_LEN	The size of the concatenated flexfield description
ID_FLEX_NUM	Key flexfield structure number
FLEX_VALUE_SET_ID	Flexfield value set identifier
RANGE_CODE	Range code can be High or Low
DEFAULT_TYPE	Type of default value
DEFAULT_VALUE	The default value for the segment
APPLICATION_COLUMN_NAME	Flexfield column name
SEGMENT_NAME	Segment name
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Application Object Library - FND_ID_FLEX_STRUCTURES	Key flexfield structure information
Column Name	Descritpion
APPLICATION_ID	select t.application_id from fnd_tables t, fnd_id_flexs f where t.table_name = f.application_table_name and f.id_flex_code = fnd_id_flex_structures.id_flex_code and rownum = 1
CONCATENATED_SEGMENT_DELIMITER	The segment delimiter used to separate segments in concatenated segments
CROSS_SEGMENT_VALIDATION_FLAG	Flag to indicate whether the flexfield should be validated by cross-validation rules
DYNAMIC_INSERTS_ALLOWED_FLAG	Flag to indicate whether users can insert new flexfield combinations dynamically
ENABLED_FLAG	Enabled flag
FREEZE_FLEX_DEFINITION_FLAG	Flag to indicate if the flexfield structure is frozen
FREEZE_STRUCTURED_HIER_FLAG	Flag to indicate if the flexfield rollup group is frozen
SHORTHAND_ENABLED_FLAG	Flag to indicate whether shorthand alias is enabled for the flexfield structure
ID_FLEX_CODE	Key flexfield code
SHORTHAND_LENGTH	The display size of the shorthand alias field in the shorthand window
STRUCTURE_VIEW_NAME	Key flexfield structure view name that a user specifies
ID_FLEX_STRUCTURE_CODE	Developer key for key flexfield structure
ID_FLEX_NUM	Key flexfield structure number
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Application Object Library - FND_LOB_ACCESS	LOB access table for the Generic File Manager
Column Name	Descritpion
ACCESS_ID	Access identifier generated by the authorize function
FILE_ID	File identifier of the LOB that is being downloaded or uploaded
TIMESTAMP	Date and time at which the access row was inserted

Application Object Library - FND_LOBS	LOBs being managed by the Generic File Manager
Column Name	Descritpion
FILE_ID	Identifier that uniquely identifies the file
ORACLE_CHARSET	Oracle character set of file
FILE_FORMAT	File format ('text' or 'binary')
FILE_NAME	User's name for the file as provided during the uploading process
FILE_CONTENT_TYPE	Content type as specified during the uploading process. This string is an unparsed entity-header for the entity "Content-Type", and specifies the content type, and any additional parameters (such as character set) that describe the stored
FILE_DATA	The uploaded data itself, which is a binary LOB
UPLOAD_DATE	Timestamp at which the LOB was uploaded
EXPIRATION_DATE	Timestamp after which the LOB may be purged from the table. When the LOB is first uploaded, this is set to be one day from the current time.
PROGRAM_NAME	Name of the program on whose behalf the LOB is being maintained.
PROGRAM_TAG	Optional string used by the GFM client program to further categorize the LOB.
LANGUAGE	Language of file

Application Object Library - FND_LOOKUP_TYPES_TL	Translations for FND_LOOKUP_TYPES
Column Name	Descritpion
LOOKUP_TYPE	QuickCode lookup type (FK to fnd_lookup_types.lookup_type)
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
SECURITY_GROUP_ID	Security group identifier
VIEW_APPLICATION_ID	Application identifier of view (_LOOKUPS) through which the lookup type will be exposed
LANGUAGE	Language
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
MEANING	Lookup type user meaning
DESCRIPTION	Description of the lookup type
CREATED_BY	Standard who column
CREATION_DATE	Standard who column

Application Object Library - FND_FLEX_TEST	- Retrofitted
Column Name	Descritpion
APPLICATION_ID	- Retrofitted
START_DATE_ACTIVE	- Retrofitted
SEGMENT17_HIGH	- Retrofitted
SEGMENT18_HIGH	- Retrofitted
SEGMENT19_HIGH	- Retrofitted
SEGMENT20_HIGH	- Retrofitted
SEGMENT21_HIGH	- Retrofitted
SEGMENT22_HIGH	- Retrofitted
SEGMENT23_HIGH	- Retrofitted
SEGMENT24_HIGH	- Retrofitted
SEGMENT25_HIGH	- Retrofitted
SEGMENT26_HIGH	- Retrofitted
END_DATE_ACTIVE	- Retrofitted
SEGMENT27_HIGH	- Retrofitted
SEGMENT28_HIGH	- Retrofitted
SEGMENT29_HIGH	- Retrofitted
SEGMENT30_HIGH	- Retrofitted
SEGMENT31_HIGH_NUMBER	- Retrofitted
SEGMENT32_HIGH_NUMBER	- Retrofitted
SEGMENT33_HIGH_NUMBER	- Retrofitted
SEGMENT34_HIGH_NUMBER	- Retrofitted
SEGMENT35_HIGH_DATE	- Retrofitted
SEGMENT36_HIGH_DATE	- Retrofitted
SEGMENT1	- Retrofitted
ATTRIBUTE_CATEGORY	- Retrofitted
ATTRIBUTE1	- Retrofitted
ATTRIBUTE2	- Retrofitted
ATTRIBUTE3	- Retrofitted
ATTRIBUTE4	- Retrofitted
ATTRIBUTE5	- Retrofitted
ATTRIBUTE6	- Retrofitted
ATTRIBUTE7	- Retrofitted
ATTRIBUTE8	- Retrofitted
ATTRIBUTE9	- Retrofitted
SEGMENT2	- Retrofitted
ATTRIBUTE10	- Retrofitted
ATTRIBUTE11	- Retrofitted
ATTRIBUTE12	- Retrofitted
ATTRIBUTE13	- Retrofitted
ATTRIBUTE14	- Retrofitted
ATTRIBUTE15	- Retrofitted
ATTRIBUTE16	- Retrofitted
ATTRIBUTE17	- Retrofitted
ATTRIBUTE18	- Retrofitted
ATTRIBUTE19	- Retrofitted
SEGMENT3	- Retrofitted
ATTRIBUTE20	- Retrofitted
ATTRIBUTE21	- Retrofitted
ATTRIBUTE22	- Retrofitted
ATTRIBUTE23	- Retrofitted
ATTRIBUTE24	- Retrofitted
ATTRIBUTE25	- Retrofitted
ATTRIBUTE26	- Retrofitted
ATTRIBUTE27	- Retrofitted
ATTRIBUTE28	- Retrofitted
ATTRIBUTE29	- Retrofitted
SEGMENT4	- Retrofitted
ATTRIBUTE30	- Retrofitted
ATTRIBUTE21_NUMBER	- Retrofitted
ATTRIBUTE22_NUMBER	- Retrofitted
ATTRIBUTE23_DATE	- Retrofitted
ATTRIBUTE24_DATE	- Retrofitted
DATA_FIELD	- Retrofitted
SEGMENT5	- Retrofitted
SEGMENT6	- Retrofitted
SEGMENT7	- Retrofitted
SEGMENT8	- Retrofitted
ID_FLEX_CODE	- Retrofitted
SEGMENT9	- Retrofitted
SEGMENT10	- Retrofitted
SEGMENT11	- Retrofitted
SEGMENT12	- Retrofitted
SEGMENT13	- Retrofitted
SEGMENT14	- Retrofitted
SEGMENT15	- Retrofitted
SEGMENT16	- Retrofitted
SEGMENT17	- Retrofitted
SEGMENT18	- Retrofitted
LAST_UPDATE_DATE	- Retrofitted
SEGMENT19	- Retrofitted
SEGMENT20	- Retrofitted
SEGMENT21	- Retrofitted
SEGMENT22	- Retrofitted
SEGMENT23	- Retrofitted
SEGMENT24	- Retrofitted
SEGMENT25	- Retrofitted
SEGMENT26	- Retrofitted
SEGMENT27	- Retrofitted
SEGMENT28	- Retrofitted
LAST_UPDATED_BY	- Retrofitted
SEGMENT29	- Retrofitted
SEGMENT30	- Retrofitted
SEGMENT31_NUMBER	- Retrofitted
SEGMENT32_NUMBER	- Retrofitted
SEGMENT33_NUMBER	- Retrofitted
SEGMENT34_NUMBER	- Retrofitted
SEGMENT35_DATE	- Retrofitted
SEGMENT36_DATE	- Retrofitted
SEGMENT1_LOW	- Retrofitted
SEGMENT2_LOW	- Retrofitted
UNIQUE_ID_COLUMN	- Retrofitted
SEGMENT3_LOW	- Retrofitted
SEGMENT4_LOW	- Retrofitted
SEGMENT5_LOW	- Retrofitted
SEGMENT6_LOW	- Retrofitted
SEGMENT7_LOW	- Retrofitted
SEGMENT8_LOW	- Retrofitted
SEGMENT9_LOW	- Retrofitted
SEGMENT10_LOW	- Retrofitted
SEGMENT11_LOW	- Retrofitted
SEGMENT12_LOW	- Retrofitted
UNIQUE_ID_COLUMN2	- Retrofitted
SEGMENT13_LOW	- Retrofitted
SEGMENT14_LOW	- Retrofitted
SEGMENT15_LOW	- Retrofitted
SEGMENT16_LOW	- Retrofitted
SEGMENT17_LOW	- Retrofitted
SEGMENT18_LOW	- Retrofitted
SEGMENT19_LOW	- Retrofitted
SEGMENT20_LOW	- Retrofitted
SEGMENT21_LOW	- Retrofitted
SEGMENT22_LOW	- Retrofitted
SET_DEFINING_COLUMN	- Retrofitted
SEGMENT23_LOW	- Retrofitted
SEGMENT24_LOW	- Retrofitted
SEGMENT25_LOW	- Retrofitted
SEGMENT26_LOW	- Retrofitted
SEGMENT27_LOW	- Retrofitted
SEGMENT28_LOW	- Retrofitted
SEGMENT29_LOW	- Retrofitted
SEGMENT30_LOW	- Retrofitted
SEGMENT31_LOW_NUMBER	- Retrofitted
SEGMENT32_LOW_NUMBER	- Retrofitted
SUMMARY_FLAG	- Retrofitted
SEGMENT33_LOW_NUMBER	- Retrofitted
SEGMENT34_LOW_NUMBER	- Retrofitted
SEGMENT35_LOW_DATE	- Retrofitted
SEGMENT36_LOW_DATE	- Retrofitted
SEGMENT1_HIGH	- Retrofitted
SEGMENT2_HIGH	- Retrofitted
SEGMENT3_HIGH	- Retrofitted
SEGMENT4_HIGH	- Retrofitted
SEGMENT5_HIGH	- Retrofitted
SEGMENT6_HIGH	- Retrofitted
ENABLED_FLAG	- Retrofitted
SEGMENT7_HIGH	- Retrofitted
SEGMENT8_HIGH	- Retrofitted
SEGMENT9_HIGH	- Retrofitted
SEGMENT10_HIGH	- Retrofitted
SEGMENT11_HIGH	- Retrofitted
SEGMENT12_HIGH	- Retrofitted
SEGMENT13_HIGH	- Retrofitted
SEGMENT14_HIGH	- Retrofitted
SEGMENT15_HIGH	- Retrofitted
SEGMENT16_HIGH	- Retrofitted

Application Object Library - FND_MIME_TYPES_TL	Mime types
Column Name	Descritpion
FILE_FORMAT_CODE	File format code for mime type
DESCRIPTION	Description
ALLOW_CLIENT_ENCODING	Allow native client encoding for this MIME type
MIME_TYPE	Mime type
LANGUAGE	Language
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Application Object Library - FND_HELP_DOCUMENTS	Information about on-line help documents
Column Name	Descritpion
FILE_ID	File identifier (FK to fnd_lobs.file_id)
LANGUAGE	Document language
APPLICATION	Application short name (FK to fnd_application.application_short_name)
FILE_NAME	Document file name
CUSTOM_LEVEL	Customization level of document{{HR}}10 - Reserved (AOL)\{{HR}}20 - Base product{{HR}}30 - Vertical{{HR}}40 - Localization{{HR}}100 - Customer
TITLE	Document title
VERSION	Document version string of form '$Header...'

Application Object Library - FND_HELP_TARGETS	On-line help targets
Column Name	Descritpion
TARGET_NAME	Name of help target
FILE_ID	File identifier (FK to fnd_help_documents.file_id)

Application Object Library - FND_HELP_TREE	On-line help system navigation tree.
Column Name	Descritpion
LANGUAGE	Node language
ICON	Icon to display in tree
DESCRIPTION	Node description
DATA	Node contents ( | @ | )
SESSION_ID	SESSION_ID
PARENT_APPLICATION	Parent node application ('FND_NULL' if very top level)
PARENT_KEY	Parent node key ('FND_NULL' if very top level)
NODE_APPLICATION	Node application
NODE_KEY	Node key
CUSTOM_LEVEL	Customization level
DISPLAY_SEQUENCE	Display sequence below parent node
TYPE	Type of tree node: ROOT (top level parent of a logical tree), NODE (navigation node), DOCUMENT (document leaf), or DELETE (overrides and removes lower level entry)
PROMPT	Prompt to display in tree

Application Object Library - FND_HISTOGRAM_COLS	Histogram candidate columns for cost-based optimization
Column Name	Descritpion
APPLICATION_ID	Application identifier of application that owns the table.
LAST_UPDATE_LOGIN	Standard Who column
OWNER	OWNER
TABLE_NAME	Name of table potentially containing skewed data
COLUMN_NAME	Name of column that is a candidate for a histogram
PARTITION	Partition name if table is a partitioned table
HSIZE	Bucket size for the histogram
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Application Object Library - FND_GRANTS	Grants are rows that indicate a user or group has permission to execute a menu (role) of functions, under a specific context
Column Name	Descritpion
GRANT_GUID	PK Grant ID
INSTANCE_PK1_VALUE	Primary Key value column 1, if INSTANCE_TYPE= 'INSTANCE', else NULL
INSTANCE_PK2_VALUE	Primary Key value column 2, if INSTANCE_TYPE= 'INSTANCE', else NULL
INSTANCE_PK3_VALUE	Primary Key value column 3, if INSTANCE_TYPE= 'INSTANCE', else NULL
OBJECT_NAME
INSTANCE_PK4_VALUE	Primary Key value column 4, if INSTANCE_TYPE= 'INSTANCE', else NULL
INSTANCE_PK5_VALUE	Primary Key value column 5, if INSTANCE_TYPE= 'INSTANCE', else NULL
PROGRAM_NAME	The program or UI that maintains this row in FND_GRANTS
PROGRAM_TAG	This field is for use of the program or UI that maintains row.
ROLE_ID
CREATED_BY	CREATED_BY
CREATION_DATE	CREATION_DATE
LAST_UPDATED_BY	LAST_UPDATED_BY
GRANTEE_TYPE	USER, GROUP, GLOBAL
LAST_UPDATE_DATE	LAST_UPDATE_DATE
PARTY_ID
LAST_UPDATE_LOGIN	LAST_UPDATE_LOGIN
GRANTEE_ORIG_SYSTEM	1st part of 2 part FK to WF_ROLES.ORIG_SYSTEM. Type of user.
GRANTEE_ORIG_SYSTEM_ID	2nd part of 2 part FK to WF_ROLES.ORIG_SYSTEM_ID. Actual user's id.
CTX_SECGRP_ID	Grant only applies when in this Security Group; -1 means grant applies when in any Security Group.
CTX_RESP_ID	Along with CTX_RESP_APPL_ID: Grant applies when in this Resp. -1 means grant applies when in any Resp.
CTX_RESP_APPL_ID	Along with CTX_RESP_ID: Grant applies when in this Resp. -1 means grant applies when in any Resp.
CTX_ORG_ID	Grant only applies when in this Organization; -1 means grant applies when in any Org.
PARAMETER1	Parameter values for grants
PARAMETER2	if INSTANCE_TYPE= 'SET'
GRANTEE_KEY	FK to WF_ROLES.NAME
PARAMETER3	(else NULL)
PARAMETER4	Optional Parameter value 4 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER5	Optional Parameter value 5 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER6	Optional Parameter value 6 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER7	Optional Parameter value 7 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER8	Optional Parameter value 8 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER9	Optional Parameter value 9 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER10	Optional Parameter value 10 for grants, if INSTANCE_TYPE= 'SET', else NULL
NAME	name of grant for admins to pick
DESCRIPTION	description of what grant does
MENU_ID	FK: FND_MENUS. Which menu of functions is granted.
GRANT_ID
START_DATE	Start Date of Grant
END_DATE	End Date of Grant
OBJECT_KEY_TYPE
OBJECT_ID	Object ID granted
INSTANCE_TYPE	GLOBAL,INSTANCE or SET
OBJECT_KEY
INSTANCE_SET_ID	K to instance set if SET (else NULL)

Application Object Library - FND_LOBS_DOCUMENT	These tables mirror the standard WebDB doc tables but use our own name.
Column Name	Descritpion
NAME	the document file name
MIME_TYPE	the mime type (ie: text/html)
DOC_SIZE	document length
DAD_CHARSET	DAD charset
LAST_UPDATED	timestamp
CONTENT_TYPE	interMedia (TEXT or BINARY)
CONTENT	(not used)
BLOB_CONTENT	the document itself

Application Object Library - FND_LOBS_DOCUMENTPART	These tables mirror the standard WebDB doc tables but use our own name.
Column Name	Descritpion
DOCUMENT	file name (maps to name)
PART	embedded document section
UPLOADED	uploaded flag

Application Object Library - FND_LOG_MESSAGES	Stores debug log messages generated from the FND_LOG package.
Column Name	Descritpion
LOG_LEVEL	Severity of Log message (1-Lowest, 6-Highest)
ERRORSTACK	ERRORSTACK
ATTRIBUTE3_NAME
ATTRIBUTE3_VALUE
ATTRIBUTE4_NAME
ATTRIBUTE4_VALUE
ATTRIBUTE5_NAME
ATTRIBUTE5_VALUE
ATTRIBUTE6_NAME
ATTRIBUTE6_VALUE
ATTRIBUTE7_NAME
MESSAGE_TEXT	Message
ATTRIBUTE7_VALUE
ATTRIBUTE8_NAME
ATTRIBUTE8_VALUE
ATTRIBUTE9_NAME
ATTRIBUTE9_VALUE
ATTRIBUTE10_NAME
ATTRIBUTE10_VALUE
SESSION_ID	FK to ICX_SESSIONS
ATTRIBUTE2_NAME
USER_ID	FK to FND_USER
TIMESTAMP	Time message was logged
LOG_SEQUENCE	Primary Key
ENCODED	'Y' / 'N' - Y indicates that the MESSAGE_TEXT column actually stores an encoded message from Message Dictionary.
ATTRIBUTE1_NAME	Name of user defined attribute.
NODE	The name of the node for the current transaction
MODULE	Source-Code Block Identifier
NODE_IP_ADDRESS	The IP of the Node for the current transactions
PROCESS_ID	The OS process Id for the current transaction
JVM_ID	The unique Id for the current JVM process of the current transaction
ATTRIBUTE1_VALUE	Value of user defined
THREAD_ID	The Java thread id of the current transaction
AUDSID	This records the database AUDSID, since a single database session may be shared by multiple ICX_SESSIONS.
DB_INSTANCE	This records the database instance number. This may be useful when looking for patterns of problems in OPS instances.
TRANSACTION_CONTEXT_ID	Foreign key into fnd_log_transaction_context. Points to details of the transaction that logged this message.
ATTRIBUTE2_VALUE
ECID_ID	ECID_ID
ECID_SEQ	ECID_SEQ
CALLSTACK	CALLSTACK

Application Object Library - FND_FLEX_VALUE_HIER_ALL	All value hierarchy ranges for key flexfield segment
Column Name	Descritpion
FLEX_VALUE_SET_ID	Flexfield value set identifier
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
START_DATE_ACTIVE	The date the value hierarchy becomes active
END_DATE_ACTIVE	The date the value hierarchy expires
PARENT_FLEX_VALUE	The parent value to which the range belongs
RANGE_ATTRIBUTE	Flag to distinguish a child value from a parent value.
CHILD_FLEX_VALUE_LOW	The low value of the range of child values
CHILD_FLEX_VALUE_HIGH	he high value of the range of child values
HIERARCHY_LEVEL	The hierarchy tree depth from parent value to the value range.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Application Object Library - FND_LOG_EXCEPTIONS	store the extended exception information that is needed for efficient queries
Column Name	Descritpion
LOG_SEQUENCE	Primary key. Also foreign key back into fnd_log_messages
SESSION_MODULE	v$session.module
SESSION_ACTION	v$session.action
ACKNOWLEDGED	Y/N - OAM will allow the DBA to acknowledge an exception, to allow it to be filtered out of queries
CATEGORY	'SYSTEM', 'PRODUCT', or null - Only used if TRANSLATED='Y' and LOG_LEVEL=6 (Unexpected).
SEVERITY	'CRITICAL', 'ERROR','WARNING', or null - Only used if TRANSLATED='Y' and LOG_LEVEL=6 (Unexpected)
MESSAGE_TEXT	Message text translated into the session language
UNIQUE_EXCEPTION_ID	Foreign key into FND_LOG_UNIQUE_EXCEPTION. Associates a logged exception with its unique exception
TRANSACTION_CONTEXT_ID	TRANSACTION_CONTEXT_ID

Application Object Library - FND_LOG_METRICS	This new table will store logged metrics
Column Name	Descritpion
MODULE	Name of module that logged the metric
METRIC_CODE	Internal name of the metric
TYPE	String, Number, Date
STRING_VALUE	Value if metric is a string
NUMBER_VALUE	Value if metric is a number
DATE_VALUE	Value if metric is a date
AUDSID	AUDSID of DB session that reported the metric
DB_INSTANCE	Number of the database instance through which the metric was reported
METRIC_SEQUENCE	Primary key
TIME	Time that the metric was recorded
EVENT_KEY	Null until metric has been posted in a Business Event
TRANSACTION_CONTEXT_ID	Foreign key into fnd_log_transaction_context. Points to details of the transaction that logged this message
SESSION_MODULE	v$session.module
SESSION_ACTION	v$session.action
NODE	Host name
NODE_IP_ADDRESS	Host IP address
PROCESS_ID	OS Process ID
JVM_ID	Internal Identifier for JVM process (OS process ID is unavailable in Java)
THREAD_ID	Thread ID

Application Object Library - FND_LOG_TRANSACTION_CONTEXT	This table stores the context information for a transaction
Column Name	Descritpion
SESSION_ID	ICX session ID of the session
TRANSACTION_TYPE	Identifies the type of transaction. Combined with the transaction_id, this is necessary for drilling down to other tables for information on the transaction.
TRANSACTION_ID	For requests, the request_id. For services, the concurrent_process_id. Not applicable for Forms
USER_ID	Current user
RESP_APPL_ID	Application ID of current user responsibility
RESPONSIBILITY_ID	ID of current user responsibility
SECURITY_GROUP_ID	Current Security Group ID of user
COMPONENT_TYPE	Type of application component that posted the exception
TRANSACTION_CONTEXT_ID	Unique identifier, primary key
COMPONENT_APPL_ID	Application ID of component that posted the exception
COMPONENT_ID	ID of component that posted the exception
CREATION_DATE	Date when row was created
PARENT_CONTEXT_ID	Transaction context ID for the parent context that is raising a proxy alert.

Application Object Library - FND_METRIC_DEF_TL	This table contains the definition of a metric for the benefit of the UI
Column Name	Descritpion
NAME	Display name for the Metric
DESCRIPTION	Optional description
TYPE	'S'=String, 'N'=Number, 'D'=Date
LANGUAGE_CODE	LANGUAGE_CODE
METRIC_CODE	Internal name of the metric

Application Object Library - FND_OAM_FORMS_RTI	Forms Listener runtime process info.
Column Name	Descritpion
CONCURRENT_QUEUE_ID	CQID of GSM Forms Listener Instance.
QUEUE_APPLICATION_ID	Application id.
PID	Runtime process ID.
THREADID	Runtime process's thread IS, NT only.
IPADDRESS	Client IP.
NODE	Middle tier node name where the runtime process is running.
PORT	Port number where the Forms Listener is running.
USERNAME	Connected APPS username from rti file.
RTI_ID	Sequence num used to identify a logfile for a specific runtime instance.
CONNECT_TIME	Timestamp when runtime process started.
MEM_USAGE	memory usage in kilobytes obtained from OS or ifctl60 (NT)
CPU_USAGE	CPU usage time in hh:mm:ss obtained from OS or ifctl60 (NT)
FILENAME	Full path to the rti files, needed for purging.
LAST_UPDATE_TIME	Needed for purging.

Application Object Library - FND_OAM_CONTEXT_FILES	FND_OAM_CONTEXT_FILES stores all context files and metadata file belongs to the application instance. Each Row contains context name, actual context file, and version of file. There will be one metadata file for the entire Applications inst
Column Name	Descritpion
VERSION	File version parsed from file
PATH	Full file path
LAST_SYNCHRONIZED	Last upload or download time
BASECOPY	which will store the reference copy of the context file
TEXT	File contents
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
CREATION_DATE	Standard who column
BASECOPY_DATE	date the basecopy of context file was made
CREATED_BY	Standard who column
NAME	Context Name parsed from context file
LAST_UPDATE_LOGIN	Standard who column
NODE_NAME	Node name where context file is located
STATUS	status of writing back file to file system
SERIAL_NUMBER	serial number used for comparing file system contents with db contents
EDIT_COMMENTS	user specified comments
CTX_TYPE	used to specify context file for Database/Apps

Application Object Library - FND_OAM_METVAL	FROM FND_CONCURRENT_PROGRAMS_VL
Column Name	Descritpion
METRIC_VALUE	Value of the metric
INTERVAL_COUNTER	Keeps count of the number of times the collection program has run
STATUS_CODE	If applicable, status of the metric.
GROUP_ID	Foreign key to fnd_oam_met_grps_vl
SEQUENCE	The order in which the metric will be displayed within its group
NODE_NAME	Host name associated with the metric if applicable
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
METRIC_SHORT_NAME	Internal name for metric
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
METRIC_TYPE	I - Integer or S - Status (i.e. Up or Down)
THRESHOLD_OPERATOR	Value for operator for comparison with threshold value
THRESHOLD_VALUE	Value specified by the user for threshold
ALERT_ENABLED_FLAG	Whether or not alerting is enabled for this metric
COLLECTION_ENABLED_FLAG	Whether or not metric values should be computed for this metric
LAST_COLLECTED_DATE	The date on which the metric value was last collected
IS_SUPPORTED	Indicates whether this metric is supported by OAM or not
IS_CUSTOMIZED	Indicates whether this metric has been modified by the user. This is a flag for the seed data loader so that we do not overwrite user updated values. Default values is N

Application Object Library - FND_OAM_METS_TL	OAM Dashboard Metrics Translated Table
Column Name	Descritpion
METRIC_SHORT_NAME	Internal name for metric
SOURCE_LANG	source language
LANGUAGE	Language
METRIC_DISPLAY_NAME	Display name for the metric
DESCRIPTION	Short description of the metric
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Application Object Library - FND_OAM_APP_SYS_STATUS	OAM Applications System Status Information
Column Name	Descritpion
METRIC_SHORT_NAME	Internal name of metric. Also primary key
LAST_UPDATE_LOGIN	Last Update Login
APPLICATION_ID	Application ID if metric falls into Generic Service Definition
CONCURRENT_QUEUE_NAME	Concurrent Queue Short Name if metric falls into Generic Service Definition
NAME	To accomodate any other value that maybe required during display on OAM UI
TYPE	Will store the application server to which the metric pertains to
STATUS_CODE	Status of metric. 0 - Normal, 1 - Warning, 2 - Error, 3 - Unknown
NODE_NAME	Associated Host Name
LAST_UPDATED_BY	Last Updated By
LAST_UPDATE_DATE	Date the metric was last computed

Application Object Library - FND_OAM_FRD_LOG	Forms Listener runtime process FRD log info.
Column Name	Descritpion
FILENAME	Absolute path of the log file on the node.
FRD_LOG	Flag for FRD logging status Y/N.
RTI_ID	Sequence num used to identify a logfile for a specific runtime instance.

Application Object Library - FND_LOV_CHOICE_VALUES	Stores values for LOV Choice List
Column Name	Descritpion
USER_ID	Identifies the user who chose the value. This value makes sense only when VALUE_SOURCE is USER or SEEDCOPY
FULL_REF_NAME	Identifies the item for which the value is saved
VALUE_DISPLAY_SEQUENCE	Display sequence of the value
VALUE_CODE	Code saved for the user, for the item
CREATED_BY	standard who column
CREATION_DATE	standard who column
LAST_UPDATED_BY	standard who column
LAST_UPDATE_DATE	standard who column
VALUE_SOURCE	Identifies where the value came from. USER, SEED, SEEDCOPY
LAST_UPDATE_LOGIN	standard who column

Application Object Library - FND_MO_PRODUCT_INIT	This table stores the application short name of the applications that have Multi-Org Access Control enabled
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
STATUS	Access Enabled Status
APPLICATION_SHORT_NAME	Application short name

Application Object Library - FND_LOG_UNIQUE_EXCEPTIONS	Used to track unique exceptions
Column Name	Descritpion
UNIQUE_EXCEPTION_ID	Primary key, generated from theFND_LOG_UNIQUE_EXCEPTIONS_S sequence
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ENCODED_MESSAGE	Encoded message dictionary message
ENGLISH_MESSAGE	English translation from message dictionary
STATUS	"N" New "O" Open "C" Closed
COUNT	Count of child exceptions that were logged under this unique exception
SEVERITY	Severity of Exception 'CRITICAL', ERROR', 'WARNING'
CATEGORY	Category of Exception 'SYSTEM', 'PRODUCT'
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column

Application Object Library - FND_KBF_SUBSCRIPTION	OAM Notification Setup Table for Exceptions
Column Name	Descritpion
APPLICATION_ID	Application. Foreign Key in fnd_application.application_id
COMPONENT_ID	Component of Application
COMPONENT_TYPE	Type of component
BIZ_FLOW_ID	Business flow
SEVERITY	Severity of Exception 'CRITICAL', ERROR', 'WARNING'
CATEGORY	Category of Exception 'SYSTEM', 'PRODUCT'
REMARK	remark
CREATED_BY	Standard Who Column
ROLE_ID	User who wants to be notified. Foreign Key WF_ROLES.NAME
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Application Object Library - FND_OAM_BIZEX_SENT_NOTIF	Used to track sent notifications
Column Name	Descritpion
UNIQUE_EXCEPTION_ID	unique exception that triggered the notification. Foreign key FND_LOG_UNIQUE_EXCEPTIONS
SUBSCRIPTION_ID	subscription for the notification. Foreign Key into FND_OAM_BIZEX_SUBSCRIP
SENT	time of notification

Application Object Library - FND_OAM_BIZEX_SUBSCRIP	OAM Notification Setup Table for Exceptions
Column Name	Descritpion
APPLICATION_ID	Application. Foreign Key in fnd_application.application_id
COMPONENT_ID	Component of Application
COMPONENT_TYPE	Type of component
BIZ_FLOW_ID	Business flow
SEVERITY	Severity of Exception 'CRITICAL', ERROR', 'WARNING'
CATEGORY	Category of Exception 'SYSTEM', 'PRODUCT'
REMARK	remark
CREATED_BY	Standard Who Column
ROLE_ID	User who wants to be notified. Foreign Key WF_ROLES.NAME
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
SUBSCRIPTION_ID	Subscription for the notification. Primary key, generated from the sequence FND_OAM_BIZEX_SUBSCRIP_S

Application Object Library - FND_IMP_AFFECTEDFILES	FND_IMP_AFFECTEDFILES
Column Name	Descritpion
BUG_NO	BUG_NO
ACTION_REQUIRED	ACTION_REQUIRED
OBJECTS_AFFECTED	OBJECTS_AFFECTED
OBJECT_TYPE	OBJECT_TYPE
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination
SNAPSHOT_ID	SNAPSHOT_ID
DEP_APP_SHORT_NAME	DEP_APP_SHORT_NAME
DEP_DIRECTORY	DEP_DIRECTORY
DEP_FILENAME	DEP_FILENAME
PATCHED_APP_SHORT_NAME	PATCHED_APP_SHORT_NAME
PATCHED_DIRECTORY	PATCHED_DIRECTORY
PATCHED_FILENAME	PATCHED_FILENAME
TYPEID	TYPEID

Application Object Library - FND_IMP_PFILEINFO2	FND_IMP_PFILEINFO2
Column Name	Descritpion
BUG_NO	BUG_NO
APP_SHORT_NAME	APP_SHORT_NAME
DIRECTORY	DIRECTORY
FILENAME	FILENAME
VERSION	VERSION
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination

Application Object Library - FND_IMP_PSCOMMON	FND_IMP_PSCOMMON
Column Name	Descritpion
BUG_NO	BUG_NO
SNAPSHOT_ID	SNAPSHOT_ID
APP_SHORT_NAME	APP_SHORT_NAME
DIRECTORY	DIRECTORY
FILENAME	FILENAME
NEW_VERSION	NEW_VERSION
OLD_VERSION	OLD_VERSION
IS_FLAGGED_FILE	Indicates if file is flagged
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination

Application Object Library - FND_IMP_PSNEW	FND_IMP_PSNEW
Column Name	Descritpion
BUG_NO	BUG_NO
SNAPSHOT_ID	SNAPSHOT_ID
APP_SHORT_NAME	APP_SHORT_NAME
DIRECTORY	DIRECTORY
FILENAME	FILENAME
NEW_VERSION	NEW_VERSION
IS_FLAGGED_FILE	Indicates if file is flagged
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination

Application Object Library - FND_IMP_SFILEDEP	FND_IMP_SFILEDEP
Column Name	Descritpion
SNAPSHOT_ID	SNAPSHOT_ID
APP_SHORT_NAME	APP_SHORT_NAME
DIRECTORY	DIRECTORY
FILENAME	FILENAME
DEP_APP_SHORT_NAME	DEP_APP_SHORT_NAME
DEP_DIRECTORY	DEP_DIRECTORY
DEP_FILENAME	DEP_FILENAME

Application Object Library - FND_IMP_PSMASTER2	FND_IMP_PSMASTER2
Column Name	Descritpion
BUG_NO	BUG_NO
FILE_TYPE	FILE_TYPE
TRANS_NAME	TRANS_NAME
IS_FLAGGED_FILE	Indicates if file is flagged
BRANCH_TYPE	BRANCH_TYPE
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination
SNAPSHOT_ID	SNAPSHOT_ID
APP_SHORT_NAME	APP_SHORT_NAME
DIRECTORY	DIRECTORY
FILENAME	FILENAME
TYPEID	TYPEID
NEW_VERSION	NEW_VERSION
OLD_VERSION	OLD_VERSION
FILES_AFFECTED	FILES_AFFECTED
TYPE_AFFECTED	TYPE_AFFECTED

Application Object Library - FND_IMP_PISUMMARY	FND_IMP_PISUMMARY
Column Name	Descritpion
BUG_NO	BUG_NO
APP_CNT	APP_CNT
RESP_CNT	RESP_CNT
PATH_CNT	PATH_CNT
IS_FLAGGED_FILE	Indicates if file is flagged
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination
SNAPSHOT_ID	SNAPSHOT_ID
NEW	NEW
UPGRADE	UPGRADE
OVERWRITE	OVERWRITE
NOT_APPLIED	NOT_APPLIED
INSTALL_CNT	INSTALL_CNT
FILES_CNT	FILES_CNT
AFFECTED	AFFECTED

Application Object Library - FND_IMP_PFILEINFO	FND_IMP_PFILEINFO
Column Name	Descritpion
BUG_NO	BUG_NO
FILEID	FILEID
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination

Application Object Library - FND_FORM_CUSTOM_ACTIONS	Holds the Actions for a specified Rule - used by FNDCUSTM.fmb and APPCORE to apply customizations.
Column Name	Descritpion
SEQUENCE	The sequence the action will be applied
ACTION_TYPE	Message, Builtin, Property or Special
ENABLED	Indicates if the action is enabled
OBJECT_TYPE	The Type of the Object
FOLDER_PROMPT_BLOCK	If a Folder, the prompt block for the Folder
MESSAGE_TYPE	The Type of the Message
MESSAGE_TEXT	The Text of the Message
SUMMARY	A Summary of the Action
BUILTIN_TYPE	The Type of the Builtin
BUILTIN_ARGUMENTS	The Arguments of the Builtin
LANGUAGE	The Language for the Action
PROPERTY_VALUE	The new Value for the property PROPERTY_NAME
RULE_ID	The FK to the FND_FORM_CUSTOM_RULES table
PROPERTY_NAME	The Internal ID of the property to change
MENU_ENTRY	The Special Menu Entry to modify
MENU_LABEL	The New Label for the Menu Entry
MENU_SEPERATOR	Indicates if a seperator is shown after the menu entry
MENU_ENABLED_IN	The Block(s) the menu is enabled in
MENU_ACTION	The Action Type for the menu entry
MENU_ARGUMENT_LONG	Long Arguments for the menu. Valid for URL and Function
MENU_ARGUMENT_SHORT	Short Arguments for the menu. Valid for Function
ACTION_ID	A Generated sequence
ARGUMENT_TYPE	The Argument Type of the Property PROPERTY_NAME
REQUEST_APPLICATION_ID	The Application ID for Mernu Action of Concurrent Request
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
TARGET_OBJECT	The Object in the form to apply the property

Application Object Library - FND_FORM_CUSTOM_PROP_LIST	Lookup table for the Properties which can be altered
Column Name	Descritpion
FIELD_TYPE	The Type for which the property applies
SPEL_NAME
SET_ALLOWED
PROPERTY_NAME	The Name of the Property
ARGUMENT_TYPE	The Argument Type for the property
PROPERTY_ID	The Internal ID for the property
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN

Application Object Library - FND_FORM_CUSTOM_PROP_VALUES	The Values available for items with argument type of L - Lookup
Column Name	Descritpion
PROPERTY_NAME	The Name of the Property
PROPERTY_VALUE	The values allowed by the property
PROPERTY_ID	The Internal ID for the value
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN

Application Object Library - FND_FORM_CUSTOM_PARAMS	Parameters to Pass to a CP when executed using Form Customizations
Column Name	Descritpion
ACTION_ID	FK to the FND_FORM_CUSTOM_ACTIONS table
CREATION_DATE
LAST_UPDATE_LOGIN
NAME	The CP Parameter Name
VALUE	The CP Parameter override default value
SEQUENCE	The CP Parameter Sequence
DEFAULT_TYPE	The Type of the CP Parameter Value
INHERIT	Indicates if this parameter should be overridden
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY

Application Object Library - FND_FORM_CUSTOM_RULES	The Rules for the form customizations. A rule must have 1 more more FND_FORM_CUSTOM_SCOPES and a rule may have 1 or more FND_FORM_CUSTOM_ACTIONS
Column Name	Descritpion
ID	A Generated Id for the table
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ENABLED	Indicates if the Rule is enabled
FIRE_IN_ENTER_QUERY	Inidicates if the Rule fires in Enter-Query mode
RULE_KEY
FORM_NAME
RULE_TYPE
FUNCTION_NAME	The Function Name to apply the rule
DESCRIPTION	A Summary of the Rule
TRIGGER_EVENT	The Event to trigger the rule
TRIGGER_OBJECT	The Object on which the TRIGGER_EVENT fires
CONDITION	A Condition toapply the rule
SEQUENCE	The Sequence in which the rule is applied
CREATED_BY
CREATION_DATE

Application Object Library - FND_FORM_CUSTOM_SCOPES	The Scopes for which the FND_FORM_CUSTOM_RULES apply
Column Name	Descritpion
RULE_ID	The FK to FND_FORM_CUSTOM_RULES
LEVEL_ID	The Level ID. 10 - Industry, 20 - Site, 30 - Responsibility, 40 - User
LEVEL_VALUE	The Industry ID, User ID or Responsibility ID
LEVEL_VALUE_APPLICATION_ID	The Responsibility Application ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN

Application Object Library - FND_INDUSTRIES	The table holds the listing of standard industries that may be translated.
Column Name	Descritpion
INDUSTRY_ID
LAST_UPDATE_LOGIN
INDUSTRY_NAME
DESCRIPTION
LANGUAGE
SOURCE_LANG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE

Application Object Library - FND_OAM_DOC_CATEGORY_TYPE	Document Category Types
Column Name	Descritpion
CATEGORY_TYPE
LAST_UPDATE_LOGIN
CATEGORY_TYPE_NAME
CATALOG_DOC_ID
CATALOG_ATTCH_ID
LAST_REFRESHED_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY

Application Object Library - FND_LOOKUP_ASSIGNMENTS	Used for categorization purposes, intersection table between fnd_lookup_values and any product team table.
Column Name	Descritpion
INSTANCE_PK4_VALUE	Value of fourth Primary Key Column
INSTANCE_PK5_VALUE	Value of fifth Primary Key Column
DISPLAY_SEQUENCE
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
LOOKUP_ASSIGNMENT_ID	Primary key generated from FND_LOOKUP_ASSIGNMENTS_S
LOOKUP_TYPE	Lookup Type
LOOKUP_CODE	Lookup Value Code
OBJ_NAME	Object Id
INSTANCE_PK1_VALUE	Value of first Primary Key Column
INSTANCE_PK2_VALUE	Value of second Primary Key Column
INSTANCE_PK3_VALUE	Value of third Primary Key Column

Application Object Library - FND_MIME_TYPES
Column Name	Descritpion
MIME_TYPE_ID
FILE_EXT
ALLOW_FILE_UPLOAD
MIME_TYPE
CP_FORMAT_CODE
CTX_FORMAT_CODE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN

Application Object Library - FND_IREP_FUNCTION_FLAVORS	Overload flavors for functions
Column Name	Descritpion
FUNCTION_ID	Pointer to parent form function
OVERLOAD_SEQ	Overload Sequence
COMPATABILITY_FLAG	Compatability
SCOPE_TYPE	scope
LIFECYCLE_MODE	Life Cycle
DESCRIPTION	Description

Application Object Library - FND_LOOKUP_PARENT_ASSIGNS	Parent Hierarchy for lookups
Column Name	Descritpion
LOOKUP_CODE	Child Type
PARENT_LOOKUP_TYPE	Parent Type
PARENT_LOOKUP_CODE	Parent Code
LOOKUP_TYPE	Child Type

Application Object Library - FND_ISO_LANGUAGES	Language table based on ISO-649
Column Name	Descritpion
ISO_LANGUAGE_2	ISO-639-1 alpha-2 language codes
PRIVATE_USE_FLAG	Flag to indicate if the language is non ISO-639-2 (Y or N)
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ISO_LANGUAGE_3	Language code based on ISO-639-2 alpha-3 codes (Terminology) and customer-defined-language

Application Object Library - FND_ISO_LANGUAGES_TL	Translations for FND_ISO_LANGUAGES
Column Name	Descritpion
LANGUAGE	FND_LANGUAGES.LANGUGE_CODE
NAME	Language name for display purpose
DESCRIPTION	Language description, based on ISO-639-2 language name
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ISO_LANGUAGE_3	Language code based on ISO-639-2 alpha-3 codes (Terminology)
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well

Application Object Library - FND_NATURAL_LANGUAGES	Language table storing natural language
Column Name	Descritpion
ISO_LANGUAGE_3	alpha-3 language codes based on ISO-639-2
ISO_TERRITORY	alpha-2 territory codes based on ISO-3166-1
ENABLED_FLAG	Flag to indicate if the language is enabled
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LANGUAGE_CODE	Language code based on RFC3066

Application Object Library - FND_NATURAL_LANGUAGES_TL	Translations for FND_NATURAL_LANGUAGES
Column Name	Descritpion
LANGUAGE	FND_LANGUAGES.LANGUGE_CODE
NAME	Language name for display purpose
DESCRIPTION	Language description
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LANGUAGE_CODE	Language code
SOURCE_LANG	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well

Application Object Library - FND_LOG_ATTACHMENTS	Stores large FND log message attachments
Column Name	Descritpion
LOG_SEQUENCE	FK to FND_LOG_MESSAGES
MESSAGE_TEXT	Message Attachment
CHARSET	Character Set of the Attachment
MIMETYPE	Mime Type of the Attachment
FILE_EXTN	File type
DESCRIPTION	Description of the Attachment Content
CONTENT	The Attachment content
ENCODING	Encoding of the Attachment
LANGUAGE	Language of the Attachment

Application Object Library - FND_OAM_BF_CUST_TL	This table stores the display names and descriptions per language for user defined business flows
Column Name	Descritpion
BIZ_FLOW_KEY	Unique identifier for a particular key business flow
SOURCE_LANG	Language code of the source language
LANGUAGE	Language code
FLOW_DISPLAY_NAME	Display name of the flow
DESCRIPTION	Description of the flow
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Application Object Library - FND_OAM_BF_CUST	This table will contain the business flow definitions for user defined business flows
Column Name	Descritpion
BIZ_FLOW_KEY	Unique identifier for a particular key business flow
MONITORED_FLAG	Flag to indicate whether or not this flow is being monitored. Possibles values are 'Y' or 'N'
IS_TOP_LEVEL	Indicates whether the flow is a top level or a root flow. Possible values are 'Y' or 'N'
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Application Object Library - FND_OAM_BF_COMP_INFO	This table stores the health indicator information at the individual component level for components associated with business flows
Column Name	Descritpion
COMPONENT_TYPE	Type of component. For example: CONCURRENT_PROGRAM, FORM, FUNCTION, or SERVICE_INSTANCE
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
COUNT_RUNNING_REQUESTS	Count of running concurrent requests.Applicable if component_type is CONCURRENT_PROGRAM.
COUNT_FORM_SESSIONS	Count of active form sessions.Applicable if component_type is FORM.
COUNT_SSF_SESSIONS	Count of self-service fwk sessions.Applicable if component_type is FUNCTION
COMPONENT_APPL_ID	Application ID for the component
COMPONENT_ID	ID for the component
COUNT_ALERTS	Count of new or open system alerts for this component
COUNT_ERRORED_REQUESTS	Count of errored concurrent requests within the last 24 hours for this component. Applicable only for components that are concurrent programs
SETUP_STATUS	Setup status for this component
TEST_STATUS	Test status for this component
DIAGNOSTIC_TEST_STATUS	Diagnostic test status for this component
CREATED_BY	Standard Who Column

Application Object Library - FND_OAM_BF_COMP_CUST	This table stores the association between business flows and individual components for user defined flows
Column Name	Descritpion
COMPONENT_TYPE	Type of component. For example: CONCURRENT_PROGRAM, FORM, FUNCTION, or SERVICE_INSTANCE
LAST_UPDATE_LOGIN	Standard Who Column
DISPLAY_ORDER	ORDER IN WHICH THE CHILD COMPONENT SHOULD APPEAR UNDER THE PARENT FLOW
COMPONENT_APPL_ID	Application ID for the component
COMPONENT_ID	ID for the component
BIZ_FLOW_KEY	Key for the flow to which the component is associated
MONITORED_FLAG	Indicates whether the component is to be monitored for this parent flow. Possible values are 'Y' or 'N'
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column

Application Object Library - FND_OAM_BF_COMP	This table stores the association between business flows and individual components for predefined flows
Column Name	Descritpion
COMPONENT_TYPE	Type of component. For example: CONCURRENT_PROGRAM, FORM, FUNCTION, or SERVICE_INSTANCE
LAST_UPDATE_LOGIN	Standard Who Column
DISPLAY_ORDER	ORDER IN WHICH THE CHILD WORK ITEM TYPE SHOULD APPEAR UNDER THE PARENT FLOW
COMPONENT_APPL_ID	Application ID for the component
COMPONENT_ID	ID for the component
BIZ_FLOW_KEY	Key for the flow to which the component is associated
MONITORED_FLAG	Indicates whether the component is to be monitored for this parent flow. Possible values are 'Y' or 'N'
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column

Application Object Library - FND_OAM_BF_ASSOC_CUST	This table stores the association between parent and child business flows for user defined flows
Column Name	Descritpion
BIZ_FLOW_PARENT_KEY	Key for the parent flow
BIZ_FLOW_CHILD_KEY	Key for the child flow
MONITORED_FLAG	Indicates whether the child flow is to be monitored for this parent flow. Possible values are 'Y' or 'N'
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
DISPLAY_ORDER	ORDER IN WHICH THE CHILD WORK ITEM TYPE SHOULD APPEAR UNDER THE PARENT FLOW

Application Object Library - FND_OAM_BF_ASSOC	This table stores the association between parent and child business flows for predefined flows.
Column Name	Descritpion
BIZ_FLOW_PARENT_KEY	Key for the parent flow
BIZ_FLOW_CHILD_KEY	Key for the child flow
MONITORED_FLAG	Indicates whether the child flow is to be monitored for this parent flow. Possible values are 'Y' or 'N'
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
DISPLAY_ORDER	ORDER IN WHICH THE CHILD WORK ITEM TYPE SHOULD APPEAR UNDER THE PARENT FLOW

Application Object Library - FND_OAM_BF	This table will contain the business flow definitions for predefined business flows
Column Name	Descritpion
BIZ_FLOW_KEY	Unique identifier for a particular key business flow
MONITORED_FLAG	Flag to indicate whether or not this flow is being monitored. Possibles values are 'Y' or 'N'
IS_TOP_LEVEL	Indicates whether the flow is a top level or a root flow. Possible values are 'Y' or 'N'
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Application Object Library - FND_OAM_METALINK_CRED	This table will store Applications user's metalink credentials
Column Name	Descritpion
USER_ID	Applications user ID
METALINK_USER_ID	Metalink user ID
METALINK_PASSWORD	Encrypted metalink password
EMAIL_ADDRESS	Email address to be used for querying metalink
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Application Object Library - FND_OAM_CSA_COLLECTIONS	Table is for storing XML data files generated by Client System Analyzer tool
Column Name	Descritpion
COLLECTION_TIME	Stores collection time (Primary Key)
DATA_FILE	Stores xml data file
LAST_UPDATE_DATE	Stores last updated timestamp
LAST_UPDATED_BY	Stores last updated by user id
CREATION_DATE	Stores creation date of this row
CREATED_BY	Stores created by user id
LAST_UPDATE_LOGIN	Stores last updated by user id
USER_NAME	Stores username (Primary Key)

Application Object Library - FND_OAM_GCS_JOBS	Job details will be saved in this table.
Column Name	Descritpion
NODE_NAME	Node Name
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OPTIONS	Adding new column 'options'
PERL_SCRIPT_NAME	perl script name
GROUP_ID	GroupId which is a sequence generated.
USER_COMMENT	Description for this job
START_TIME	Time at which job started
END_TIME	Time at which job started
PARAMETERS	xml string contains parameters for the requests
PHASE	Phase of the job
JOB_ID	Perl Script job ID
STATUS	status of the job
LOG_FILE	log file name with full path
OUT_FILE	output file name with full path
REQUESTED_BY	Transaction requester user_id
LOGIN_ID	Login_id
RESPONSIBILITY_ID	Responsibility Id
RESP_APPLICATION_ID	Responsibility Application Id
SECURITY_GROUP_ID	Security Group Id
NLS_LANGUAGE	NLS language value
NLS_TERRITORY	NLS territory value

Application Object Library - FND_OAM_ADV_CFG_VALIDATIONS	Stores Context editor Advanced Configuration validation status
Column Name	Descritpion
VALIDATION_ID	Unique ID generated by wizard for every run
NODE_NAME	node name where request is submitted
STATUS	P(ending), F(ailure), W(arning), S(uccess)
LOG_LOCATION	full path to the log file
OUTPUT	output is the XML output string
CONFIG_DATE	config_date

Application Object Library - FND_OAM_CONTEXT_CUSTOM	To store custom context variables
Column Name	Descritpion
OA_VAR	oa_var name
CTX_TYPE	configuration tier, 'A' - appstier, 'D' - DB tier
OA_TYPE	oa_type attribute, such 'PORT','PROD_TOP'
NAME	xml node name in xml file
DEFAULT_VALUE	default value definition for oa_var
TITLE	title for oa_var
DESCRIPTION	description for oa_var

Application Object Library - FND_OAM_CLONE_LOGS	To information pertaining to cloning logs
Column Name	Descritpion
JOB_KEY	Key for the clone job
TASK_ID	Id for the cloning task
TYPE	To distinguish whether the log file is from db tier or apps tier
NODE_NAME	Name of the node
FILE_NAME	Name of the log file
CONTENTS	Contents of the log file
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LOG_ID	Unique id for the clone log
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Application Object Library - FND_OAM_METALINK_DOC_ASSOC	ssociation information between documents and categories
Column Name	Descritpion
CATEGORY_KEY	key for the category
CATEGORY_TYPE	type of category
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ANCHOR	New column to store anchors
DOC_ID	Id for the document

Application Object Library - FND_OAM_METALINK_DOCS	Stores information about Metalink documents
Column Name	Descritpion
TITLE	Title of the document
DOC_LAST_UPDATE_DATE	Date on which the document was last updated
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
UPDATE_SUMMARY	Contains the summary of the changes made to the last revision of the corresponding document.
DOC_ID	Id of the metalink document
DOC_LAST_UPDATE_DETECTED_DATE	Contains the date at which the Catalog Refresher Program last updated this row after it detected that the document had changed on Metalink.

Application Object Library - FND_OAM_DOC_LINK	Metadata information to create URLs for Metalink Documents
Column Name	Descritpion
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
DOC_LINK_INFO	Metadata information to generate URLs to Metalink documents

Application Object Library - FND_OAM_DOC_CATEGORY_ASSOC	Stores information about association between document categories
Column Name	Descritpion
CATEGORY_TYPE	type of category
PARENT_CATEGORY_KEY	Key for the parent category
PARENT_CATEGORY_TYPE	Type for the parent category
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
CATEGORY_KEY	key for the category

Application Object Library - FND_OAM_DOC_CATEGORY	Stores information about document categories
Column Name	Descritpion
CATEGORY_TYPE	type of category
CATEGORY_NAME	Name of the category
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
CATEGORY_KEY	key for the category

Application Object Library - FND_OAM_CP_OVERVIEW_CHARTS	Chart setting for the concurrent processing overview page
Column Name	Descritpion
FIRST_CHART_ID	The chart_id selected for the chart shown in the left side
SECOND_CHART_ID	The chart_id selected for the chart shown in the right side
LAST_UPDATE_DATE	Last update date
USER_ID	user ID

Application Object Library - FND_OAM_CHART_ITEMS_TL	Translation table for fnd_oam_chart_items_tl
Column Name	Descritpion
CHART_ITEM_SHORT_NAME	Chart item short name. It is concurrent_queue_name for managers
SOURCE_LANG	Source Language
CHART_ITEM_NAME	Chart item name. It is user_concurrent_queue_name for managers
DESCRIPTION	Chart description
LANGUAGE	language
CREATED_BY	user_id who created this chart group
CREATION_DATE	Creation date
LAST_UPDATED_BY	user_id who last updated this entry
LAST_UPDATE_DATE	Last update date
LAST_UPDATE_LOGIN	Logged in user_id who last updated this entry

Application Object Library - FND_OAM_CHART_SETTINGS	OAM Chart settings
Column Name	Descritpion
CHART_ID	Sequence num used to identify the chart
LAST_UPDATE_LOGIN	Logged in user_id who last updated this entry
USER_ID	user ID
REFRESH_INTERVAL	Refresh interval in seconds
REFRESH_TYPE	Refresh mode, M-Manual, A- AUTO, N-not applicable
CHART_TYPE	The chart type. It should be recognized by thinGraph
CREATED_BY	user_id who created this chart group
CREATION_DATE	Creation date
LAST_UPDATED_BY	user_id who last updated this entry
LAST_UPDATE_DATE	Last update date

Application Object Library - FND_OAM_CHART_ITEMS	OAM chart items
Column Name	Descritpion
CHART_ITEM_SHORT_NAME	chart item short name. It is concurrent_queue_name for managers
USER_ID	User id
CHART_ID	Sequence num used to identify the chart
SELECTED	selected or not
CREATED_BY	user_id who created this chart group
CREATION_DATE	Creation date
LAST_UPDATED_BY	user_id who last updated this entry
LAST_UPDATE_DATE	Last update date
LAST_UPDATE_LOGIN	Logged in user_id who last updated this entry

Application Object Library - FND_OAM_CHARTS_TL	Translation table for fnd_oam_charts
Column Name	Descritpion
CHART_ID	Sequence number for chart.
SOURCE_LANG	Source language
CHART_NAME	Chart name
DESCRIPTION	Chart description
LANGUAGE	Language
CREATED_BY	user_id who created this chart group
CREATION_DATE	Creation date
LAST_UPDATED_BY	user_id who last updated this entry
LAST_UPDATE_DATE	Last update date
LAST_UPDATE_LOGIN	Logged in user_id who last updated this entry

Application Object Library - FND_OAM_CHARTS	OAM charts
Column Name	Descritpion
CHART_ID	Sequence num used to identify the chart.
LAST_UPDATED_BY	user_id who last updated this entry
LAST_UPDATE_DATE	Last update date
LAST_UPDATE_LOGIN	Logged in user_id who last updated this entry
CHART_GROUP_ID	Sequence num used to identify the chart group
DISPLAY_ORDER	Display order for OAM UI
ALLOW_CONFIG	Allow configuration or not
REFRESH_INTERVAL	Refresh interval in seconds
REFRESH_TYPE	Refresh mode, M-Manual, A- AUTO, N-not applicable
CHART_TYPE	The chart type. It should be recognized by thinGraph
CREATED_BY	user_id who created this chart group
CREATION_DATE	Creation date

Application Object Library - FND_OAM_CHART_GRPS_TL	translation table for fnd_oam_chart_grps
Column Name	Descritpion
CHART_GROUP_ID	Sequence number for chart group
SOURCE_LANG	Source language
CHART_GROUP_NAME	Chart group name
DESCRIPTION	Chart group description
LANGUAGE	Language
CREATED_BY	user_id who created this chart group
CREATION_DATE	Creation date
LAST_UPDATED_BY	user_id who last updated this entry
LAST_UPDATE_DATE	Last update date
LAST_UPDATE_LOGIN	Logged in user_id who last updated this entry

Application Object Library - FND_OAM_CHART_GRPS	used for OAM chart groups
Column Name	Descritpion
CHART_GROUP_ID	Sequence num used to identify the chart group
CHART_GROUP_SHORT_NAME	Chart group short name
PARENT_GROUP_ID	The parent group id for this chart group. If the value is -1, it is a root group
DISPLAY_ORDER	Display order for OAM UI
CREATED_BY	user_id who created this chart group
CREATION_DATE	Creation date
LAST_UPDATED_BY	user_id who last updated this entry
LAST_UPDATE_DATE	Last update date
LAST_UPDATE_LOGIN	Logged in user_id who last updated this entry

Application Object Library - FND_OAM_CLONE_NOTIF	To relate notifications to cloning jobs
Column Name	Descritpion
NOTIFICATION_ID	Id of a particular notification
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
JOB_KEY	Unique key for the job

Application Object Library - FND_OAM_CLONE_JOBS	To information pertaining to cloning jobs.
Column Name	Descritpion
JOB_XML	XML data containing the information related to this cloning activity.
CREATED_BY	CREATED_BY
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
JOB_NOTES	store information about clones
JOB_KEY	Unique key for the job

Application Object Library - FND_OAM_BF_WIT_INFO	This table stores the workflow work item type related indicators for work item types that are associated with business flows
Column Name	Descritpion
ITEM_TYPE	Work item type
COUNT_ERRORED_ITEMS	Count of errored work items belonging to this item type
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
COUNT_ACTIVE_ITEMS	Count of active work items belonging to this item type.

Application Object Library - FND_OAM_BF_WIT_CUST	This table stores the association between business flows with Work Item Types for user defined flows
Column Name	Descritpion
ITEM_TYPE	Work item type
BIZ_FLOW_KEY	Unique identifier for a particular key business flow
MONITORED_FLAG	Indicates whether the work item type is to be monitored for this parent flow. Possible values are 'Y' or 'N'
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
DISPLAY_ORDER	ORDER IN WHICH THE CHILD WORK ITEM TYPE SHOULD APPEAR UNDER THE PARENT FLOW

Application Object Library - FND_OAM_BF_WIT	This table stores the association between business flows with Work Item Types for predefined flows
Column Name	Descritpion
ITEM_TYPE	Work item type
BIZ_FLOW_KEY	Unique identifier for a particular key business flow
MONITORED_FLAG	Indicates whether the work item type is to be monitored for this parent flow. Possible values are 'Y' or 'N'
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
DISPLAY_ORDER	ORDER IN WHICH THE CHILD WORK ITEM TYPE SHOULD APPEAR UNDER THE PARENT FLOW

Application Object Library - FND_OAM_BF_TL	This table stores the display names and descriptions per language for predefined business flows
Column Name	Descritpion
BIZ_FLOW_KEY	Unique identifier for a particular key business flow
SOURCE_LANG	Standard Who Column
LANGUAGE	Language code
FLOW_DISPLAY_NAME	Display name of the flow
DESCRIPTION	Description of the flow
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Application Object Library - FND_OAM_BF_ROLLUP_INFO	This table stores the health indicator information for business flows
Column Name	Descritpion
BIZ_FLOW_KEY	Business flow key
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
COUNT_RUNNING_REQUESTS	Count of running concurrent requests for this flow.
COUNT_FORM_SESSIONS	Count of active form sessions for this flow.
COUNT_SSF_SESSIONS	Count of self-service fwk sessions for this flow.
COUNT_ACTIVE_WORK_ITEMS	Count of active work items belonging to this flow.
COUNT_ALERTS	Count of new or open system alerts for this flow
COUNT_ERRORED_REQUESTS	Count of errored concurrent requests within the last 24 hours for this flow
COUNT_ERRORED_WORK_ITEMS	Count of errored work items for this flow
SETUP_STATUS	Setup status for this flow
TEST_STATUS	Test status for this flow
DIAGNOSTIC_TEST_STATUS	Diagnostic test status for this flow
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column

Application Object Library - FND_OAM_BF_MODEL	This table will store the hierarchical XML representation of each top level key business flow
Column Name	Descritpion
BIZ_FLOW_KEY	Key for the top level flow
BIZ_FLOW_MODEL_XML	XML document that represents the hierarchical model for this flow
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
SYNCHRONIZED	Whether the Business flow is synchronized or not

Application Object Library - FND_IMP_MONITOR	FND_IMP_MONITOR
Column Name	Descritpion
SNAPSHOT_ID	SNAPSHOT_ID
SET_TYPE	SET_TYPE
VIRTUAL_BUG_NO	VIRTUAL_BUG_NO
R1_REQUESTOR	R1_REQUESTOR
R1_SYNC_DATE	R1_SYNC_DATE
R2_REQUESTOR	R2_REQUESTOR
R2_SYNC_DATE	R2_SYNC_DATE
PSMASTER2_SZ	PSMASTER2_SZ
REQUEST_ID	REQUEST_ID
CREATION_DATE	CREATION_DATE
LAST_UPDATE_DATE	LAST_UPDATE_DATE
LAST_UPDATED_BY	LAST_UPDATED_BY
CREATED_BY	CREATED_BY
VIRTUAL_PATCH_ID	Virtual Patch ID

Application Object Library - FND_IMP_DEPRELATIONS	FND_IMP_DEPRELATIONS
Column Name	Descritpion
PARENT_OBJECT_ID	PARENT_OBJECT_ID
PARENT_OBJECT_NAME	PARENT_OBJECT_NAME
PARENT_APP_SHORT_NAME	PARENT_APP_SHORT_NAME
PARENT_OBJECT_TYPE	PARENT_OBJECT_TYPE
CHILD_OBJECT_ID	CHILD_OBJECT_ID
CHILD_OBJECT_NAME	CHILD_OBJECT_NAME
CHILD_APP_SHORT_NAME	CHILD_APP_SHORT_NAME
CHILD_OBJECT_TYPE	CHILD_OBJECT_TYPE
SNAPSHOT_ID	SNAPSHOT_ID
DEPENDENCY_TYPE	DEPENDENCY_TYPE
GRAPH_DEPENDENCY	GRAPH_DEPENDENCY
OBJECT_VERSION_NUMBER	OBJECT_VERSION_NUMBER
CREATED_BY	CREATED_BY
CREATION_DATE	CREATION_DATE
LAST_UPDATED_BY	LAST_UPDATED_BY
LAST_UPDATE_DATE	LAST_UPDATE_DATE
LAST_UPDATE_LOGIN	LAST_UPDATE_LOGIN
SECURITY_GROUP_ID	SECURITY_GROUP_ID

Application Object Library - FND_IMP_DEPOBJECTS	FND_IMP_DEPOBJECTS
Column Name	Descritpion
OBJECT_ID	OBJECT_ID
ATTRIB8	ATTRIB8
ATTRIB9	ATTRIB9
OBJECT_VERSION_NUMBER	OBJECT_VERSION_NUMBER
CREATED_BY	CREATED_BY
CREATION_DATE	CREATION_DATE
LAST_UPDATED_BY	LAST_UPDATED_BY
LAST_UPDATE_DATE	LAST_UPDATE_DATE
LAST_UPDATE_LOGIN	LAST_UPDATE_LOGIN
SECURITY_GROUP_ID	SECURITY_GROUP_ID
OBJECT_NAME	OBJECT_NAME
OBJECT_TYPE	OBJECT_TYPE
APP_SHORT_NAME	APP_SHORT_NAME
FILE_DIRECTORY	FILE_DIRECTORY
FILENAME	FILENAME
FILE_TYPE	FILE_TYPE
RCS_ID	RCS_ID
SNAPSHOT_ID	SNAPSHOT_ID
OCHKSUM	OCHKSUM
FCHKSUM	FCHKSUM
ATTRIB0	ATTRIB0
ATTRIB1	ATTRIB1
ATTRIB2	ATTRIB2
ATTRIB3	ATTRIB3
ATTRIB4	ATTRIB4
ATTRIB5	ATTRIB5
ATTRIB6	ATTRIB6
ATTRIB7	ATTRIB7

Application Object Library - FND_IMP_DEPMODIFIEDTIME	FND_IMP_DEPMODIFIEDTIME
Column Name	Descritpion
DEPENDENCY_TYPE	DEPENDENCY_TYPE
LAST_MODIFIED_TIME	LAST_MODIFIED_TIME
OBJECT_VERSION_NUMBER	OBJECT_VERSION_NUMBER
CREATED_BY	CREATED_BY
CREATION_DATE	CREATION_DATE
LAST_UPDATED_BY	LAST_UPDATED_BY
LAST_UPDATE_DATE	LAST_UPDATE_DATE
LAST_UPDATE_LOGIN	LAST_UPDATE_LOGIN
SNAPSHOT_ID	SNAPSHOT_ID
SECURITY_GROUP_ID	SECURITY_GROUP_ID

Application Object Library - FND_IMP_BUGSET	fnd_imp_bugset
Column Name	Descritpion
SNAPSHOT_ID	SNAPSHOT_ID
SET_TYPE	SET_TYPE
VIRTUAL_BUG_NO	VIRTUAL_BUG_NO
PATCH_ORDER	PATCH_ORDER
BUG_NO	BUG_NO
CREATION_DATE	CREATION_DATE
LAST_UPDATE_DATE	LAST_UPDATE_DATE
LAST_UPDATED_BY	LAST_UPDATED_BY
REQUEST_ID	REQUEST_ID
CREATED_BY	CREATED_BY
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination
VIRTUAL_PATCH_ID	Virtual Patch ID

Application Object Library - FND_IMP_MENU_DEP_SUMMARY3	FND_IMP_MENU_DEP_SUMMARY3
Column Name	Descritpion
BUG_NO	BUG_NO
APPLICATION_SHORT_NAME	APPLICATION_SHORT_NAME
RESP_CNT	RESP_CNT
PATH_CNT	PATH_CNT
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination
SNAPSHOT_ID	SNAPSHOT_ID

Application Object Library - FND_IMP_MENU_DEP_SUMMARY2	FND_IMP_MENU_DEP_SUMMARY2
Column Name	Descritpion
BUG_NO	BUG_NO
PATH	Relative path of a file
FORM_NAME	FORM_NAME
USER_CNT	USER_CNT
APPLICATION_SHORT_NAME	APPLICATION_SHORT_NAME
RESPONSIBILITY_NAME	RESPONSIBILITY_NAME
RESPONSIBILITY_ID	RESPONSIBILITY_ID
DESCRIPTION	DESCRIPTION
SNAPSHOT_ID	SNAPSHOT_ID
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination

Application Object Library - FND_IMP_MENU_DEP2	FND_IMP_MENU_DEP2
Column Name	Descritpion
BUG_NO	BUG_NO
APP_ID	APP_ID
RESP_ID	RESP_ID
ROOT_MENU_ID	ROOT_MENU_ID
PATH	Relative path of a file
FORM_NAME	FORM_NAME
USER_CNT	USER_CNT
DESCRIPTION	DESCRIPTION
SNAPSHOT_ID	SNAPSHOT_ID
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination

Application Object Library - FND_IMP_DIAGMAP	FND_IMP_DIAGMAP
Column Name	Descritpion
BUG_NO	BUG_NO
APPNAME	APPNAME
GROUPNAME	GROUPNAME
TESTCLASSNAME	TESTCLASSNAME
PATCH_CNT	PATCH_CNT
TOT_CNT	TOT_CNT
PATCH_ID	Generated number to uniquely indentify (bug_no, baseline) combination
SNAPSHOT_ID	SNAPSHOT_ID

Application Object Library - FND_HTTP_TICKETS	Table to store short-lifespan and one-time-use tickets
Column Name	Descritpion
START_DATE	The date the ticket was issued, default SYSDATE
END_DATE	The date the ticket will expire; null indicates that the ticket has no pre-set expiration.
OPERATION	An optional place to store the operation or function associated with the ticket.This is to provide extra security versus operations that are passed through the client without any other validity checks.
ARGUMENT	An optional place to store arguments to the operation, again as an extra security measure.
TICKET	Random 128-bit binary value assigned as the ticket for the secured operation - this is the primary key for the table.

Application Object Library - FND_IREP_CLASSES	Integration Repository information concerning executable interfaces
Column Name	Descritpion
CLASS_ID	primary key
CLASS_TYPE	Product that owns interface
PRODUCT_CODE	Technology type
IMPLEMENTATION_NAME	Java Implementation name
DEPLOYED_FLAG	Deployed Flag
GENERATED_FLAG	Generated Flag
COMPATIBILITY_FLAG	Compatability Flag
ASSOC_CLASS_ID	Pointer to Base Class
SCOPE_TYPE	Scope
LIFECYCLE_MODE	Lifecycle
SOURCE_FILE_PRODUCT	Product for source file
CLASS_NAME	unique qualified name of interface
SOURCE_FILE_PATH	Path for source file
SOURCE_FILE_NAME	Source file name
SOURCE_FILE_VERSION	Version of source file
DESCRIPTION	Description
XML_DESCRIPTION	WSDL or Schema
STANDARD_TYPE	Standard Type
STANDARD_VERSION	Version of Standard
STANDARD_SPEC	Specification for Standard
LOAD_ERR	Loading Error Flag
LOAD_ERR_MSGS	Loading Error Buffer
IREP_NAME	native name of interface
OPEN_INTERFACE_FLAG	Open Interface Flag
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
SECURITY_GROUP_ID	Security Group ID

Application Object Library - FND_IREP_CLASSES_TL	TL Table for IREP Classes table
Column Name	Descritpion
CLASS_ID	Primary key
LAST_UPDATE_LOGIN	Standard who column
SECURITY_GROUP_ID	Security Group ID
LANGUAGE	Language
SOURCE_LANG	Source Language
DISPLAY_NAME	Display Name
SHORT_DESCRIPTION	Short Description
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column

Application Object Library - FND_IREP_CLASS_PARENT_ASSIGNS	Parent Assignments for Integration Repository
Column Name	Descritpion
CLASS_NAME	Name of child class
PARENT_CLASS_NAME	Name of parent class

Application Object Library - FND_IREP_USES_TABLES	Tables used by open interfaces
Column Name	Descritpion
CLASS_ID	Open Interface ID
TABLE_USED	Table or View Name
DISPLAY_SEQUENCE	Display Sequence
TABLE_DIRECTION	Direction

Application Object Library - FND_IREP_USES_MAPS	Uses Maps Information for iRep
Column Name	Descritpion
CLASS_ID	Class ID
MAP_USED	Map
DISPLAY_SEQ	Display Sequence

Application Object Library - FND_HTTP_SERVICE_TICKETS
Column Name	Descritpion
SERVICE
TICKET
OLD_TICKET
END_DATE

Application Object Library - FND_IMP_BUGSET_TEMP	Temporary table used during patch impact analysis
Column Name	Descritpion
BUG_NO	Bug Number
PATCH_ID	Patch ID

Application Object Library - FND_IMP_LANG_SUMMARY
Column Name	Descritpion
SNAPSHOT_ID
BUG_NO
REQ_TRANS_CNT

Application Object Library - FND_IREP_CLASS_DATASOURCES	Stores metadata about data sources exposed on a Service
Column Name	Descritpion
CLASS_ID	Service Class ID
DATASOURCE_NAME	Service Data Source name
DEF_CLASS	Service View Object definition name
QUERYABLE	Indicates if the data source can be queried. (Y/N)
UPDATEABLE	Indicates if you can update records in the data source. (Y/N)
INSERTABLE	Indicates if you can insert records in the data source.(Y/N)
MERGEABLE	Indicates if you can merge records in the data source. (Y/N)
DELETEABLE	Indicates if you can update records in the data source. (Y/N)

Application Object Library - FND_LOADER_OPEN_INTERFACE	Regular database table that stores configuration information required by the batch invocation
Column Name	Descritpion
BATCH_ID
START_TIME
FINISH_TIME
ERROR_TEXT
LOGFILE
SEQ_IN_BATCH
LCT
LDT
LOADER_MODE
ENTITY
TRACE_LEVEL
PARAMS
STATUS

Application Object Library - FND_IREP_DEFERRED_LOAD_FILES
Column Name	Descritpion
FILE_PRODUCT	File's product top
LOG_FILE	Log file from last load attempt
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
BATCH_ID	Batch ID from FNDLOAD batch used for last load attempt
FILE_PATH	File's path
FILE_NAME	File's name
FILE_VERSION	File's source control revision
LOAD_STATUS	Status of file
LOAD_ERRORS	Errors encountered during load
LOAD_START	Start time of last load attempt
LOAD_FINISH	End time of last load attempt
REQUEST_ID	Request ID for last load attempt

Application Object Library - FND_LOOKUP_VALUES_IL	Table that holds seed data for industry translated lookup values
Column Name	Descritpion
INDUSTRY_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
APPLICATION_ID
LOOKUP_TYPE
LOOKUP_CODE
MEANING
DESCRIPTION
ORIG_MEANING
ORIG_DESCRIPTION

Application Object Library - FND_MO_SP_PREFERENCES
Column Name	Descritpion
USER_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
RESP_ID
SECURITY_PROFILE_ID
ORGANIZATION_ID
CREATION_DATE
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Application Object Library - FND_NEW_MESSAGES_IL	Table that holds seed data for industry translated messages
Column Name	Descritpion
INDUSTRY_ID
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
LANGUAGE_CODE
APPLICATION_ID
MESSAGE_NAME
MESSAGE_TEXT
DESCRIPTION
ORIG_MESSAGE_TEXT
ORIG_DESCRIPTION
CREATED_BY

Application Object Library - FND_OAM_CHART_METRICS	Concurrent Processing Chart Metrics
Column Name	Descritpion
METRIC_SHORT_NAME	Metric Short Name
METRIC_CONTEXT	Metric Context
VALUE	Metric Value
CHART_ID	Concurrent Processing Chart ID
CREATED_BY	Created By
CREATION_DATE	Creation Date
LAST_UPDATED_BY	Last Updated By
LAST_UPDATE_DATE	Last Update Date
LAST_UPDATE_LOGIN	Last Update Login

Application Object Library - FND_OAM_CPSTATS_PROGRAM	Concurrent Processing Statistics Group by Program
Column Name	Descritpion
APPLICATION_ID	Application ID
CREATION_DATE	Creation Date
LAST_UPDATED_BY	Last Updated By
LAST_UPDATE_DATE	Last Update Date
LAST_UPDATE_LOGIN	Last Update Login
PROGRAM_ID	Concurrent Program ID
STATS_INTERVAL	Statistics Collection Interval
TOTAL_RUNTIME	Total Runtime in Seconds
AVE_RUNTIME	Average Runtime in Seconds
MIN_RUNTIME	Minimum Runtime in Seconds
MAX_RUNTIME	Maximum Runtime in Seconds
TIMES_RUN	Times Run
CREATED_BY	Created By

Application Object Library - FND_OAM_CPSTATS_USER	Concurrent Processing Statistics Group by User
Column Name	Descritpion
USER_ID	User ID
STATS_INTERVAL	Statistics Collection Interval
COMP_REQ_COUNT	Completed Requests Count
TOTAL_RUNTIME	Total Runtime in Seconds
CREATED_BY	Created By
CREATION_DATE	Creation Date
LAST_UPDATED_BY	Last Updated By
LAST_UPDATE_DATE	Last Update Date
LAST_UPDATE_LOGIN	Last Update Login

Application Object Library - FND_OAM_DOC_METADATA	Document Metadata
Column Name	Descritpion
METADATA_TYPE	Metadata Type
LAST_UPDATE_LOGIN	Last Update Login
METALINK_DOC_ID	Metalink Document ID
METALINK_ATTACH_ID	Metalink Document Attachment ID
FILE_NAME	File Name
METADATA_CONTENT	MetaData Content
CREATED_BY	Created By
CREATION_DATE	Creation Date
LAST_UPDATED_BY	Last Updated By
LAST_UPDATE_DATE	Last Update Date

Application Object Library - FND_OAM_DS_ALGOS_B	This is the base table for the Data Scrambling Algorithm objects. An algorithm is a snippet of SQL which is associated with a PII attribute or a specific PII table column to define how that data should be scrambled.
Column Name	Descritpion
ALGO_ID
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE
END_DATE
USE_ALGO_ID
DEFAULT_FOR_DATATYPE_FLAG
DATATYPE
ALGO_TEXT
WEIGHT_MODIFIER
CREATED_BY

Application Object Library - FND_OAM_DS_DELETES	This table holds the table purge directives used by the Data Scrambling feature.
Column Name	Descritpion
DELETE_ID
LAST_UPDATE_LOGIN
OWNER
TABLE_NAME
WHERE_CLAUSE
USE_TRUNCATE_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE

Application Object Library - FND_OAM_DS_ALGOS_TL	This is the translated base table for the Data Scrambling Algorithm objects.
Column Name	Descritpion
ALGO_ID
LAST_UPDATE_LOGIN
DISPLAY_NAME
DESCRIPTION
LANGUAGE
SOURCE_LANG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE

Application Object Library - FND_OAM_DS_POLICIES_B	This is the base table for the Data Scrambling Policy object.
Column Name	Descritpion
POLICY_ID
START_DATE
END_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Application Object Library - FND_OAM_DS_PII_EXTENSIONS	This table holds additional metadata which is specific to Data Scrambling, is related to PII elements and is not stored in the PII schema objects.
Column Name	Descritpion
PII_EXTENSION_ID
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PRIVACY_ATTRIBUTE_CODE
APPLICATION_ID
TABLE_ID
COLUMN_ID
POLICY_ID
ALGO_ID
WHERE_CLAUSE
CREATED_BY

Application Object Library - FND_OAM_DS_POLICIES_TL	This is the translated base table for the Data Scrambling Policy object.
Column Name	Descritpion
POLICY_ID
SOURCE_LANG
POLICY_NAME
DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
LANGUAGE

Application Object Library - FND_OAM_DS_POLICY_ELMNTS	This table stores the many-to-many relationship entries between Data Scrambling Policies and the elements which can be contained within a policy. Currently, a policy may contain PII attributes and/or OAM-managed table purge directives.
Column Name	Descritpion
POLICY_REL_ID
LAST_UPDATE_LOGIN
POLICY_ID
ELEMENT_TYPE
PRIVACY_ATTRIBUTE_CODE
DELETE_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE

Application Object Library - FND_OAM_DS_PSET_ELMNTS	This table stores the many-to-many relationship entries between Policy Sets and Policies.
Column Name	Descritpion
POLICYSET_REL_ID
POLICYSET_ID
POLICY_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Application Object Library - FND_OAM_DS_PSETS_B	This is the base table for the Data Scrambling Policy Set object.
Column Name	Descritpion
POLICYSET_ID
START_DATE
END_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Application Object Library - FND_OAM_DSCFG_INSTANCES	This table holds the Data Scrambling Intermediate Configuration Instance objects. A configuration instance identifies the set of objects and properties imported from the Policy Set which will be compiled into a runtime configuration.
Column Name	Descritpion
CONFIG_INSTANCE_ID
COMPILE_DURATION
SOURCE_DBNAME
CLONE_KEY
POLICYSET_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
TARGET_DBNAME
CONFIG_INSTANCE_TYPE
NAME
DESCRIPTION
LANGUAGE
LAST_IMPORTED
IMPORT_DURATION
LAST_COMPILED

Application Object Library - FND_OAM_DS_PSETS_TL	This is the translated base table for the Data Scrambling Policy Set object.
Column Name	Descritpion
POLICYSET_ID
SOURCE_LANG
POLICYSET_NAME
DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
LANGUAGE

Application Object Library - FND_OAM_DSCFG_MAPPED_KEYS	This table is not yet used by the Data Scrambling Feature.
Column Name	Descritpion
MAPPED_KEY_ID
RAW_PK1
RAW_PK2
RAW_PK3
VARCHAR2_PK1
VARCHAR2_PK2
VARCHAR2_PK3
VARCHAR2_PK4
VARCHAR2_PK5
CREATED_BY
CREATION_DATE
CONFIG_INSTANCE_ID
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PARENT_PROC_ID
MAPPED_KEY_TYPE
NUMBER_PK1
NUMBER_PK2
NUMBER_PK3
NUMBER_PK4
NUMBER_PK5

Application Object Library - FND_OAM_DSCFG_OBJECTS	This table holds the Data Scrambling Intermediate Configuration Object objects. Each operation to be performed by the engine is stored as an object with one or more properties defining the type and parameters of that operation.
Column Name	Descritpion
OBJECT_ID
ERRORS_FOUND_FLAG
MESSAGE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CONFIG_INSTANCE_ID
OBJECT_TYPE
PARENT_OBJECT_ID
SOURCE_PROC_ID
SOURCE_TYPE
SOURCE_ID
TARGET_TYPE
TARGET_ID

Application Object Library - FND_OAM_DSCFG_PROCS	This table holds the Data Scrambling Intermediate Configuration Procedure objects. The EM orchestration engine makes use of this table to provide a list of procedures for execution during each of the stages surrounding the actual scramble.
Column Name	Descritpion
PROC_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PROC_TYPE
STAGE
START_DATE
END_DATE
PRIORITY
ERROR_IS_FATAL_FLAG
LOCATION
EXECUTABLE

Application Object Library - FND_OAM_DSCRAM_ARGS_TL	This is the translated base table for the Data Scrambling Engine Argument object.
Column Name	Descritpion
ARG_ID
LAST_UPDATE_LOGIN
DISPLAY_NAME
DESCRIPTION
LANGUAGE
SOURCE_LANG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE

Application Object Library - FND_OAM_DSCRAM_BUNDLES	This table holds the Data Scrambling Engine Bundle object. Each engine run is composed of one or more bundles which identify a set of tasks which belong to a specific host participating in the execution of the run.
Column Name	Descritpion
BUNDLE_ID
STATS_FINISHED
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
RUN_ID
BUNDLE_STATUS
TARGET_HOSTNAME
WEIGHT
WORKERS_ALLOWED
WORKERS_ASSIGNED
BATCH_SIZE
MIN_PARALLEL_UNIT_WEIGHT

Application Object Library - FND_OAM_DSCRAM_ARGS_B	This is the base table for the Data Scrambling Engine Argument object.The arguments infrastructure is used by the engine is a place were transient data which is required by or generated by the engine.
Column Name	Descritpion
ARG_ID
WRITE_POLICY
DATATYPE
VALID_VALUE_FLAG
CANONICAL_VALUE
SOURCE_TYPE
SOURCE_TEXT
SOURCE_WHERE_CLAUSE
SOURCE_FINAL_TEXT
CREATED_BY
CREATION_DATE
ARG_NAME
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PARENT_TYPE
PARENT_ID
ENABLED_FLAG
INITIALIZED_SUCCESS_FLAG
ALLOW_OVERRIDE_SOURCE_FLAG
BINDING_ENABLED_FLAG
PERMISSIONS

Application Object Library - FND_OAM_DSCFG_PROPERTIES	This table holds the Data Scrambling Intermediate Configuration Properties objects. Each operation to be performed by the engine is stored as an object with one or more properties defining the type and parameters of that operation.
Column Name	Descritpion
PROPERTY_ID
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PARENT_TYPE
PARENT_ID
PROPERTY_NAME
DATATYPE
CANONICAL_VALUE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY

Application Object Library - FND_OAM_DSCRAM_ARG_VALUES	this table holds the values for Data Scrambling Engine Argument objects. These are used may be provided to and/or generated by the engine.
Column Name	Descritpion
ARG_VALUE_ID
CANONICAL_VALUE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ARG_ID
PARENT_TYPE
PARENT_ID
ROWID_LBOUND
ROWID_UBOUND
ID_LBOUND
ID_UBOUND
VALID_VALUE_FLAG

Application Object Library - FND_OAM_DSCRAM_DMLS	this table holds DML statements which belong to a specific unit used by the Data Scrambling Engine.
Column Name	Descritpion
DML_ID
STATS_FINISHED
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
UNIT_ID
FINISHED_RET_STS
PRIORITY
WEIGHT
DML_STMT
DML_WHERE_CLAUSE
DML_FINAL_STMT
ROWS_PROCESSED

Application Object Library - FND_OAM_DSCRAM_RUNS_B	This is the base table for the Data Scrambling Engine Run object. A run is used to uniquely identify a single execution of the engine. If they are run fails or is stopped, the run may be restarted in lieu of creating a new run.
Column Name	Descritpion
RUN_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
RUN_STATUS
RUN_MODE
TARGET_DBNAME
CONFIG_INSTANCE_ID
WEIGHT
LAST_RUN_STAT_ID
VALID_CHECK_INTERVAL
STATS_FINISHED

Application Object Library - FND_OAM_DSCRAM_PLSQLS	This table holds references to PL SQL procedures which belong to a specific unit used by the Data Scrambling Engine.
Column Name	Descritpion
PLSQL_ID
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
UNIT_ID
FINISHED_RET_STS
PRIORITY
WEIGHT
PLSQL_TEXT
PLSQL_FINAL_TEXT
STATS_FINISHED
CREATED_BY

Application Object Library - FND_OAM_DSCRAM_STATS	This table holds statistics collected during the execution of the Data Scrambling Engine.
Column Name	Descritpion
STAT_ID
CHILD_LAST_START
CHILD_LAST_END
TOTAL_RUNTIME
PCT_DONE
STATS_LAST_COLLECTED
DATAPOINTS_COLLECTED
DATAPOINTS_TOTAL
ERRORS_FOUND_FLAG
FINISHED_INCOMPLETE_FLAG
MESSAGE
RUN_STAT_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
SOURCE_OBJECT_TYPE
SOURCE_OBJECT_ID
OBJECT_START
OBJECT_END
PRESTART_OBJECT_STATUS
POSTEND_OBJECT_STATUS
CHILD_FIRST_START

Application Object Library - FND_OAM_DSCRAM_RUNS_TL	This is the translated base table for the Data Scrambling Engine Run object. A run is used to uniquely identify a single execution of the engine. If they are run fails or is stopped, the run may be restarted in lieu of creating a new run.
Column Name	Descritpion
RUN_ID
LAST_UPDATE_LOGIN
DISPLAY_NAME
DESCRIPTION
LANGUAGE
SOURCE_LANG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE

Application Object Library - FND_OAM_DSCRAM_TASKS	This table holds the Data Scrambling Engine Task object. A task is a group of units and is used to isolate blocks of work which have interdependencies. Each task may be run independent of every other task.
Column Name	Descritpion
TASK_ID
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
BUNDLE_ID
TASK_STATUS
PRIORITY
WEIGHT
WORKERS_ASSIGNED
STATS_FINISHED
CREATED_BY
CREATION_DATE

Application Object Library - FND_OAM_METVAL_INST	OAM Dashboard Metric Value Group by Instance
Column Name	Descritpion
INST_ID	Instance ID
METRIC_SHORT_NAME	Metric Short Name
METRIC_VALUE	Metric Value
CREATED_BY	Created By
CREATION_DATE	Creation Date
LAST_UPDATED_BY	Last Updated By
LAST_UPDATE_DATE	Last Update Date
LAST_UPDATE_LOGIN	Last Update Login

Application Object Library - FND_OAM_DSCRAM_UNITS	This table holds the Data Scrambling Engine Unit object. A unit is used to identify a group of work which is related to a single table in the database.
Column Name	Descritpion
UNIT_ID
ACTUAL_WORKERS_ALLOWED
WORKERS_ASSIGNED
UNIT_OBJECT_OWNER
UNIT_OBJECT_NAME
BATCH_SIZE
ERROR_FATALITY_LEVEL
SUGGEST_DISABLE_SPLITTING
ACTUAL_DISABLE_SPLITTING
STATS_FINISHED
CREATED_BY
TASK_ID
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CONCURRENT_GROUP_UNIT_ID
UNIT_TYPE
UNIT_STATUS
PHASE
PRIORITY
WEIGHT
SUGGEST_WORKERS_ALLOWED

Application Object Library - FND_OAM_METVAL_NODE	OAM Dashboard Metric Value Group by Node
Column Name	Descritpion
NODE_NAME	Node Name
METRIC_SHORT_NAME	Metric Short Name
METRIC_VALUE	Metric Value
CREATED_BY	Created By
CREATION_DATE	Creation Date
LAST_UPDATED_BY	Last Updated By
LAST_UPDATE_DATE	Last Update Date
LAST_UPDATE_LOGIN	Last Update Login