martes, 29 de abril de 2014

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

Application Object Library - FND_TABLES Tables registered in applications
Column Name Descritpion
TABLE_ID Table identifier
PCT_USED Percent used storage parameter
DESCRIPTION Description
HOSTED_SUPPORT_STYLE validated by HOSTED_SUPPORT_STYLE lookup type.Default value is 'LOCAL'
IREP_COMMENTS Comments from CASE
IREP_ANNOTATIONS Annotations from CASE
TABLE_NAME Table name
USER_TABLE_NAME Table title
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_ID Application identifier
AUTO_SIZE Flag to indicate if this table is automatically sized during an install
TABLE_TYPE Type of the table (seed data, transaction data, interim)
INITIAL_EXTENT Initial extent storage parameter
NEXT_EXTENT Next extent storage parameter
MIN_EXTENTS Minimum extents storage parameter
MAX_EXTENTS Maximum extents storage parameter
PCT_INCREASE Percent increase storage parameter
INI_TRANS Initial transactions storage parameter
MAX_TRANS Maximum transactions storage parameter
PCT_FREE Percent free storage parameter
Application Object Library - FND_USER Application users
Column Name Descritpion
USER_NAME Application username (what a user types in at the Oracle Applications sign-on screen)
EMAIL_ADDRESS The Electronic mail address for the user
FAX The fax number for the user
CUSTOMER_ID Customer contact identifier. If the AOL user is a customer contact, this value is a foreign key to the corresponding customer contact.
SUPPLIER_ID Supplier contact identifier. If the AOL user is a supplier contact, this value is a foreign key to the corresponding supplier contact.
WEB_PASSWORD Unused
USER_GUID used to store the guid defined for this user record's corresponding entry in OID
GCN_CODE_COMBINATION_ID GCN_CODE_COMBINATION_ID
PERSON_PARTY_ID PERSON_PARTY_ID
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
ENCRYPTED_FOUNDATION_PASSWORD The Oracle Application Object Library encrypted password used to connect to database
ENCRYPTED_USER_PASSWORD The encrypted password for the application user to sign on to Oracle Applications
USER_ID Application user identifier
SESSION_NUMBER The session number of the application user's last sign-on session
START_DATE The date the user name becomes active
END_DATE The date the user name becomes inactive
DESCRIPTION Description
LAST_LOGON_DATE The date the application user last signed on
PASSWORD_DATE The date the current password was set
PASSWORD_ACCESSES_LEFT The number of accesses left for the password
PASSWORD_LIFESPAN_ACCESSES The number of accesses allowed for the password
PASSWORD_LIFESPAN_DAYS Lifespan of the password
EMPLOYEE_ID Identifier of employee to whom the application username is assigned
Application Object Library - FND_VALUE_ATTRIBUTE_TYPES Key flexfield segment qualifiers
Column Name Descritpion
APPLICATION_ID select nvl(t.application_id,-1) from fnd_tables t, fnd_id_flexs f, fnd_segment_attribute_types s, fnd_value_attribute_types at where t.table_name(+) = f.application_table_name and f.id_flex_code(+) = s.id_flex_code and s.se
CREATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
REQUIRED_FLAG Always contains the value Y
APPLICATION_COLUMN_NAME Column name
DEFAULT_VALUE Default value for the qualifier
LOOKUP_TYPE QuickCode lookup type
ID_FLEX_CODE select nvl(s.id_flex_code,'none') from fnd_segment_attribute_types s, fnd_value_attribute_types t where s.segment_attribute_type(+) = t.segment_attribute_type and t.segment_attribute_type = fnd_value_attribute_types.segment_
DERIVATION_RULE_CODE Always contains the value G12
DERIVATION_RULE_VALUE1 Always contains the value N
DERIVATION_RULE_VALUE2 Always contains the value Y
SEGMENT_ATTRIBUTE_TYPE Name of flexfield qualifier
VALUE_ATTRIBUTE_TYPE Name of segment qualifier
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
CREATION_DATE Standard Who column
Application Object Library - FND_SESSIONS Current sessions of Oracle Application Object Library
Column Name Descritpion
SESSION_ID Identifier for the current database session of Object Library
EFFECTIVE_DATE The effective date for the current session
Application Object Library - FND_SHORTHAND_FLEX_ALIASES Alias information for shorthand flexfield entry
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_shorthand_flex_aliases.id_flex_code and rownum = 1
CREATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
CONCATENATED_SEGMENTS The concatenated key flexfield segment values that is represented by the shorthand alias
ENABLED_FLAG Flag to indicate whether the shorthand alias is enabled
DESCRIPTION Description
ID_FLEX_CODE Key flexfield code
START_DATE_ACTIVE The date the shorthand alias becomes active
END_DATE_ACTIVE The date the shorthand alias expires
ID_FLEX_NUM Key flexfield structure number
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
ALIAS_NAME Name of the shorthand alias
ATTRIBUTE10 Descriptive flexfield segment
ATTRIBUTE11 Descriptive flexfield segment
ATTRIBUTE12 Descriptive flexfield segment
ATTRIBUTE13 Descriptive flexfield segment
ATTRIBUTE14 Descriptive flexfield segment
ATTRIBUTE15 Descriptive flexfield segment
ATTRIBUTE_CATEGORY Attribute category
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
CREATION_DATE Standard Who column
Application Object Library - FND_UNSUCCESSFUL_LOGINS Sign-On Audit information about unsuccessful login attempts
Column Name Descritpion
USER_ID The application user identifier
ATTEMPT_TIME The number of times the user tried to sign on to the application
LOGIN_NAME The operating system login name of the user
TERMINAL_ID The operating system name of the user's terminal
Application Object Library - FND_RESPONSIBILITY Responsibilities
Column Name Descritpion
APPLICATION_ID Application identifier
DATA_GROUP_APPLICATION_ID Data group application identifier
DATA_GROUP_ID Data group identifier
MENU_ID Menu identifier
TERM_SECURITY_ENABLED_FLAG Flag to indicate if Security by Terminal is enabled for the responsibility
START_DATE The date the responsibility becomes active
RESPONSIBILITY_ID Responsibility identifier
END_DATE The date the responsibility expires
GROUP_APPLICATION_ID Application identifier from report security group definition
REQUEST_GROUP_ID Identifier of report security group assigned to the responsibility
VERSION Version of responsibility. For example, web (W) or AOL (4)
WEB_HOST_NAME IP address or alias of machine where the Webserver is running. Defaults to the last agent
WEB_AGENT_NAME Name of Oracle Web Agent. Defaults to the last agent
RESPONSIBILITY_KEY Internal developer name for responsibility
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_REQUEST_GROUPS Report security groups
Column Name Descritpion
APPLICATION_ID Application identifier
LAST_UPDATE_LOGIN Standard Who column
DESCRIPTION Description
REQUEST_GROUP_CODE Request group code
REQUEST_GROUP_ID Report security group identifier
REQUEST_GROUP_NAME The name of the report security group
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_REQUEST_GROUP_UNITS Reports and groups within each report security group
Column Name Descritpion
APPLICATION_ID Application identifier
CREATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
REQUEST_GROUP_ID Report security group identifier
REQUEST_UNIT_TYPE Flag to indicate whether the report, report set, or all reports and sets in an application are included in the report security group
UNIT_APPLICATION_ID Application identifier of the report, report set, or application included in the report security group
REQUEST_UNIT_ID The identifier of the report, report set, or application included in the report security group
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
CREATION_DATE Standard Who column
Application Object Library - FND_REQUEST_SETS Reports sets
Column Name Descritpion
APPLICATION_ID Application identifier
ALLOW_CONSTRAINTS_FLAG Determines if incompatibilities are allowed
PRINT_TOGETHER_FLAG Save printing until set completes
START_DATE_ACTIVE Set available from this date
START_STAGE ID of the first stage to be executed
REQUEST_SET_ID Request Set identifier
END_DATE_ACTIVE Set unavailable after this date
CONCURRENT_PROGRAM_ID ID of program for incompatibilities
OWNER User who owns the set
PRINTER Printer assinged to the set
PRINT_STYLE Print style assinged to the set
ICON_NAME Reserved for future use
REQUEST_SET_NAME Developer name for the Request Set
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_REQUEST_SET_PROGRAMS Reports within report sets
Column Name Descritpion
SET_APPLICATION_ID Set application identifier
LAST_UPDATED_BY Standard Who column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
PROGRAM_APPLICATION_ID The application identifier of the report in the report set
CONCURRENT_PROGRAM_ID ID of program for incompatibilities
NLS_LANGUAGE Language
NLS_TERRITORY The territory using the language
REQUEST_SET_ID Request Set identifier
CRITICAL Is this a critical stage
NUMBER_OF_COPIES The number of copies to print for the report output
PRINTER Printer assinged to the set
PRINT_STYLE Print style assinged to the set
SAVE_OUTPUT_FLAG Flag to indicate whether to save the report output or not
REQUEST_SET_STAGE_ID Stage identifier for the request set
REQUEST_SET_PROGRAM_ID FND_REQUEST_SET_PROGRAMS_S.NEXTVAL
SEQUENCE The sequence of the report in the report set
LAST_UPDATE_DATE Standard Who column
Application Object Library - FND_RUN_REQUESTS Setup information for running reports within report sets
Column Name Descritpion
APPLICATION_ID Application identifier
ARGUMENT40 Concurrent Request Argument
ARGUMENT41 Concurrent Request Argument
ARGUMENT42 Concurrent Request Argument
ARGUMENT43 Concurrent Request Argument
ARGUMENT44 Concurrent Request Argument
ARGUMENT45 Concurrent Request Argument
ARGUMENT46 Concurrent Request Argument
ARGUMENT47 Concurrent Request Argument
ARGUMENT48 Concurrent Request Argument
DESCRIPTION
ARGUMENT49 Concurrent Request Argument
REQUEST_ID Concurrent request identifier
ARGUMENT50 Concurrent Request Argument
ARGUMENT51 Concurrent Request Argument
ARGUMENT52 Concurrent Request Argument
ARGUMENT53 Concurrent Request Argument
ARGUMENT54 Concurrent Request Argument
ARGUMENT55 Concurrent Request Argument
ARGUMENT56 Concurrent Request Argument
ARGUMENT57 Concurrent Request Argument
ARGUMENT58 Concurrent Request Argument
ARGUMENT59 Concurrent Request Argument
ARGUMENT60 Concurrent Request Argument
ARGUMENT61 Concurrent Request Argument
ARGUMENT62 Concurrent Request Argument
ARGUMENT63 Concurrent Request Argument
ARGUMENT64 Concurrent Request Argument
NUMBER_OF_COPIES The number of report copies to print
ARGUMENT65 Concurrent Request Argument
ARGUMENT66 Concurrent Request Argument
ARGUMENT67 Concurrent Request Argument
ARGUMENT68 Concurrent Request Argument
ARGUMENT69 Concurrent Request Argument
PRINTER Printer name
ARGUMENT70 Concurrent Request Argument
ARGUMENT71 Concurrent Request Argument
ARGUMENT72 Concurrent Request Argument
ARGUMENT73 Concurrent Request Argument
ARGUMENT74 Concurrent Request Argument
ARGUMENT75 Concurrent Request Argument
ARGUMENT76 Concurrent Request Argument
ARGUMENT77 Concurrent Request Argument
ARGUMENT78 Concurrent Request Argument
ARGUMENT79 Concurrent Request Argument
PRINT_STYLE Print style used to print request
ARGUMENT80 Concurrent Request Argument
ARGUMENT81 Concurrent Request Argument
ARGUMENT82 Concurrent Request Argument
ARGUMENT83 Concurrent Request Argument
ARGUMENT84 Concurrent Request Argument
ARGUMENT85 Concurrent Request Argument
ARGUMENT86 Concurrent Request Argument
ARGUMENT87 Concurrent Request Argument
ARGUMENT88 Concurrent Request Argument
ARGUMENT89 Concurrent Request Argument
CONCURRENT_PROGRAM_ID Concurrent program identifier
SAVE_OUTPUT_FLAG Indicates if report output is saved
ARGUMENT90 Concurrent Request Argument
ARGUMENT91 Concurrent Request Argument
ARGUMENT92 Concurrent Request Argument
ARGUMENT93 Concurrent Request Argument
ARGUMENT94 Concurrent Request Argument
ARGUMENT95 Concurrent Request Argument
ARGUMENT96 Concurrent Request Argument
ARGUMENT97 Concurrent Request Argument
ARGUMENT98 Concurrent Request Argument
ARGUMENT99 Concurrent Request Argument
ARGUMENT1 Concurrent Request Argument
ARGUMENT100 Concurrent Request Argument
NLS_LANGUAGE Language
NLS_TERRITORY The territory using the language
OPS_INSTANCE OPS Instance number
NUMERIC_CHARACTERS Stores NLS info for MLS
ORG_ID org_id
ARGUMENT2 Concurrent Request Argument
ARGUMENT3 Concurrent Request Argument
ARGUMENT4 Concurrent Request Argument
PARENT_REQUEST_ID The request identifier of the parent report set
ARGUMENT5 Concurrent Request Argument
ARGUMENT6 Concurrent Request Argument
ARGUMENT7 Concurrent Request Argument
ARGUMENT8 Concurrent Request Argument
ARGUMENT9 Concurrent Request Argument
ARGUMENT10 Concurrent Request Argument
ARGUMENT11 Concurrent Request Argument
ARGUMENT12 Concurrent Request Argument
ARGUMENT13 Concurrent Request Argument
ARGUMENT14 Concurrent Request Argument
REQUEST_SET_PROGRAM_ID The identifier for the request set program
ARGUMENT15 Concurrent Request Argument
ARGUMENT16 Concurrent Request Argument
ARGUMENT17 Concurrent Request Argument
ARGUMENT18 Concurrent Request Argument
ARGUMENT19 Concurrent Request Argument
ARGUMENT20 Concurrent Request Argument
ARGUMENT21 Concurrent Request Argument
ARGUMENT22 Concurrent Request Argument
ARGUMENT23 Concurrent Request Argument
ARGUMENT24 Concurrent Request Argument
SET_APPLICATION_ID Application identifier of the report in the report set
ARGUMENT25 Concurrent Request Argument
ARGUMENT26 Concurrent Request Argument
ARGUMENT27 Concurrent Request Argument
ARGUMENT28 Concurrent Request Argument
ARGUMENT29 Concurrent Request Argument
REQUEST_SET_ID Report set identifier
ARGUMENT30 Concurrent Request Argument
ARGUMENT31 Concurrent Request Argument
ARGUMENT32 Concurrent Request Argument
ARGUMENT33 Concurrent Request Argument
ARGUMENT34 Concurrent Request Argument
ARGUMENT35 Concurrent Request Argument
ARGUMENT36 Concurrent Request Argument
ARGUMENT37 Concurrent Request Argument
ARGUMENT38 Concurrent Request Argument
ARGUMENT39 Concurrent Request Argument
Application Object Library - FND_TERRITORIES Territories, also known as countries
Column Name Descritpion
TERRITORY_CODE The code for the territory
ADDRESS_VALIDATION Validation that is required for addresses in a particular country
BANK_INFO_STYLE Style for bank numbers used in a particular country
BANK_INFO_VALIDATION Validation that is required for banks in a particular country
NLS_TERRITORY The territory using the language
EU_CODE The EU numeric entity code
OBSOLETE_FLAG Y or N (Y for obsolete territories)
ISO_TERRITORY_CODE The ISO 3 character code for the territory
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
ISO_NUMERIC_CODE The ISO numeric entity code
ALTERNATE_TERRITORY_CODE The 'VAT' member state code' for countries within the European Economic Community
ADDRESS_STYLE The style of address used in a given country
Application Object Library - FND_PRINTER_STYLES Printer styles
Column Name Descritpion
PRINTER_STYLE_NAME Name of printer style
WIDTH Number of columns
LENGTH Number of rows
DESCRIPTION Description
ORIENTATION Description of how a printed page should be oriented
SRW_DRIVER The name of the Oracle Reports printer driver to be called when processing an OR report
HEADER_FLAG Flag to indicate whether to suppress the header page from printing
SEQUENCE The display sequence for the printer style
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_PRINTER_INFORMATION Printer styles and drivers used by printer types
Column Name Descritpion
PRINTER_TYPE Printer type
PRINTER_DRIVER Printer driver name
PRINTER_STYLE Printer style
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_PRINTER_DRIVERS Printer drivers
Column Name Descritpion
PRINTER_DRIVER_NAME The name of the printer driver
SPOOL_FLAG Flag to indicate whether the printer driver should create its own copy of a file for printing
STDIN_FLAG Flag to indicate whether the printer driver accepts standard input
SRW_DRIVER The name of the Oracle Report printer driver
HEADER_FLAG Flag to indicate whether to suppress the header page from printing
DESCRIPTION Description
COMMAND_NAME The name of a program or subroutine for the driver to invoke
ARGUMENTS Concurrent Request Argument
INITIALIZATION Tinitialization string that must be sent to the printer before the printer driver can begin printing
RESET The reset string that returns the printer to its ready state
ATTR_CATEGORY Attribute category
PLATFORM_CODE Platform code
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
USER_PRINTER_DRIVER_NAME The descriptive title of the printer driver
ATTRIBUTE11 Descriptive flexfield segment
ATTRIBUTE12 Descriptive flexfield segment
ATTRIBUTE13 Descriptive flexfield segment
ATTRIBUTE14 Descriptive flexfield segment
ATTRIBUTE15 Descriptive flexfield segment
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
PRINTER_DRIVER_METHOD_CODE The method by which the printer driver is invoked
Application Object Library - FND_PRINTER_SUBROUTINES Printer subroutines
Column Name Descritpion
PRINTER_SUBROUTINE_NAME Name of printer subroutine
DRIVER_TYPE_CODE Driver type code
DESCRIPTION Description
PLATFORM_CODE Platform code
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_SRS_MASTER
Column Name Descritpion
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
ATTRIBUTE31
ATTRIBUTE32
ATTRIBUTE33
ATTRIBUTE34
ATTRIBUTE35
ATTRIBUTE36
ATTRIBUTE37
ATTRIBUTE38
ATTRIBUTE39
ATTRIBUTE40
ATTRIBUTE41
ATTRIBUTE42
ATTRIBUTE43
ATTRIBUTE44
ATTRIBUTE45
ATTRIBUTE46
ATTRIBUTE47
ATTRIBUTE48
ATTRIBUTE49
ATTRIBUTE50
ATTRIBUTE51
ATTRIBUTE52
ATTRIBUTE53
ATTRIBUTE54
ATTRIBUTE55
ATTRIBUTE56
ATTRIBUTE57
ATTRIBUTE58
ATTRIBUTE59
ATTRIBUTE60
ATTRIBUTE61
ATTRIBUTE62
ATTRIBUTE63
ATTRIBUTE64
ATTRIBUTE65
ATTRIBUTE66
ATTRIBUTE67
ATTRIBUTE68
ATTRIBUTE69
ATTRIBUTE70
ATTRIBUTE71
ATTRIBUTE72
ATTRIBUTE73
ATTRIBUTE74
ATTRIBUTE75
ATTRIBUTE76
ATTRIBUTE77
ATTRIBUTE78
ATTRIBUTE79
ATTRIBUTE80
ATTRIBUTE81
ATTRIBUTE82
ATTRIBUTE83
ATTRIBUTE84
ATTRIBUTE85
ATTRIBUTE86
ATTRIBUTE87
ATTRIBUTE88
ATTRIBUTE89
ATTRIBUTE90
ATTRIBUTE91
ATTRIBUTE92
ATTRIBUTE93
ATTRIBUTE94
ATTRIBUTE95
ATTRIBUTE96
ATTRIBUTE97
ATTRIBUTE98
ATTRIBUTE99
ATTRIBUTE100
STRUCTURE_COLUMN
Application Object Library - FND_REQUEST_SET_PROGRAM_ARGS Default values for report set arguments
Column Name Descritpion
APPLICATION_ID Application identifier
CREATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
DISPLAY_FLAG Flag to indicate whether to display the argument
INSERT_FLAG Flag to indicate whether a value can be entered for the argument
UPDATE_FLAG Flag to indicate whether the argument can be updated
REQUEST_SET_ID Request Set identifier
DEFAULT_TYPE Type of default value
DEFAULT_VALUE Default value
SHARED_PARAMETER_NAME Name of the shared parameter
REQUEST_SET_PROGRAM_ID Report set program identifier
DESCRIPTIVE_FLEX_APPL_ID Identifier of the application with which the descriptive flexfield is defined
DESCRIPTIVE_FLEXFIELD_NAME Descriptive flexfield name
APPLICATION_COLUMN_NAME Column name
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
CREATION_DATE Standard Who column
Application Object Library - FND_PRIMARY_KEYS Primary and unique keys registered with Oracle Application Object Library
Column Name Descritpion
APPLICATION_ID Application identifier
LAST_UPDATE_LOGIN Standard Who column
PRIMARY_KEY_TYPE Primary key type (Developer or Alternate)
AUDIT_KEY_FLAG Flag to indicate if this key is the primary key
DESCRIPTION Description
ENABLED_FLAG Determines whether this key will be created as an enabled or disabled constraint
TABLE_ID Table identifier
PRIMARY_KEY_ID Primary key identifier
PRIMARY_KEY_NAME Primary key 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_PRIMARY_KEY_COLUMNS Primary and unique key columns registered with Oracle Application Object Library
Column Name Descritpion
APPLICATION_ID Application identifier
LAST_UPDATE_LOGIN Standard Who column
TABLE_ID Table identifier
PRIMARY_KEY_ID Primary key identifier
PRIMARY_KEY_SEQUENCE Sequence of the column in the primary 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_SEQUENCES Sequences registered with Oracle Application Object Library
Column Name Descritpion
APPLICATION_ID Application identifier
START_VALUE Sequence start value
INCREMENT_BY Sequence increment by
MIN_VALUE Sequence minimum value
MAX_VALUE Sequence maximum value
CACHE_SIZE Sequence cache size
CYCLE_FLAG Sequence cycle flag
SEQUENCE_ID Sequence identifier
ORDER_FLAG Sequence order by flag
DESCRIPTION Description
SEQUENCE_NAME Sequence 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_VIEWS Views registered with Oracle Application Object Library
Column Name Descritpion
VIEW_ID View identifier
VIEW_NAME View 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
DESCRIPTION Description
APPLICATION_ID Application identifier
TEXT Text of the view statement
IREP_COMMENTS Comments from CASE
IREP_ANNOTATIONS Annotations from CASE
Application Object Library - FND_VIEW_COLUMNS View columns registered with Oracle Application Object Library
Column Name Descritpion
VIEW_ID View identifier
COLUMN_SEQUENCE Sequence of the column in the view
COLUMN_NAME Column 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_ID Application identifier
IREP_COMMENTS Comments from CASE
Application Object Library - FND_TRANSLATION_EXCEPTIONS This table is used exclusively by the Seed Data Translation tool and is not needed during application runtime
Column Name Descritpion
APPLICATION_ID Application identifier
LAST_UPDATE_LOGIN Standard Who column
COMPARISON_OPERATOR Comparison operator
VALUE value
TYPE Type of translation exception
LOGICAL_OPERATOR Logical operator
TABLE_ID Table identifier
COLUMN_ID Column identifier
SEQUENCE Sequence
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_SEG_RPT_ATTRIBUTES Reporting attributes
Column Name Descritpion
SEGMENT_NUM Segment number
FLEX_VALUE_SET_ID Flexfield value set identifier
USER_COLUMN_NAME Segment title
INDEX_FLAG Flag to indicate whether the table column for this segment is indexed
FORM_LEFT_PROMPT From left prompt
APPLICATION_ID Application identifier
FORM_ABOVE_PROMPT Above prompt
DISPLAY_SIZE Display size
ENABLED_FLAG Enabled 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
SEGMENT_NAME Segment name
ATTR_VALUE_SET_ID Attribute value set identifier
ID_FLEX_CODE Key flexfield code
COLUMN_TYPE Column data type
DESCRIPTION Description
SEQUENCE Sequence
FLEX_VALUE_SET_APPLICATION_ID Flexfield value set application identifier
ATTR_SEGMENT_NAME Attribute segment name
ATTR_COLUMN_ID Attribute column identifier
TABLE_ID Table identifier
ATTRIBUTE_NUM Attribute number
ID_FLEX_NUM Key flexfield structure number
APPLICATION_COLUMN_NAME Column name
Application Object Library - FND_RESPONSIBILITY_TL Translations for FND_RESPONSIBILITY
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.
RESPONSIBILITY_ID Responsibility identifier
LANGUAGE Language
RESPONSIBILITY_NAME Name of responsibility
Application Object Library - FND_PROFILE_OPTIONS_TL Translations for FND_PROFILE_OPTIONS
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
LAST_UPDATE_LOGIN Standard Who column
PROFILE_OPTION_NAME Name of the profile option
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.
LANGUAGE Language
USER_PROFILE_OPTION_NAME Title of the profile option
Application Object Library - FND_VAL_ATTRIBUTE_TYPES_TL Translations for FND_VALUE_ATTRIBUTE_TYPES
Column Name Descritpion
PROMPT Qualifier prompt
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
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
SEGMENT_ATTRIBUTE_TYPE Name of flexfield qualifier
VALUE_ATTRIBUTE_TYPE Name of segment qualifier
Application Object Library - FND_TERRITORIES_TL Translations for FND_TERRITORIES
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
LAST_UPDATE_LOGIN Standard Who column
TERRITORY_CODE The code for the territory
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.
LANGUAGE Language
TERRITORY_SHORT_NAME The short name that stands for the territory
Application Object Library - FND_PRINTER_STYLES_TL Translations for FND_PRINTER_STYLES
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
PRINTER_STYLE_NAME Name of printer style
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.
USER_PRINTER_STYLE_NAME Title of printer style
LANGUAGE Language
LAST_UPDATE_DATE Standard Who column
Application Object Library - FND_PRINTER_TL Translations for FND_PRINTER
Column Name Descritpion
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
DESCRIPTION Description
PRINTER_NAME Printer name
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
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
Application Object Library - FND_REQUEST_SETS_TL Translations for FND_REQUEST_SETS
Column Name Descritpion
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.
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
USER_REQUEST_SET_NAME User name for the request set
DESCRIPTION Description
REQUEST_SET_ID Request Set identifier
LANGUAGE Language
Application Object Library - FND_RESP_FUNCTIONS Function Security
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
APPLICATION_ID Application identifier
RESPONSIBILITY_ID Responsibility identifier
ACTION_ID Value depends on RULE_TYPE
RULE_TYPE Rule type
Application Object Library - FND_RT_REQUESTS Stores concurrent requests
Column Name Descritpion
TEST_ID Test identifier
REQUEST_ID Request identifier
Application Object Library - FND_PERFORMANCE_DATA Network performance test data
Column Name Descritpion
D8 Data for network testing
D9 Data for network testing
D10 Data for network testing
D11 Data for network testing
D12 Data for network testing
D13 Data for network testing
D14 Data for network testing
D15 Data for network testing
D16 Data for network testing
D17 Data for network testing
DATA_ID Data identifier
D18 Data for network testing
D19 Data for network testing
D20 Data for network testing
D21 Data for network testing
D22 Data for network testing
D23 Data for network testing
D24 Data for network testing
D25 Data for network testing
D26 Data for network testing
D27 Data for network testing
D1 Data for network testing
D28 Data for network testing
D29 Data for network testing
D30 Data for network testing
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
D2 Data for network testing
D3 Data for network testing
D4 Data for network testing
D5 Data for network testing
D6 Data for network testing
D7 Data for network testing
Application Object Library - FND_PERFORMANCE_RESULTS Results of network performance tests
Column Name Descritpion
TEST_ID Test identifier
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
TYPE indicates if the row contains the results of the bandwidth or latency tests
TRIAL_ID The serial number of the test
ELAPSED_TIME Indicates the time it takes to perform each trial of the test. This time measurement is used to calculte the efective latency or the bandwidth of the network
START_TIME Indicates the time the trial starts
END_TIME Indicates the time the trial ends
CORRECTION_TIME Indicates the time used for the time correction
CREATION_DATE Standard Who column
Application Object Library - FND_PERFORMANCE_TESTS Data from performance tests
Column Name Descritpion
TEST_ID Test identifier
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
TEST_DATE Identifies the date when the test was performed
BATCH Indicates if the test was performed in batch mode, interactive mode, or if it is a reference test
DATA_SIZE The amount of data used for the bandwidth test
LATENCY_TRIALS The number of trials for latency tests
BANDWIDTH_TRIALS The number of trials for bandwidth tests
LATENCY_ITERATIONS Number of iterations to calculate average latency
BANDWIDTH_ITERATIONS Number of iterations to calculate average bandwidth
NOTES Notes
Application Object Library - FND_PERF_EVENT_LOOKUP - Retrofitted
Column Name Descritpion
CODE - Retrofitted
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
FULL_NAME - Retrofitted
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
Application Object Library - FND_PERF_VARIABLES - Retrofitted
Column Name Descritpion
VARIABLE - Retrofitted
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
VALUE - Retrofitted
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
Application Object Library - FND_PLAN_TABLE - Retrofitted
Column Name Descritpion
STATEMENT_ID - Retrofitted
OBJECT_TYPE - Retrofitted
SEARCH_COLUMNS - Retrofitted
ID - Retrofitted
PARENT_ID - Retrofitted
POSITION - Retrofitted
OTHER - Retrofitted
TIMESTAMP - Retrofitted
REMARKS - Retrofitted
OPERATION - Retrofitted
OPTIONS - Retrofitted
OBJECT_NODE - Retrofitted
OBJECT_OWNER - Retrofitted
OBJECT_NAME - Retrofitted
OBJECT_INSTANCE - Retrofitted
Application Object Library - FND_SQL_SAMPLES - Retrofitted
Column Name Descritpion
SQL_HASH_VALUE - Retrofitted
TYPE - Retrofitted
PROGRAM - Retrofitted
SNAPDATE - Retrofitted
Application Object Library - FND_WAIT_SAMPLES - Retrofitted
Column Name Descritpion
CT - Retrofitted
EVENT - Retrofitted
DETAIL - Retrofitted
FGBG - Retrofitted
RTBT - Retrofitted
SNAPDATE - Retrofitted
Application Object Library - FND_USER_DESKTOP_OBJECTS Documents saved by a user on the Navigator
Column Name Descritpion
OBJECT_NAME Internal key associated with the type of document
FUNCTION_NAME Function to invoke in order to restore document
OBJECT_LABEL Test that identifies the object on the Navigator
PARAMETER_STRING Additional parameters to pass when invoking function to restore document
SEQUENCE Sequence that objects appear on Navigator
DESKTOP_OBJECT_ID Internal primary key
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
TYPE Specifies whether the object is a document or a function
USER_ID User that saved the object on the navigator
APPLICATION_ID Application identifier
RESPONSIBILITY_ID Responsibility user was in when saving object on Navigator
Application Object Library - FND_REQUEST_SET_STAGES Stores request set stages
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
SET_APPLICATION_ID Set application identifier
CRITICAL Is this a critical stage
OUTCOME Reserved for future use
ALLOW_CONSTRAINTS_FLAG Determines if incompatibilities are allowed
DISPLAY_SEQUENCE Used for ordering in Forms and Reports
FUNCTION_APPLICATION_ID Applicaiton ID of the stage function
FUNCTION_ID Executable ID of stage function
SUCCESS_LINK Next stage ID for success
WARNING_LINK Next stage ID for warning
ERROR_LINK Next stage ID for error
CONCURRENT_PROGRAM_ID ID of program for incompatibilities
REQUEST_SET_ID Request Set identifier
X X coordinate on designer canvas
Y Y coordinate on designer canvas
ICON_NAME Reserved for future use
REQUEST_SET_STAGE_ID Stage identifier for the request set
STAGE_NAME Developer name for the stage
Application Object Library - FND_REQUEST_SET_STAGES_TL Translation for FND_REQUEST_SET_STAGES
Column Name Descritpion
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.
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
SET_APPLICATION_ID Set application identifier
LAST_UPDATE_LOGIN Standard Who column
USER_STAGE_NAME User name for the stage
DESCRIPTION Description
REQUEST_SET_ID Request Set identifier
REQUEST_SET_STAGE_ID Stage identifier for the request set
LANGUAGE Language
Application Object Library - FND_STAGE_LINK_VERTICES
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
VERTEX_ID
LINK
X
Y
SEQUENCE
SET_APPLICATION_ID
REQUEST_SET_ID
REQUEST_SET_STAGE_ID
Application Object Library - FND_TEMP_FILES Stores names of database server PL/SQL temporary files available for use
Column Name Descritpion
FILENAME PL/SQL temporary filename
REQUEST_ID
SESSION_ID
FSIZE
NODE
TYPE
Application Object Library - FND_REQUEST_TEMP - Retrofitted
Column Name Descritpion
REQUEST_ID - Retrofitted
FILE_TYPE - Retrofitted
FILENAME - Retrofitted
Application Object Library - FND_STAGE_FN_PARAMETERS_TL Translation for FND_STAGE_FN_PARAMETERS
Column Name Descritpion
APPLICATION_ID - Retrofitted
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
USER_PARAMETER_NAME - Retrofitted
DESCRIPTION - Retrofitted
FUNCTION_ID - Retrofitted
PARAMETER_ID - Retrofitted
PARAMETER_NAME - Retrofitted
LANGUAGE - Retrofitted
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.
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
Application Object Library - FND_STAGE_FN_PARAMETER_VALUES - Retrofitted
Column Name Descritpion
SET_APPLICATION_ID - Retrofitted
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
VALUE - Retrofitted
REQUEST_SET_ID - Retrofitted
REQUEST_SET_STAGE_ID - Retrofitted
FUNCTION_APPLICATION_ID - Retrofitted
FUNCTION_ID - Retrofitted
PARAMETER_ID - Retrofitted
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
Application Object Library - FND_RUN_REQ_PP_ACTIONS FND_RUN_REQ_PP_ACTIONS stores the post request processing actions
Column Name Descritpion
PARENT_REQUEST_ID Identifier for the parent request
PROGRAM_ID Identifier for program
ARGUMENTS Concurrent Request Arguments
SEQUENCE Indicates the order for the post processing actions
NUMBER_OF_COPIES Indicates the number of copies to print
ORIG_SYSTEM Notification user originating system
ORIG_SYSTEM_ID Notification user originating system id
NLS_LANGUAGE NLS Language
OPS_INSTANCE OPS Instance
ARGUMENT1 pp action argument1
ARGUMENT2 pp action argument2
ARGUMENT3 pp action argument3
ARGUMENT4 pp action argument4
ARGUMENT5 pp action argument5
REQUEST_SET_PROGRAM_ID Identifier for the request set program
ARGUMENT6 pp action argument6
ARGUMENT7 pp action argument7
ARGUMENT8 pp action argument8
ARGUMENT9 pp action argument9
ARGUMENT10 pp action argument10
SET_APPLICATION_ID Application identifier for the request set
REQUEST_SET_ID Identifier for the request set
ACTION_TYPE Type of action
STATUS_S_FLAG Perform action on success
STATUS_W_FLAG Perform action on warning
STATUS_F_FLAG Perform action on failure
PROGRAM_APPLICATION_ID Identifier for program application
Application Object Library - FND_TEMP_FILE_PARAMETERS Temporary table for secure file upload or download
Column Name Descritpion
FILE_ID Identifier for secure file operation request
FILE_PARAMETERS Secure file operation parameters
Application Object Library - FND_PSAC_CONVERSION_TERMS - Retrofitted
Column Name Descritpion
APPLICATION_ID - Retrofitted
LANGUAGE - Retrofitted
FROM_TERM - Retrofitted
TO_TERM - Retrofitted
Application Object Library - FND_PSAC_CONVERT_COLUMNS - Retrofitted
Column Name Descritpion
CONV_TAB_ID - Retrofitted
COLUMN_NAME - Retrofitted
Application Object Library - FND_PSAC_CONVERT_TABLES - Retrofitted
Column Name Descritpion
CONV_TAB_ID - Retrofitted
APPLICATION_ID - Retrofitted
TABLE_NAME - Retrofitted
TRANSLATED - Retrofitted
LANG_COLUMN - Retrofitted
JOIN_BY_APPLICATION_ID - Retrofitted
Application Object Library - FND_PSAC_PRODUCT_TABLES - Retrofitted
Column Name Descritpion
APPLICATION_ID - Retrofitted
CONV_TAB_ID - Retrofitted
Application Object Library - FND_PSAC_SQL_STATEMENT - Retrofitted
Column Name Descritpion
SS_ID - Retrofitted
CREATION_DATE Standard Who column
STATEMENT - Retrofitted
Application Object Library - FND_USER_PREFERENCES Runtime user preference settings
Column Name Descritpion
USER_NAME Internal name of user who owns this preference setting
MODULE_NAME Module that references this preference
PREFERENCE_NAME Preference name
PREFERENCE_VALUE Preference value
Application Object Library - FND_SECURITY_GROUPS Service bureau data security groups.
Column Name Descritpion
SECURITY_GROUP_ID Security group identifier
SECURITY_GROUP_KEY Security group developer key
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_SECURITY_GROUPS_TL Translations for FND_SECURITY_GROUPS
Column Name Descritpion
SECURITY_GROUP_ID Security group identifier
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
SECURITY_GROUP_NAME User name of security group
DESCRIPTION Security group 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
Application Object Library - FND_RUN_REQ_LANGUAGES Language selections for multilingual concurrent requests
Column Name Descritpion
PARENT_REQUEST_ID Concurrent request identifier
NLS_LANGUAGE Code for language
NLS_TERRITORY Code for territory using the language
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
CREATION_DATE Standard Who column
LAST_UPDATE_LOGIN Standard Who column
CREATED_BY Standard Who column
NUMERIC_CHARACTERS Stores NLS info for MLS
Application Object Library - FND_TRACE_LOG Log for tests of cost-based optimization; not for use in production environment
Column Name Descritpion
USERNAME Application username
TIMESTAMP Timestamp of when user logged on
OUTPUT_CONC_REQUEST_ID Concurrent request ID
OLTP_OPT_MODE OLTP optimizer mode
CONC_OPT_MODE Concurrent optmizer mode
CONC_PROGRAM_NAME Concurrent program name
USER_CONC_PROGRAM_NAME User concurrent program name
RESP_NAME Responsibility name
APPLICATION_SHORT_NAME Application short name
Application Object Library - FND_STATS_HIST Time required by FND_STATS to gather statistics
Column Name Descritpion
SCHEMA_NAME Name of the object's schema
REQUEST_ID REQUEST_ID
EST_PERCENT Estimate Percent for current object
HISTORY_MODE History Mode
REQUEST_TYPE Type of Fnd_stats request
OBJECT_NAME Name of the object
OBJECT_TYPE Type of object ( TABLE/INDEX/COLUMN)
PARTITION Partition name if it is a partitioned object
COLUMN_TABLE_NAME Name of table if object_type if COLUMN
LAST_GATHER_DATE Date when statistics were gathered
LAST_GATHER_START_TIME Start time
LAST_GATHER_END_TIME End time
PARALLEL Degree of parallelization
Application Object Library - FND_TM_EVENTS
Column Name Descritpion
EVENT_TYPE
RESPONSIBILITY_ID
CHARDATA
NUMDATA
RUNNING_PROCESSES
TARGET_PROCESSES
TIMESTAMP
TRANSACTION_ID
QUEUE_APPLICATION_ID
CONCURRENT_QUEUE_ID
PROGRAM_APPLICATION_ID
CONCURRENT_PROGRAM_ID
USER_ID
RESP_APPL_ID
Application Object Library - FND_SERVERS
Column Name Descritpion
SERVER_KEY
LAST_UPDATE_LOGIN
NUMERIC_CHARACTERS
DATE_FORMAT
DATE_LANGUAGE
SERVER_TYPE
SERVER_LANGUAGE
URL
PARAMETERS
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
Application Object Library - FND_SERVERS_TL
Column Name Descritpion
SERVER_KEY
SOURCE_LANG
LANGUAGE
SERVER_NAME
DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
Application Object Library - FND_OPS_INSTANCES Service Name mapping for each Oracle Parallel Server instance
Column Name Descritpion
INSTANCE_NUMBER Oracle Parallel Server instance number
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
SERVICE_NAME Primary service name of the instance
PRIMARY_SERVICE_NAME Primary service name of the instance
SECONDARY_SERVICE_NAME Secondary service name of the instance
TIME_STAMP
STATUS
DESCRIPTION
ENABLED Flag (Y|N) that indicates whether the Conflict Resolution Manager or Scheduler may connect to this instance
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
Application Object Library - FND_ORACLE_USERID ORACLE accounts that contain application data
Column Name Descritpion
ORACLE_ID Identifier for ORACLE account
DESCRIPTION Description
ENABLED_FLAG Flag to indicate if the ORACLE account is active
READ_ONLY_FLAG Flag to indicate if the ORACLE account can update Oracle Application Object Library data
ORACLE_USERNAME Username for the ORACLE account
ENCRYPTED_ORACLE_PASSWORD Password for the ORACLE account in a encrypted format
CONCURRENT_BATCH_QUEUE_ID Not currently used
INSTALL_GROUP_NUM Indicates set of books
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_TREE_FOLDERS APPTREE personal and public nodes
Column Name Descritpion
FOLDER_ID Primary Key column
CREATION_DATE standard who
CREATED_BY standard who
LAST_UPDATE_DATE standard who
LAST_UPDATED_BY standard who
LAST_UPDATE_LOGIN standard who
OBJ_NAME Name of the primary object displayed in the tree
NODE_LABEL The label displayed in the tree
FOLDER_TYPE Type of Folder (Q,I,N)
VALUE The value assigned to the node
SEQUENCE The order to be displayed
PARENT_FOLDER_ID join to folder_id
PUBLIC_FLAG Is this a public folder?
LANGUAGE Apps standard language column
Application Object Library - FND_OBJ_INSTANCE_SETS_TL
Column Name Descritpion
INSTANCE_SET_ID
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LANGUAGE
SOURCE_LANG
DISPLAY_NAME
DESCRIPTION
Application Object Library - FND_OBJ_INSTANCE_SETS_B
Column Name Descritpion
INSTANCE_SET_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
OBJECT_NAME
INSTANCE_SET_NAME
PREDICATE
LAST_UPDATE_LOGIN
Application Object Library - FND_PRINTER Printers registered with Oracle Application Object Library
Column Name Descritpion
PRINTER_NAME Name of printer
PRINTER_TYPE Printer type
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_PRINTER_TYPES Printer Types
Column Name Descritpion
PRINTER_TYPE Printer type
DESCRIPTION Description
RESET_STRING Not currently used
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_PROFILE_OPTIONS User profile options
Column Name Descritpion
APPLICATION_ID Application identifier
WRITE_ALLOWED_FLAG Flag to indicate if user exits or forms can update the profile option
READ_ALLOWED_FLAG Flag to indicate if user exits or forms can read the profile option
USER_CHANGEABLE_FLAG Flag to indicate if users can update the value for the profile option
USER_VISIBLE_FLAG Flag to indicate if users can see the value for the profile option
SITE_ENABLED_FLAG Flag to indicate whether the profile option is enabled at the site level
SITE_UPDATE_ALLOWED_FLAG Flag to indicate whether the profile option should be updatable at the site level
APP_ENABLED_FLAG Flag to indicate whether the profile option is enabled at the application level
APP_UPDATE_ALLOWED_FLAG Flag to indicate whether the profile option should be updatable at the application level
PROFILE_OPTION_ID Profile option identifier
RESP_ENABLED_FLAG Flag to indicate whether the profile option is enabled at the responsibility level
RESP_UPDATE_ALLOWED_FLAG Flag to indicate whether the profile option should be updatable at the responsibility level
USER_ENABLED_FLAG Flag to indicate whether the profile option is enabled at the user level
USER_UPDATE_ALLOWED_FLAG Flag to indicate whether the profile option should be updatable at the user level
START_DATE_ACTIVE The date the profile option becomes active
SQL_VALIDATION The validation criteria for LOV definition of profile option values
END_DATE_ACTIVE The date the profile option expires
PROFILE_OPTION_NAME Name of the profile option
HIERARCHY_TYPE HIERARCHY_TYPE
SERVER_ENABLED_FLAG SERVER_ENABLED_FLAG
ORG_ENABLED_FLAG ORG_ENABLED_FLAG
SERVER_UPDATE_ALLOWED_FLAG SERVER_UPDATE_ALLOWED_FLAG
LAST_UPDATE_DATE Standard Who column
ORG_UPDATE_ALLOWED_FLAG ORG_UPDATE_ALLOWED_FLAG
SERVERRESP_ENABLED_FLAG Whether the profile is enabled at the server/responsibility level
LAST_UPDATED_BY Standard Who column
SERVERRESP_UPDATE_ALLOWED_FLAG Whether the profile can be updated at the server/responsibility level
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
Application Object Library - FND_PROFILE_OPTION_VALUES Values of user profile options defined at different profile levels
Column Name Descritpion
APPLICATION_ID Application identifier
CREATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
PROFILE_OPTION_VALUE The value of the profile option
LEVEL_VALUE_APPLICATION_ID Application identifier for the profile level "Application"
PROFILE_OPTION_ID Profile option identifier
LEVEL_VALUE2 Used in the Server/Responsibility level of the SERVRESP hierarchy to store the server_id or a default value
LEVEL_ID Profile level identifier
LEVEL_VALUE The value of the profile level
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
CREATION_DATE Standard Who column
Application Object Library - FND_SELAUDIT_GROUPS Created to store the configuration of the columns for which Select Auditing is active
Column Name Descritpion
APPLICATION_ID Application identifier with which the table is registered
DESCRIPTION Description
AUDIT_GROUP_ID Table identifier
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
GROUP_NAME Audit group name
STATE Flag to indicate if the Audit Group is enabled
Application Object Library - FND_SELAUDIT_LOG FND_SELAUDIT_LOG
Column Name Descritpion
AUDIT_SQL AUDIT_SQL
CONC_PROGRAM_ID CONC_PROGRAM_ID
CONC_REQUEST_ID CONC_REQUEST_ID
AUDIT_TIMESTAMP AUDIT_TIMESTAMP
AUDIT_OBJECT_NAME AUDIT_OBJECT_NAME
AUDIT_OBJECT_SCHEMA AUDIT_OBJECT_SCHEMA
AUDIT_POLICY_NAME AUDIT_POLICY_NAME
LOGIN_ID LOGIN_ID
USER_NAME USER_NAME
CONC_LOGIN_ID CONC_LOGIN_ID
CONC_APPL_ID CONC_APPL_ID
Application Object Library - FND_SELAUDIT_TABLES Created to store the configuration of the columns for which Select Auditing is active
Column Name Descritpion
AUDIT_GROUP_ID Audit group identifier
STATE Flag to indicate the state of the database trigger or the states of the enable/disable requests
AUDIT_CONDITION The where clause that will trigger the select audit on the given table. NULL values will cause all selects against the table to be audited
AUDIT_GROUP_APP_ID Audit group application identifier
TABLE_APP_ID Table application identifier
TABLE_ID Table identifier
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
Application Object Library - FND_PORTLET_DEPENDENCY stores the relationship between a row in fnd_form_functions and the data collector program that effects the content that is displayed in that form function
Column Name Descritpion
REFRESH_DEPENDENCY Name of concurrent program, UI function, or other datasource that causes a refresh of the portlet content.
REFRESH_DEPENDENCY_CONTEXT Additional column that uniquely identifies thedata source. For concurrent programs this column stores the applicationshort name value for the concurrent program definition.
FUNCTION_NAME Portlet function that should have its cached content refreshed wheneverthe concurrent program or other data source is run.
LAST_UPDATE_DATE LAST_UPDATE_DATE
LAST_UPDATED_BY LAST_UPDATED_BY
CREATION_DATE CREATION_DATE
CREATED_BY CREATED_BY
LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
Application Object Library - FND_PRODUCT_INITIALIZATION Stores each Application's initialization function name.
Column Name Descritpion
APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
INIT_FUNCTION_NAME the name of the initializtion routine name
LAST_UPDATED_BY LAST_UPDATED_BY
LAST_UPDATE_DATE LAST_UPDATED_DATE
LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
CREATION_DATE CREATION_DATE
CREATED_BY CREATED_BY
Application Object Library - FND_PRODUCT_INIT_CONDITION Stores each Applicatoin's valid initialization condition.
Column Name Descritpion
APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
RE_INIT_CONDITION one of the initialization condition ('APPL', 'RESP', 'USER', 'SEC', 'NLS')
LAST_UPDATED_BY LAST_UPDATED_BY
LAST_UPDATE_DATE LAST_UPDATED_DATE
LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
CREATION_DATE CREATION_DATE
CREATED_BY CREATED_BY
Application Object Library - FND_PRODUCT_INIT_DEPENDENCY Stores each Application's initialization dependency information.
Column Name Descritpion
APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
PRODUCT_DEPENDENCY the name of the product that this application depends on
LAST_UPDATED_BY LAST_UPDATED_BY
LAST_UPDATE_DATE LAST_UPDATE_DATE
LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
CREATION_DATE CREATION_DATE
CREATED_BY CREATED_BY
Application Object Library - FND_RAW_DELETEME_TEST
Column Name Descritpion
RAW_GUID
Application Object Library - FND_OAM_MET_GRPS_TL OAM Dashboard Metric Groups Translated Table
Column Name Descritpion
METRIC_GROUP_ID Metric Group ID
LAST_UPDATE_LOGIN Standard Who Column
SOURCE_LANG Language
SEQUENCE The order in which the group will be displayed in OAM UI
LANGUAGE Language
METRIC_GROUP_DISPLAY_NAME Display name for the metric group
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
Application Object Library - FND_OAM_UPLOAD_STATUS OAM upload status info.
Column Name Descritpion
SERVICE_APPLICATION_ID Application id.
SERVICE_TYPE The upload type, for example: Forms RTI.
NODE Middle tier node name where the runtimr process is running.
LAST_UPLOAD Timestamp written by service program after upload.
STATE 'S' for Started, 'C' for completed.
SERVICE_ID CQID of GSM Forms Listener Instance.
Application Object Library - FND_OBJECTS Objects of data elements that can be secured in data security grantsInitially an object is a database table or view.
Column Name Descritpion
OBJECT_ID PK Object ID
PK1_COLUMN_TYPE Data type of column 1: VARCHAR2, INTEGER, FLOAT, or DATE.
PK2_COLUMN_TYPE Data type of column 2: VARCHAR2, INTEGER, FLOAT, or DATE
PK3_COLUMN_TYPE Data type of column 3: VARCHAR2, INTEGER, FLOAT, or DATE
PK4_COLUMN_TYPE Data type of column 4: VARCHAR2, INTEGER, FLOAT, or DATE
PK5_COLUMN_TYPE Data type of column 5: VARCHAR2, INTEGER, FLOAT, or DATE.
CREATED_BY CREATED_BY
CREATION_DATE CREATED_DATE
LAST_UPDATED_BY LAST_UPDATED_BY
LAST_UPDATE_DATE LAST_UPDATED_DATE
LAST_UPDATE_LOGIN LAST_UPDATED_LOGIN
IREP_NAME Name (possibly non-unique) name of base object (used by irep).
OBJ_NAME UK Table or View name
IREP_OBJECT_TYPE Technology type
IREP_PRODUCT Product that owns interface
LOAD_ERR Loading Error Flag
LOAD_ERR_MSGS Loading Error Buffer
IREP_COMPATIBILITY Compatability Flag
IREP_SCOPE Scope
IREP_LIFECYCLE Lifecycle
IREP_SOURCE_FILE_PRODUCT Product for Source File
IREP_SOURCE_FILE_PATH Path for Source File
IREP_SOURCE_FILE_NAME Source File Name
IREP_SOURCE_FILE_VERSION Version of Source File
IREP_DESCRIPTION Description
IREP_XML_DESCRIPTION Schema
IREP_STANDARD Standard Type
IREP_STANDARD_VERSION Version of Standard
IREP_STANDARD_SPEC Specification for Standard
OPEN_INTERFACE_FLAG Open Interface Flag
IREP_LDR_PP_FLAG Loader Post Processing Flag
IREP_HIDE_SCHEMA Flag for Hide Schema
IREP_DEF_CLASS Default Class
APPLICATION_ID Application ID (Not in PK)
IREP_CLASS_NAME Class Name
IREP_FILTER_REQUIRED Filter Required Flag
IREP_IS_FILTER Filter Flag
IREP_IS_EXPRESSION Expression Flag
IREP_LDR_INTERNAL_FLAG Used internally by the iRep loader
CRAWL_CRAWLABLE Is this object to be crawled
CRAWL_VISIBILITY_LEVEL Determine the visability of this Object (GLOBAL,GUEST,GROUP,USER)
CRAWL_SEARCH_PLUGIN Java class to implement the getACL and getSecurityKey
CRAWL_UI_FUNCTION FND Form Function to construct linking url
CRAWL_CHANGE_EVENT_NAME Event name for event base change
CRAWL_CHANGE_NOTIFICATION Y/N to indicate if we need to use the driving table as change notification
CRAWL_DRIVING_TABLE Name for driving table
CRAWL_SEARCHID Search engine identifier
CRAWL_LASTCRAWLED Useful for incremental
DATABASE_OBJECT_NAME name of database table
PK1_COLUMN_NAME Name of column 1 in object PK. Most selective columns first.
PK2_COLUMN_NAME Name of column 2 in object PK.
PK3_COLUMN_NAME Name of column 3 in object PK.
PK4_COLUMN_NAME Name of column 4 in object PK.
PK5_COLUMN_NAME Name of column 5 in object PK.
Application Object Library - FND_OBJECTS_TL Object translation subtable
Column Name Descritpion
OBJECT_ID PK1: ObjectID(FK to FND_OBJECT)
LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
LANGUAGE PK2: Language
SOURCE_LANG Language defaulted from
DISPLAY_NAME Object display name
DESCRIPTION Object description
CREATED_BY CREATED_BY
CREATION_DATE CREATION_DATE
LAST_UPDATED_BY LAST_UPDATED_BY
LAST_UPDATE_DATE LAST_UPDATE_DATE
Application Object Library - FND_OBJECT_INSTANCE_SETS Object instance sets are groups of object instances. Initially instance sets define groups of database rows via a SQL predicate
Column Name Descritpion
INSTANCE_SET_ID PK: Instance set ID
INSTANCE_SET_NAME UK: Instance set name
OBJECT_ID Object ID
PREDICATE predicate: SQL where clause that defines which rows are included, w/o literal "where"
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_OBJECT_INSTANCE_SETS_TL Object Instance Set translation subtable
Column Name Descritpion
INSTANCE_SET_ID PK1: Instance Set ID
LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
LANGUAGE PK2: Language
SOURCE_LANG Source Language
DISPLAY_NAME Display name
DESCRIPTION Description
CREATED_BY CREATED_BY
CREATION_DATE CREATION_DATE
LAST_UPDATED_BY LAST_UPDATED_BY
LAST_UPDATE_DATE LAST_UPDATE_DATE
Application Object Library - FND_SESSION_VALUES Stores servlet session values
Column Name Descritpion
ICX_SESSION_ID ICX user session identification number
OBJECT_VERSION_NUMBER Object version number
SESSION_VALUE Servlet session values
DISABLED_FLAG DISABLED_FLAG
TIMESTAMP Date when the session values were saved
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_TIMEZONES_B List of Timezone names (translated) for LOV purposes
Column Name Descritpion
TIMEZONE_CODE the unique identifier of a timezone
LAST_UPDATED_BY LAST_UPDATED_BY
LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
ENABLED_FLAG Indicates whether the zone is currently enabled for use
GMT_OFFSET The offset from gmt of this timezone under standard time
DAYLIGHT_SAVINGS_FLAG Indicates whether this zone adjusts for daylight savings
ACTIVE_TIMEZONE_CODE Indicates which timezone is currently active with the same conversion rules
UPGRADE_TZ_ID Used for upgrade purposes from foreign key to hz_timezones
CREATION_DATE CREATION_DATE
CREATED_BY CREATED_BY
LAST_UPDATE_DATE LAST_UPDATE_DATE
Application Object Library - FND_TIMEZONES_TL List of Timezone names (translated) for LOV purposes
Column Name Descritpion
TIMEZONE_CODE the unique identifier of a timezone
LANGUAGE Language to which this row is translated
NAME Name of the timezone in the language specified
SOURCE_LANG SOURCE_LANG
CREATION_DATE CREATION_DATE
CREATED_BY CREATED_BY
LAST_UPDATE_DATE LAST_UPDATE_DATE
LAST_UPDATED_BY LAST_UPDATED_BY
LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
Application Object Library - FND_UMS_BUGFIXES Bugfix definitions for UMS.
Column Name Descritpion
BUGFIX_GUID Bugfix GUID.
LAST_DEFINITION_DATE LAST_DEFINITION_DATE
BASELINE Base line of the Bug Number
RELEASE_NAME Name of the release. (e.g., 11i)
BUG_NUMBER Bug number.
APPLICATION_SHORT_NAME Application short name.
RELEASE_STATUS ARU release status.
TYPE Bugfix type (e.g., 'BUGFIX', 'PATCHSET')
ABSTRACT Description of the bugfix.
LAST_UPDATE_DATE who column
DOWNLOAD_MODE Download mode
Application Object Library - FND_UMS_BUGFIX_RELATIONSHIPS Relationships between bugfixes
Column Name Descritpion
BUGFIX_GUID Bugfix GUID.
RELATION_TYPE Type of the relation. (e.g., PREREQUISITE)
RELATED_BUGFIX_GUID Related bugfix GUID.
Application Object Library - FND_UMS_BUGFIX_FILE_VERSIONS List of files in a bugfix.
Column Name Descritpion
BUGFIX_GUID Bugfix GUID.
FILE_VERSION_GUID File Version GUID.
Application Object Library - FND_UMS_FILES File definitions for UMS.
Column Name Descritpion
FILE_GUID File GUID.
APPLICATION_SHORT_NAME Application short name.
LOCATION File Directory.
NAME File Name.
Application Object Library - FND_UMS_FILE_VERSIONS File versions for UMS.
Column Name Descritpion
FILE_VERSION_GUID File Version GUID.
FILE_GUID File GUID.
VERSION File Version.
Application Object Library - FND_REGISTRATIONS Table containing common data for User Management Framework (UMF).
Column Name Descritpion
REGISTRATION_ID PK for the table. This is unique, indexed, and synthetic
USER_TITLE The user's title, eg Mr., Mrs., Dr... This would ordinarily be a lookup code.
FIRST_NAME User's first name
MIDDLE_NAME User's middle name. Often only an initial is captured here.
LAST_NAME User's last name
USER_SUFFIX A name suffix, eg Jr
EMAIL_CONTACT_POINT_ID FK to HZ_CONTACT_POINTS. This is provisional, as we would like to use the TCA packages for validation.
EMAIL The user's email address
PHONE_CONTACT_POINT_ID FK to HZ_CONTACT_POINTS. This is provisional, as we would like to use the TCA packages for validation.
PHONE_COUNTRY_CODE The country code for the phone number
PHONE_AREA_CODE The area code for a US phone number
REGISTRATION_KEY This is the encrypted form of the registration_id.
PHONE The user's phone number. The data is usually pushed after stripping out non-numeric characters
PHONE_EXTENSION The user's extension
FAX_CONTACT_POINT_ID FK to HZ_CONTACT_POINTS. This is provisional, as we would like to use the TCA packages for validation.
FAX_COUNTRY_CODE The country code for the fax
FAX_AREA_CODE The area code for a US fax number
FAX The user's fax. The data is usually pushed after stripping out non-numeric characters.
FAX_EXTENSION The user's fax extension
LANGUAGE_CODE FK to FND_LANGUAGES LANGUAGE_CODE
TIME_ZONE User's timezone. Note that this is inconsistent across platforms: TCA stores a number, others applications store a code referencing a lookup.
TERRITORY_CODE FK to FND_TERRITORIES TERRITORY_CODE
APPLICATION_ID FK to FND_APPLICATIONS, striping the data by the application for which the prospective user is registering. Also part of FK to FND_REGISTRATION_TYPES
LOCATION_ID reference to HZ_LOCATIONS.LOCATION_ID
ADDRESS1 First line of address information
ADDRESS2 Second line of address information
CITY Name of user's city
STATE Name of user's state, if in US
PROVINCE Name of user's province or region, if outside US
ZIP User's US zip code, if in US
POSTAL_CODE User's postal code, if outside US
COUNTRY User's country for address. Usually implemented as an FND_TERRITORY TERRITORY_CODE
DATE_REQUESTED Date the registration was completed
PARTY_ID FK to HZ_PARTIES
LAST_UPDATE_DATE Who field
LAST_UPDATED_BY Who field
CREATED_BY Who field
CREATION_DATE Who field
LAST_UPDATE_LOGIN Who field
REGISTRATION_TYPE With APPLICATION_ID, FK to FND_REGISTRATION_TYPES, allowing multiple types of registration within a particular application
REQUESTED_USER_NAME Prospective USER_NAME for the user. Will be uppercased in the insert methods.
ASSIGNED_USER_NAME FK to FND_USER: Username which is used once the user is approved. These are uppercased before being stored in this table.
REGISTRATION_STATUS This is used to drive flow progression. Possible values are INVITED, REGISTERED, APPROVED, REJECTED
EXISTS_IN_FND_USER_FLAG Y if user does not need to be created in FND_USER again
Application Object Library - FND_REGISTRATION_DETAILS Table containing detailed and flex data for User Management Framework (UMF).
Column Name Descritpion
REGISTRATION_ID FK to FND_REGISTRATIONS
LAST_UPDATE_DATE Who field.
LAST_UPDATED_BY Who field.
CREATED_BY Who field.
CREATION_DATE Who field.
LAST_UPDATE_LOGIN Who field.
APPLICATION_ID FK to FND_APPLICATIONS, striping the data by the application for which the user is registering. Also part of the FK to FND_REGISTRATION_TYPES.
REGISTRATION_TYPE With APPLICATION_ID, FK to FND_REGISTRATION_TYPES, allowing multiple types of registration within a particular application.
FIELD_NAME This is the field name for the value stored in FIELD_VALUE
FIELD_TYPE The datatype for the data in FIELD_VALUE. This is so that data can be more clearly labeled as NUMBER, DATE, etc
FIELD_FORMAT This is an attribute column in case other data is required to fully model the data in FIELD_VALUE. E.g. for a DATE, this might by MM-DD-RRRR to specify a particular format the value is stored in the text field.
FIELD_VALUE_STRING String Data for the user
FIELD_VALUE_NUMBER Numeric Data for the user.
FIELD_VALUE_DATE Date Data for the user.
Application Object Library - FND_SVC_COMPONENTS Service Components
Column Name Descritpion
COMPONENT_NAME User-defined name for the Service Component. User interface may accept only 26 characters for this field
LAST_UPDATE_LOGIN Standard Who column
OBJECT_VERSION_NUMBER Object version number required for user interface
COMPONENT_STATUS Status of the Service Component. This is run-time data
COMPONENT_TYPE Service Component-Type of the Service Component
STARTUP_MODE Startup mode of the Service Component
CONTAINER_TYPE Source type for the Service Component Container
CUSTOMIZATION_LEVEL Specifies the extent to which the Service Component has been/can be customized
APPLICATION_ID If CONTAINER_TYPE column is 'GSM', this is the APPLICATION_ID column of FND_CONCURRENT_QUEUES
CONCURRENT_QUEUE_ID If CONTAINER_TYPE column is 'GSM', this is the CONCURRENT_QUEUE_ID of the FND_CONCURRENT_QUEUES_TABLE
COMPONENT_ID Identifier
STANDALONE_CONTAINER_NAME If CONTAINER_TYPE column is 'SERVLET', this is the name of Service Component Container
INBOUND_AGENT_NAME Inbound agent name for the Service Component
OUTBOUND_AGENT_NAME Outbound agent name for the Service Component
CORRELATION_ID Identifier of correlating entity, if any. User interface may accept only 128 characters for this field
MAX_IDLE_TIME If STARTUP_MODE column is 'ON_DEMAND', this is the maximum time in minutes that the Service Component can be idle before it is stopped
COMPONENT_STATUS_INFO Information regarding to the Service Component's status. This is run-time data
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_SVC_COMP_PARAMS_B Service Component Parameter Definitions
Column Name Descritpion
PARAMETER_NAME Name of the parameter definition
COMPONENT_TYPE Service Component-Type to which the parameter definition belongs
DEFAULT_PARAMETER_VALUE Default value for the parameter definition.User interface may accept only 665 characters for this field.
REQUIRED_FLAG Y or N. Signifies whether or not a value is required for the parameter
ALLOW_RELOAD_FLAG Y or N. Signifies whether or not the parameter's value can be refreshed at run-time
ENCRYPTED_FLAG Y or N. Signifies whether or not the parameter's value should be encrypted when storin
CUSTOMIZATION_LEVEL Specifies the extent to which the parameter definition has been/can be customized
CREATION_DATE Standard Who column
PARAMETER_ID Identifier
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
OBJECT_VERSION_NUMBER Object version number required for user interface
Application Object Library - FND_SVC_COMP_PARAMS_TL MLS table for the FND_SVC_COMP_PARAMS_B table
Column Name Descritpion
LANGUAGE Language to which things are translated
SOURCE_LANG Language from which things are translated
DISPLAY_NAME Language-dependent name for the parameter. User interface may accept only 26 characters for this field
DESCRIPTION Language-dependent description for the parameter. User interface may accept only 665 characters for this field
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
PARAMETER_ID Identifier for the Service Component parameter definition
LAST_UPDATE_LOGIN Standard Who column
Application Object Library - FND_SVC_COMP_PARAM_VALS Service Component Parameter Values
Column Name Descritpion
COMPONENT_ID Identifier for the Service Component for which the parameter value has been configured
PARAMETER_ID Identifier for the Service Component-Type parameter definition
PARAMETER_VALUE Value of the parameter. User interface may accept only 665 characters for this field
CUSTOMIZATION_LEVEL Specifies the extent to which the parameter value has been/can be customized
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
COMPONENT_PARAMETER_ID Identifier
LAST_UPDATE_LOGIN Standard Who column
OBJECT_VERSION_NUMBER Object version number required for user interface
Application Object Library - FND_SVC_COMP_REQUESTS_H Service Component Event Requests History
Column Name Descritpion
COMPONENT_ID Snapshot of COMPONENT_ID column in FND_SVC_COMPONENTS table
EVENT_NAME EVENT_NAME column in FND_SVC_COMP_REQUESTS table
REQUEST_STATUS Request completion status
REQUESTED_BY_USER REQUESTED_BY_USER column in FND_SVC_COMP_REQUESTS table
COMPLETION_DATE Request completion date
COMPONENT_NAME Snapshot of COMPONENT_NAME column in FND_SVC_COMPONENTS table
COMPONENT_STATUS Snapshot of COMPONENT_STATUS column in FND_SVC_COMPONENTS table
COMPONENT_TYPE Snapshot of COMPONENT_TYPE in FND_SVC_COMPONENTS table
REQUEST_HISTORY_ID Identifier
CONTAINER_TYPE Snapshot of CONTAINER_TYPE column in FND_SVC_COMPONENTS table
CONTAINER_NAME Snapshot of STANDALONE_CONTAINER_NAME column in FND_SVC_COMPONENTS table if CONTAINER_TYPE column is 'SERVLET' or CONCURRENT_QUEUE_NAME column in FND_CONCURRENT_QUEUES if CONTAINER_TYPE column is 'GSM'
EVENT_PARAMS EVENT_PARAMS column in FND_SVC_COMP_REQUESTS table
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
OBJECT_VERSION_NUMBER Object version number required for user interface
Application Object Library - FND_SVC_COMP_TYPES_TL MLS table for the FND_SVC_COMP_TYPES_B table
Column Name Descritpion
LANGUAGE Language to which things are translated
SOURCE_LANG Language from which things are translated
DISPLAY_NAME Language-dependent name for the Service Component-Type.User interface may accept only 26 characters for this field.
DESCRIPTION Language-dependent description for the Service Component-Type.User interface may accept only 665 characters for this field
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
COMPONENT_TYPE Identifier for the Service Component-Type
LAST_UPDATE_LOGIN Standard Who column
Application Object Library - FND_SVC_COMP_TYPES_B Service Component-Types
Column Name Descritpion
COMPONENT_CLASS_NAME Fully qualified Java class name of the Service Component
CONFIG_UI_REGION Name of page for configuring the Service Component-Type
CUSTOMIZATION_LEVEL Specifies the extent to which the Service Component-Type has been/can be customized
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
COMPONENT_TYPE Identifier
OBJECT_VERSION_NUMBER Object version number required for user interface
Application Object Library - FND_SVC_COMP_REQUESTS Scheduled Service Component Events
Column Name Descritpion
COMPONENT_ID Service Component for which the request has been scheduled
EVENT_NAME Name of the event that the request will raise
EVENT_DATE Time when the request should start
REQUESTED_BY_USER User who scheduled the request
JOB_ID Job Id for the submitted request; run-time data
EVENT_PARAMS Parameters for the request. User interface may accept only 665 characters for this field
EVENT_FREQUENCY Frequency in minutes that the request should execute
CREATION_DATE Standard Who column
COMPONENT_REQUEST_ID Identifier
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
OBJECT_VERSION_NUMBER Object version number required for user interface
Application Object Library - FND_OBJECT_TABLESPACES This table contains Tablespace classifications for Objects like Tables, Materialized Views based on their I/O characteristics
Column Name Descritpion
APPLICATION_ID The owning application of an object to be created
CREATION_DATE Standard who column
CREATED_BY Standard who column
LAST_UPDATE_LOGIN Standard who column
OBJECT_NAME Name of an object to be created
OBJECT_TYPE Type of the database object to be analyzed (TABLE, INDEX, or CLUSTER)
TABLESPACE_TYPE The correct tablespace type for this object
CUSTOM_TABLESPACE_TYPE This column will contain the customer updated tablespace_type
OBJECT_SOURCE Source of the object like seed database or sql scripts , Designer Repository
ORACLE_USERNAME The Oracle username from fnd_oracle_userid table
CUSTOM_FLAG 'Y' - it is a custom object being registered, null/'N' - standard Oracle object)
LAST_UPDATE_DATE Standard who column
LAST_UPDATED_BY Standard who column
Application Object Library - FND_TABLESPACES FND_TABLESPACES will map the logical to physical tablespace name
Column Name Descritpion
TABLESPACE The actual tablespace
CUSTOM_FLAG 'Y' - it is a custom object being registered, null/'N' - standard Oracle object)
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
TABLESPACE_TYPE The logical type
Application Object Library - FND_TS_SIZING This table contains sizing estimates for Objects/schemas
Column Name Descritpion
OBJECT_TYPE Type of the database object to be analyzed (TABLE, INDEX, or CLUSTER)
OBJECT_NAME Name of the object name to be analyzed
NEW_TABLESPACE Name of the new tablespace where object will resides
OLD_TABLESPACE Name of the tablespace from where table was moved
PARENT_OBJECT_NAME Parent of the object (table name for indexes)
CURRENT_EXTENTS Total number of extents in the object
CURRENT_BYTES Total number of extents in the object,expressed in bytes
FREE_BYTES No. of free btyes in object
OWNER schema name of the database object to be analyzed
USED_BYTES No. of used bytes in object
UNIFORM_EXTENT_SIZE Extent size for a given tablespace
NUMBER_OF_EXTENTS Total number of extents required for the object after migrating to new tablespace
TOTAL_BYTES_REQUIRED Total number of bytes required for the obejct after migrating to new tablespace
SIZING_ERROR_STATUS Error given by procedure dbms_space.unused_space(error/null)
ERROR_CODE Error message given by procedure dbms_space.unused_space
CLASSIFIED If Object classification available
PARTITIONED If object has partitions(yes/No)
CREATION_DATE generation date of the sizing
ALLOCATION_TYPE Stores the allocation type for extents
Application Object Library - FND_TS_MIG_CMDS This table contains the commands generated for migrating Objects from old tablesapce to new tablespace
Column Name Descritpion
OWNER schema name of the database object to be migrated
OBJECT_TYPE Type of the database object to be migrated(TABLE, INDEX, or CLUSTER)
OBJECT_NAME Name of the object name to be migrated
OBJECT_PARALLEL Object move with Parallel/No Parallel Clause
OLD_TABLESPACE Name of the tablespace from where table was moved
NEW_TABLESPACE Name of the new tablespace where object will resides
MIGRATION_CMD Text of the migration command
MIGRATION_STATUS Status of migraion (GENERATED, SUCCESS or ERROR)
ERROR_TEXT Oracle Error in case of migration error
LINENO Unique sequance
LAST_UPDATE_DATE Last update date
GENERATION_DATE Date/Time on which the migration command was generated
SUBOBJECT_TYPE This column will contain the sub object of the main object
END_DATE Date/Time of the completion of migration command execution
TOTAL_BLOCKS Size of the object in blocks
START_DATE Migration Start date
INDEX_PARALLEL Index move command having Parallel/No Parallel Clause
PARENT_OBJECT_NAME Name of the parent object name for the child objects
PARENT_LINENO Line no of the parent object
EXECUTION_MODE Execution Mode for the commands (s/p)
PARTITIONED Object partition (Yes/No)
PARENT_OWNER Parent owner name for child objects
Application Object Library - FND_TS_MIG_RULES FND_TS_MIG_RULES
Column Name Descritpion
RULE_QUERY The where clause of the rule
TABLESPACE_TYPE The foreign key to FND_TABLESPACES
OWNER Schema 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
RULE_ID Sequence Number
Application Object Library - FND_TS_PROD_INSTS FND_TS_PROD_INSTS
Column Name Descritpion
ORACLE_ID ORACLE Account in which the Application is installed
TABLESPACE Name of the Tablespace for the Application's tables
INDEX_TABLESPACE Name of the Tablespace for the Application's indexes
TEMPORARY_TABLESPACE Name of the Tablespace for Temporary Objects
APPLICATION_ID Application Identifier
Application Object Library - FND_PROFILE_CATS Stores Profile (Option) Categories
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
APPLICATION_ID Profile Categories
ENABLED ENABLED
NAME Profile Category Name
Application Object Library - FND_PROFILE_CATS_TL Translations for FND_PROFILE_CATS
Column Name Descritpion
NAME Category Name from FND_PROFILE_CATS
DISPLAY_NAME DISPLAY_NAME
APPLICATION_ID Profile Categories
LANGUAGE Language
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
DESCRIPTION Translated Category Name
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_PROFILE_CAT_OPTIONS Intersection table between FND_PROFILE_OPTIONS and FND_PROFILE_CATS
Column Name Descritpion
PROFILE_OPTION_APPLICATION_ID Profile Option Application Id from FND_PROFILE_OPTIONS
LAST_UPDATE_LOGIN Standard Who Column
APPLICATION_ID Profile Categories
PROFILE_OPTION_ID Profile Option Id from FND_PROFILE_OPTIONS
CATEGORY_NAME Category Name from FND_PROFILE_CATS
DISPLAY_SEQUENCE Display Sequence within the Category
DISPLAY_TYPE Display Type (Varchar2, Number, Date)
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_PROFILE_CAT_OPTIONS_TL Translations for FND_PROFILE_CAT_OPTIONS
Column Name Descritpion
PROFILE_OPTION_APPLICATION_ID Profile Option Application Id from FND_PROFILE_CAT_OPTIONS
DESCRIPTION_OVERRIDE Profile Option Name in this Catgeory Context. For Display Purposes this overrides the User Profile Option Name from FND_PROFILE_OPTIONS_TL
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.
PROFILE_OPTION_ID Profile Option Id from FND_PROFILE_CAT_OPTIONS
CATEGORY_NAME Category Name from FND_PROFILE_CAT_OPTIONS
LANGUAGE Language
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_PCOLL_CONTROL Maintains the list of the BC4J persistent collection storage tables
Column Name Descritpion
ROWCREATEDATE Timestamp of when this row was created in FND_PCOLL_CONTROL
CREATEDATE Timestamp of when the persistent collection storage table named in the TABNAME column was created
UPDATEDATE Timestamp of when the most recent persistent collection operation was performed successfully on the storage table named in TABNAME
TABNAME Name of the persistent collection storage table
Application Object Library - FND_PS_TXN Stores snapshots of pending changes made to BC4J application module instances
Column Name Descritpion
PARENTID ID colulmn value of the parent row
COLLID Unique ID associated with a particular BC4J application module instance for its persistent collection (snapshot)
CONTENT Snapshot of pending changes made to a BC4J application module instance
CREATION_DATE Timestamp of when this row was created
ID Unique ID for a row created for a particular COLLID
Application Object Library - FND_SEED_STAGE_CONFIG_DEBUG
Column Name Descritpion
PROC_ID
PK_VAR_CNT
BIND_VAR88
BIND_VAR89
BIND_VAR90
BIND_VAR91
BIND_VAR92
BIND_VAR93
BIND_VAR94
BIND_VAR95
BIND_VAR96
BIND_VAR97
ENTITY_METADATA
BIND_VAR98
BIND_VAR99
BIND_VAR100
BIND_VAR101
BIND_VAR102
BIND_VAR103
BIND_VAR104
BIND_VAR105
BIND_VAR106
BIND_VAR107
BIND_VAR0
BIND_VAR108
BIND_VAR109
BIND_VAR110
BIND_VAR111
BIND_VAR112
BIND_VAR113
BIND_VAR114
BIND_VAR115
BIND_VAR116
BIND_VAR117
BIND_VAR1
BIND_VAR118
BIND_VAR119
BIND_VAR120
BIND_VAR121
BIND_VAR122
BIND_VAR123
BIND_VAR124
BIND_VAR125
BIND_VAR126
BIND_VAR127
BIND_VAR2
BIND_VAR128
BIND_VAR129
BIND_VAR130
BIND_VAR131
BIND_VAR132
BIND_VAR133
BIND_VAR134
BIND_VAR135
BIND_VAR136
BIND_VAR137
BIND_VAR3
BIND_VAR138
BIND_VAR139
BIND_VAR140
BIND_VAR141
BIND_VAR142
BIND_VAR143
BIND_VAR144
BIND_VAR145
BIND_VAR146
BIND_VAR147
BIND_VAR4
BIND_VAR148
BIND_VAR149
BIND_VAR150
BIND_VAR151
BIND_VAR152
BIND_VAR153
BIND_VAR154
BIND_VAR155
BIND_VAR156
BIND_VAR157
BIND_VAR5
BIND_VAR158
BIND_VAR159
BIND_VAR160
BIND_VAR161
BIND_VAR162
BIND_VAR163
BIND_VAR164
BIND_VAR165
BIND_VAR166
BIND_VAR167
BIND_VAR6
BIND_VAR168
BIND_VAR169
BIND_VAR170
BIND_VAR171
BIND_VAR172
BIND_VAR173
BIND_VAR174
BIND_VAR175
BIND_VAR176
BIND_VAR177
BIND_VAR7
BIND_VAR178
BIND_VAR179
BIND_VAR180
BIND_VAR181
BIND_VAR182
BIND_VAR183
BIND_VAR184
BIND_VAR185
BIND_VAR186
BIND_VAR187
CONFIG_ID
BIND_VAR8
BIND_VAR188
BIND_VAR189
BIND_VAR190
BIND_VAR191
BIND_VAR192
BIND_VAR193
BIND_VAR194
BIND_VAR195
BIND_VAR196
BIND_VAR197
BIND_VAR9
BIND_VAR198
BIND_VAR199
BIND_VAR200
BIND_VAR201
BIND_VAR202
BIND_VAR203
BIND_VAR204
BIND_VAR205
BIND_VAR206
BIND_VAR207
BIND_VAR10
BIND_VAR208
BIND_VAR209
BIND_VAR210
BIND_VAR211
BIND_VAR212
BIND_VAR213
BIND_VAR214
BIND_VAR215
BIND_VAR216
BIND_VAR217
BIND_VAR11
BIND_VAR218
BIND_VAR219
BIND_VAR220
BIND_VAR221
BIND_VAR222
BIND_VAR223
BIND_VAR224
BIND_VAR225
BIND_VAR226
BIND_VAR227
BIND_VAR12
BIND_VAR228
BIND_VAR229
BIND_VAR230
BIND_VAR231
BIND_VAR232
BIND_VAR233
BIND_VAR234
BIND_VAR235
BIND_VAR236
BIND_VAR237
BIND_VAR13
BIND_VAR238
BIND_VAR239
BIND_VAR240
BIND_VAR241
BIND_VAR242
BIND_VAR243
BIND_VAR244
BIND_VAR245
BIND_VAR246
BIND_VAR247
BIND_VAR14
BIND_VAR248
BIND_VAR249
BIND_VAR250
BIND_VAR251
BIND_VAR252
BIND_VAR253
BIND_VAR254
BIND_VAR255
BIND_VAR256
BIND_VAR257
BIND_VAR15
BIND_VAR258
BIND_VAR259
BIND_VAR260
BIND_VAR261
BIND_VAR262
BIND_VAR263
BIND_VAR264
BIND_VAR265
BIND_VAR266
BIND_VAR267
BIND_VAR16
BIND_VAR268
BIND_VAR269
BIND_VAR270
BIND_VAR271
BIND_VAR272
BIND_VAR273
BIND_VAR274
BIND_VAR275
BIND_VAR276
BIND_VAR277
BIND_VAR17
BIND_VAR278
BIND_VAR279
BIND_VAR280
BIND_VAR281
BIND_VAR282
BIND_VAR283
BIND_VAR284
BIND_VAR285
BIND_VAR286
BIND_VAR287
LCT_FILE
BIND_VAR18
BIND_VAR288
BIND_VAR289
BIND_VAR290
BIND_VAR291
BIND_VAR292
BIND_VAR293
BIND_VAR294
BIND_VAR295
BIND_VAR296
BIND_VAR297
BIND_VAR19
BIND_VAR298
BIND_VAR299
BIND_VAR300
BIND_VAR20
BIND_VAR21
BIND_VAR22
BIND_VAR23
BIND_VAR24
BIND_VAR25
BIND_VAR26
BIND_VAR27
ENTITY_NAME
BIND_VAR28
BIND_VAR29
BIND_VAR30
BIND_VAR31
BIND_VAR32
BIND_VAR33
BIND_VAR34
BIND_VAR35
BIND_VAR36
BIND_VAR37
STMT_TYPE
BIND_VAR38
BIND_VAR39
BIND_VAR40
BIND_VAR41
BIND_VAR42
BIND_VAR43
BIND_VAR44
BIND_VAR45
BIND_VAR46
BIND_VAR47
STMT_LEN
BIND_VAR48
BIND_VAR49
BIND_VAR50
BIND_VAR51
BIND_VAR52
BIND_VAR53
BIND_VAR54
BIND_VAR55
BIND_VAR56
BIND_VAR57
UPLOAD_STMT
BIND_VAR58
BIND_VAR59
BIND_VAR60
BIND_VAR61
BIND_VAR62
BIND_VAR63
BIND_VAR64
BIND_VAR65
BIND_VAR66
BIND_VAR67
GET_WHO_STMT
BIND_VAR68
BIND_VAR69
BIND_VAR70
BIND_VAR71
BIND_VAR72
BIND_VAR73
BIND_VAR74
BIND_VAR75
BIND_VAR76
BIND_VAR77
BIND_VAR_CNT
BIND_VAR78
BIND_VAR79
BIND_VAR80
BIND_VAR81
BIND_VAR82
BIND_VAR83
BIND_VAR84
BIND_VAR85
BIND_VAR86
BIND_VAR87
Application Object Library - FND_SEED_STAGE_ENTITY_DEBUG
Column Name Descritpion
SEQ
EXEC_STATUS
BIND_VALUE87
BIND_VALUE88
BIND_VALUE89
BIND_VALUE90
BIND_VALUE91
BIND_VALUE92
BIND_VALUE93
BIND_VALUE94
BIND_VALUE95
BIND_VALUE96
BIND_VAR_METADATA
BIND_VALUE97
BIND_VALUE98
BIND_VALUE99
BIND_VALUE100
BIND_VALUE101
BIND_VALUE102
BIND_VALUE103
BIND_VALUE104
BIND_VALUE105
BIND_VALUE106
PARENT_PK_VALUE
BIND_VALUE107
BIND_VALUE108
BIND_VALUE109
BIND_VALUE110
BIND_VALUE111
BIND_VALUE112
BIND_VALUE113
BIND_VALUE114
BIND_VALUE115
BIND_VALUE116
BIND_VALUE0
BIND_VALUE117
BIND_VALUE118
BIND_VALUE119
BIND_VALUE120
BIND_VALUE121
BIND_VALUE122
BIND_VALUE123
BIND_VALUE124
BIND_VALUE125
BIND_VALUE126
BIND_VALUE1
BIND_VALUE127
BIND_VALUE128
BIND_VALUE129
BIND_VALUE130
BIND_VALUE131
BIND_VALUE132
BIND_VALUE133
BIND_VALUE134
BIND_VALUE135
BIND_VALUE136
BIND_VALUE2
BIND_VALUE137
BIND_VALUE138
BIND_VALUE139
BIND_VALUE140
BIND_VALUE141
BIND_VALUE142
BIND_VALUE143
BIND_VALUE144
BIND_VALUE145
BIND_VALUE146
BIND_VALUE3
BIND_VALUE147
BIND_VALUE148
BIND_VALUE149
BIND_VALUE150
BIND_VALUE151
BIND_VALUE152
BIND_VALUE153
BIND_VALUE154
BIND_VALUE155
BIND_VALUE156
BIND_VALUE4
BIND_VALUE157
BIND_VALUE158
BIND_VALUE159
BIND_VALUE160
BIND_VALUE161
BIND_VALUE162
BIND_VALUE163
BIND_VALUE164
BIND_VALUE165
BIND_VALUE166
BIND_VALUE5
BIND_VALUE167
BIND_VALUE168
BIND_VALUE169
BIND_VALUE170
BIND_VALUE171
BIND_VALUE172
BIND_VALUE173
BIND_VALUE174
BIND_VALUE175
BIND_VALUE176
BIND_VALUE6
BIND_VALUE177
BIND_VALUE178
BIND_VALUE179
BIND_VALUE180
BIND_VALUE181
BIND_VALUE182
BIND_VALUE183
BIND_VALUE184
BIND_VALUE185
BIND_VALUE186
CONFIG_ID
BIND_VALUE7
BIND_VALUE187
BIND_VALUE188
BIND_VALUE189
BIND_VALUE190
BIND_VALUE191
BIND_VALUE192
BIND_VALUE193
BIND_VALUE194
BIND_VALUE195
BIND_VALUE196
BIND_VALUE8
BIND_VALUE197
BIND_VALUE198
BIND_VALUE199
BIND_VALUE200
BIND_VALUE201
BIND_VALUE202
BIND_VALUE203
BIND_VALUE204
BIND_VALUE205
BIND_VALUE206
BIND_VALUE9
BIND_VALUE207
BIND_VALUE208
BIND_VALUE209
BIND_VALUE210
BIND_VALUE211
BIND_VALUE212
BIND_VALUE213
BIND_VALUE214
BIND_VALUE215
BIND_VALUE216
BIND_VALUE10
BIND_VALUE217
BIND_VALUE218
BIND_VALUE219
BIND_VALUE220
BIND_VALUE221
BIND_VALUE222
BIND_VALUE223
BIND_VALUE224
BIND_VALUE225
BIND_VALUE226
BIND_VALUE11
BIND_VALUE227
BIND_VALUE228
BIND_VALUE229
BIND_VALUE230
BIND_VALUE231
BIND_VALUE232
BIND_VALUE233
BIND_VALUE234
BIND_VALUE235
BIND_VALUE236
BIND_VALUE12
BIND_VALUE237
BIND_VALUE238
BIND_VALUE239
BIND_VALUE240
BIND_VALUE241
BIND_VALUE242
BIND_VALUE243
BIND_VALUE244
BIND_VALUE245
BIND_VALUE246
BIND_VALUE13
BIND_VALUE247
BIND_VALUE248
BIND_VALUE249
BIND_VALUE250
BIND_VALUE251
BIND_VALUE252
BIND_VALUE253
BIND_VALUE254
BIND_VALUE255
BIND_VALUE256
BIND_VALUE14
BIND_VALUE257
BIND_VALUE258
BIND_VALUE259
BIND_VALUE260
BIND_VALUE261
BIND_VALUE262
BIND_VALUE263
BIND_VALUE264
BIND_VALUE265
BIND_VALUE266
BIND_VALUE15
BIND_VALUE267
BIND_VALUE268
BIND_VALUE269
BIND_VALUE270
BIND_VALUE271
BIND_VALUE272
BIND_VALUE273
BIND_VALUE274
BIND_VALUE275
BIND_VALUE276
BIND_VALUE16
BIND_VALUE277
BIND_VALUE278
BIND_VALUE279
BIND_VALUE280
BIND_VALUE281
BIND_VALUE282
BIND_VALUE283
BIND_VALUE284
BIND_VALUE285
BIND_VALUE286
TOP_ENTITY_SEQ
BIND_VALUE17
BIND_VALUE287
BIND_VALUE288
BIND_VALUE289
BIND_VALUE290
BIND_VALUE291
BIND_VALUE292
BIND_VALUE293
BIND_VALUE294
BIND_VALUE295
BIND_VALUE296
BIND_VALUE18
BIND_VALUE297
BIND_VALUE298
BIND_VALUE299
BIND_VALUE300
BIND_VALUE19
BIND_VALUE20
BIND_VALUE21
BIND_VALUE22
BIND_VALUE23
BIND_VALUE24
BIND_VALUE25
BIND_VALUE26
LAST_DB_UPDATED_BY
BIND_VALUE27
BIND_VALUE28
BIND_VALUE29
BIND_VALUE30
BIND_VALUE31
BIND_VALUE32
BIND_VALUE33
BIND_VALUE34
BIND_VALUE35
BIND_VALUE36
LAST_DB_UPDATE_DATE
BIND_VALUE37
BIND_VALUE38
BIND_VALUE39
BIND_VALUE40
BIND_VALUE41
BIND_VALUE42
BIND_VALUE43
BIND_VALUE44
BIND_VALUE45
BIND_VALUE46
LAST_FILE_UPDATED_BY
BIND_VALUE47
BIND_VALUE48
BIND_VALUE49
BIND_VALUE50
BIND_VALUE51
BIND_VALUE52
BIND_VALUE53
BIND_VALUE54
BIND_VALUE55
BIND_VALUE56
LAST_FILE_UPDATE_DATE
BIND_VALUE57
BIND_VALUE58
BIND_VALUE59
BIND_VALUE60
BIND_VALUE61
BIND_VALUE62
BIND_VALUE63
BIND_VALUE64
BIND_VALUE65
BIND_VALUE66
ACTION
BIND_VALUE67
BIND_VALUE68
BIND_VALUE69
BIND_VALUE70
BIND_VALUE71
BIND_VALUE72
BIND_VALUE73
BIND_VALUE74
BIND_VALUE75
BIND_VALUE76
COMMIT_FLAG
BIND_VALUE77
BIND_VALUE78
BIND_VALUE79
BIND_VALUE80
BIND_VALUE81
BIND_VALUE82
BIND_VALUE83
BIND_VALUE84
BIND_VALUE85
BIND_VALUE86
Application Object Library - FND_PRIVACY_ATTRIBUTE_CHILDREN
Column Name Descritpion
PARENT_ATTRIBUTE_CODE
ATTRIBUTE_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
SECURITY_GROUP_ID
Application Object Library - FND_OAM_RESTR_MODES Scheduled Downtime Information
Column Name Descritpion
RESTR_MODE_ID
WARNING_MSG
WARNING_MSG_NAME
DOWNTIME_MSG
DOWNTIME_MSG_NAME
NOTES
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
NAME
STATUS
WARNING_START_DATE
START_DATE
EXPECTED_END_DATE
ACTUAL_END_DATE
CONTACT_INFO
STATUS_URL
Application Object Library - FND_PRIVACY_ATTRIBUTES_B
Column Name Descritpion
PRIVACY_ATTRIBUTE_CODE
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
PRIVACY_ATTRIBUTE_TYPE
ATTRIBUTE15
ATTRIBUTE_CATEGORY
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
SECURITY_GROUP_ID
DSCRAM_LEVEL
SENSITIVITY
DSCRAM_ALGO_ID
PII_FLAG
LOCKED_FLAG
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
Application Object Library - FND_PURPOSE_ATTRIBUTES
Column Name Descritpion
PURPOSE_ATTRIBUTE_ID
OBJECT_VERSION_NUMBER
SECURITY_GROUP_ID
PRIVACY_ATTRIBUTE_CODE
PURPOSE_CODE
ATTRIBUTE_DEFAULT_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
Application Object Library - FND_PRIVACY_ATTRIBUTES_TL
Column Name Descritpion
PRIVACY_ATTRIBUTE_CODE
LANGUAGE
SOURCE_LANG
SECURITY_GROUP_ID
PRIVACY_ATTRIBUTE_NAME
DESCRIPTION
DESCRIPTION_INT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
Application Object Library - FND_PARAMETERS Integration Repository method parameters
Column Name Descritpion
FUNCTION_ID Owning Method
DESCRIPTION Description
DEFAULT_VALUE Default Value
DISPLAYED_FLAG Is this Parameter Displayed under Standard Report Submission (only relevent for Concurrent Programs)?
FN_OVERLOAD_SEQUENCE Function Overload Sequence
PARAM_SEQUENCE Sequence
INNERTYPE_SEQUENCE Innertype Sequence
PARAM_NAME Parameter Name
PARAM_DIRECTION Parameter Direction
PARAM_OPTIONAL Optional Flag
PARAMETER_TYPE Parameter Type
PARAM_PRECISION Precision
NULL_ALLOWED Null Allowed Flag
Application Object Library - FND_TNS_LISTENERS FND_TNS_LISTENERS table tracks the TNS Listeners
Column Name Descritpion
LISTENER_GUID Unique ID for this row, since the unique key Host+Port may change. (In particular, the port may change.)
LAST_UPDATE_LOGIN Standard "who" column
SERVER_GUID SERVER_GUID
TNS_ALIAS_GUID TNS_ALIAS_GUID
LISTENER_NAME Each listener has a name, however, this is not forced to be unique outside of an ORACLE_HOME. In fact, AutoConfig will name all Apps RPC listeners in a given system the same: "APPS_%s_dbsid%". So, listener_name should not be used as a key
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_TNS_ALIAS_ADDRESSES This table points to the listeners for a specific TNS alias
Column Name Descritpion
LISTENER_PORT_GUID Every alias points to a listener that determines the address (host, port) to be contacted.
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
TNS_ALIAS_ADDRESS_LIST_GUID TNS Alias address list id
Application Object Library - FND_TNS_ALIASES FND_TNS_ALIASES will be used by AutoConfig for building the tnsnames.ora
Column Name Descritpion
TNS_ALIAS_GUID Unique ID for this row, since the name may change on cloning
LAST_UPDATED_BY Standard who column
LAST_UPDATE_DATE Standard who column
LAST_UPDATE_LOGIN Standard who column
ALIAS_SET_GUID Every TNS alias is a member of one alias set.Alias sets are then assigned to servers.The tnsnames.ora for a given server is generated as the union of all alias sets assigned to that server.This is a key into fnd_tns_alias_sets.
ALIAS_TYPE Used for grouping. Example types could include FNDFS, FNDSM, DB_LOAD_BAL, DB_INST, etc.
ALIAS_NAME This is the name used in the tnsnames.ora file
FAILOVER ON or OFF. Controls clinet-side connection failover
LOAD_BALANCE ON or OFF. Controls client-side (i.e. random) connection load balancing across the addresses in the address list.
CREATED_BY Standard who column
CREATION_DATE Standard who column
Application Object Library - FND_SIDS This table registers the SIDs in use on the system.
Column Name Descritpion
SID_GUID Primary Key
SID SID
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_ORACLE_HOMES This table tracks ORACLE_HOME mount points
Column Name Descritpion
ORACLE_HOME_ID Generated unique ID for the mount point
LAST_UPDATE_DATE Last_Update_Date
LAST_UPDATE_LOGIN Last_Update_Login
NAME Internal name of the
PATH Full path to ORACLE_HOME mount point
NODE_ID Node of mount point
VERSION ORACLE_HOME version. (e.g. 8.1.6)
CREATED Date row was created
DESCRIPTION Description
FILE_SYSTEM_GUID This is a stamp that is written into a central directory in the ORACLE_HOME by Rapid Install. This allows us to identify that two APPL_TOPs found on two different nodes are the same shared file system
CREATED_BY Created_By
CREATION_DATE Creation_Date
LAST_UPDATED_BY Last_Updated_By
Application Object Library - FND_OAM_SVCI_INFO Information related to Service Instances monitored by OAM Dashboard Collection Program.
Column Name Descritpion
CONCURRENT_QUEUE_NAME Concurrent queue name for the service instance
ALERT_ENABLED_FLAG Y/N - Whether or not to raise an alert if this service instance is detected to be down
COLLECTION_ENABLED_FLAG Y/N - Whether or not status value should be computed for this service instance
THRESHOLD_VALUE Comma delimited list of status codes for which an alert should be raised
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 ID for the service instance
LAST_UPDATE_LOGIN Standard Who Column
Application Object Library - FND_TNS_ALIAS_DESCRIPTIONS A TNS Alias will have a description list that contains one or more connection descriptions. The FND_TNS_ALIAS_DESCRIPTIONS table contains information needed to construct the descriptions for a given alias
Column Name Descritpion
TNS_ALIAS_GUID Key into fnd_tns_aliases
SEQUENCE_NUMBER Determines order in the alias description list
FAILOVER ON or OFF. Controls clinet-side connection failover
LOAD_BALANCE ON or OFF. Controls client-side (i.e random) connection load balancing across the addresses in the address list
DB_SERVICE_GUID Database Service id
DB_INSTANCE_GUID Database Instance id
CREATION_DATE Standard who column for Apps
CREATED_BY Standard who column for Apps
TNS_ALIAS_DESCRIPTION_GUID Unique ID for this row
LAST_UPDATE_DATE Standard who column for Apps
LAST_UPDATED_BY Standard who column for Apps
LAST_UPDATE_LOGIN Standard who column
SERVICE_NAME Service Name
INSTANCE_NAME Instance name
Application Object Library - FND_TNS_ALIAS_ADDRESS_LISTS Each description in the description list for a TNS alias will have one or more address lists. This table contains the information needed to construct those address lists.
Column Name Descritpion
TNS_ALIAS_DESCRIPTION_GUID Key into fnd_tns_alias_descriptions
FAILOVER ON or OFF. Controls clinet-side connection failover
LOAD_BALANCE ON or OFF. Controls client-side(i.e. random) connection load balancing across the addresses in the address list
CREATION_DATE Standard who column for Apps
CREATED_BY Standard who column for Apps
LAST_UPDATE_DATE Standard who column for Apps
LAST_UPDATED_BY Standard who column
LAST_UPDATE_LOGIN Standard who column
TNS_ALIAS_ADDRESS_LIST_GUID Unique ID for this row
SEQUENCE_NUMBER Sequence_Number
Application Object Library - FND_SYSTEM_SERVER_MAP This table is included only for reference at this point. It is not needed since only one system is currently modeled in the Apps DB.However, if two or more systems are modeled, then this table will be needed to identify which systems us
Column Name Descritpion
SERVER_GUID Points to the server used by the system
CREATION_DATE Standard who column for Apps
CREATED_BY Standard who column for Apps
LAST_UPDATE_DATE Standard who column for Apps
LAST_UPDATED_BY Standard who column for Apps
LAST_UPDATE_LOGIN Standard who column
SYSTEM_GUID Points to the Apps system that uses the server
Application Object Library - FND_TNS_LISTENER_PORTS Each TNS listener may have multiple ports. Those ports are tracked here.
Column Name Descritpion
LISTENER_GUID Key into fnd_tns_listeners.
PROTOCOL Port protocol (TCP, TCPS, etc.)
PORT Listener port.
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.
LISTENER_PORT_GUID Unique identifier for this row.
Application Object Library - FND_TNS_ALIAS_SET_USAGE FND_TNS_ALIAS_SET_USAGE
Column Name Descritpion
SERVER_GUID Key into fnd_servers
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.
TNS_ALIAS_SET_GUID Key into fnd_tns_alias_sets
Application Object Library - FND_TNS_ALIAS_SETS FND_TNS_ALIAS_SETS
Column Name Descritpion
TNS_ALIAS_SET_GUID Unique Identifier for this row
TNS_ALIAS_SET_NAME Unique name for this set
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
TNS_ALIAS_SET_TYPE P ublic / I nternal
Application Object Library - FND_RANDOM_STATES This table stores the state information used by the secure pseudo random number generator
Column Name Descritpion
LAST_SEQUENCE Value of the sequence the last time the key was updated
POOL14 entropy pool14
POOL15 entropy pool15
POOL16 entropy pool16
POOL17 entropy pool17
POOL18 entropy pool18
POOL19 entropy pool19
POOL20 entropy pool20
POOL21 entropy pool21
POOL22 entropy pool22
POOL23 entropy pool23
RESEED_COUNTER How many reseed operations have been done to the key
POOL24 entropy pool24
POOL25 entropy pool25
POOL26 entropy pool26
POOL27 entropy pool27
POOL28 entropy pool28
POOL29 entropy pool29
POOL30 entropy pool30
POOL31 entropy pool31
EVENT_COUNT Number of entropy events that have been added to the pool since the last reseed operation
RANDOM_KEY A random key that is part of the internal state of the random number generator
POOL0 entropy pool0
POOL1 entropy pool1
POOL2 entropy pool2
POOL3 entropy pool3
LOCK_ID PRNG id
POOL4 entropy pool4
POOL5 entropy pool5
POOL6 entropy pool6
POOL7 entropy pool7
POOL8 entropy pool8
POOL9 entropy pool9
POOL10 entropy pool10
POOL11 entropy pool11
POOL12 entropy pool12
POOL13 entropy pool13
Application Object Library - FND_OBJECT_TYPE_MEMBERS Type members for Integration Repository shaped data
Column Name Descritpion
OBJECT_ID Pointer to owning object
MEMBER_NAME Member Name
MEMBER_SEQUENCE Sequence
INNERTYPE_SEQUENCE Innertype sequence
MEMBER_TYPE Member Type
MEMBER_PRECISION Precision
NULL_ALLOWED NUll allowed flag
DESCRIPTION Description
Application Object Library - FND_SEED_STAGE_CONFIG FND_SEED_STAGE_CONFIG
Column Name Descritpion
CONFIG_ID CONFIG_ID
ENTITY_METADATA ENTITY_METADATA
BIND_VAR89 BIND_VAR89
BIND_VAR90 BIND_VAR90
BIND_VAR91 BIND_VAR91
BIND_VAR92 BIND_VAR92
BIND_VAR93 BIND_VAR93
BIND_VAR94 BIND_VAR94
BIND_VAR95 BIND_VAR95
BIND_VAR96 BIND_VAR96
BIND_VAR97 BIND_VAR97
BIND_VAR98 BIND_VAR98
BIND_VAR0 BIND_VAR0
BIND_VAR99 BIND_VAR99
BIND_VAR100 BIND_VAR100
BIND_VAR101 BIND_VAR101
BIND_VAR102 BIND_VAR102
BIND_VAR103 BIND_VAR103
BIND_VAR104 BIND_VAR104
BIND_VAR105 BIND_VAR105
BIND_VAR106 BIND_VAR106
BIND_VAR107 BIND_VAR107
BIND_VAR108 BIND_VAR108
BIND_VAR1 BIND_VAR1
BIND_VAR109 BIND_VAR109
BIND_VAR110 BIND_VAR110
BIND_VAR111 BIND_VAR111
BIND_VAR112 BIND_VAR112
BIND_VAR113 BIND_VAR113
BIND_VAR114 BIND_VAR114
BIND_VAR115 BIND_VAR115
BIND_VAR116 BIND_VAR116
BIND_VAR117 BIND_VAR117
BIND_VAR118 BIND_VAR118
BIND_VAR2 BIND_VAR2
BIND_VAR119 BIND_VAR119
BIND_VAR120 BIND_VAR120
BIND_VAR121 BIND_VAR121
BIND_VAR122 BIND_VAR122
BIND_VAR123 BIND_VAR123
BIND_VAR124 BIND_VAR124
BIND_VAR125 BIND_VAR125
BIND_VAR126 BIND_VAR126
BIND_VAR127 BIND_VAR127
BIND_VAR128 BIND_VAR128
BIND_VAR3 BIND_VAR3
BIND_VAR129 BIND_VAR129
BIND_VAR130 BIND_VAR130
BIND_VAR131 BIND_VAR131
BIND_VAR132 BIND_VAR132
BIND_VAR133 BIND_VAR133
BIND_VAR134 BIND_VAR134
BIND_VAR135 BIND_VAR135
BIND_VAR136 BIND_VAR136
BIND_VAR137 BIND_VAR137
BIND_VAR138 BIND_VAR138
BIND_VAR4 BIND_VAR4
BIND_VAR139 BIND_VAR139
BIND_VAR140 BIND_VAR140
BIND_VAR141 BIND_VAR141
BIND_VAR142 BIND_VAR142
BIND_VAR143 BIND_VAR143
BIND_VAR144 BIND_VAR144
BIND_VAR145 BIND_VAR145
BIND_VAR146 BIND_VAR146
BIND_VAR147 BIND_VAR147
BIND_VAR148 BIND_VAR148
BIND_VAR5 BIND_VAR5
BIND_VAR149 BIND_VAR149
BIND_VAR150 BIND_VAR150
BIND_VAR151 BIND_VAR151
BIND_VAR152 BIND_VAR152
BIND_VAR153 BIND_VAR153
BIND_VAR154 BIND_VAR154
BIND_VAR155 BIND_VAR155
BIND_VAR156 BIND_VAR156
BIND_VAR157 BIND_VAR157
BIND_VAR158 BIND_VAR158
BIND_VAR6 BIND_VAR6
BIND_VAR159 BIND_VAR159
BIND_VAR160 BIND_VAR160
BIND_VAR161 BIND_VAR161
BIND_VAR162 BIND_VAR162
BIND_VAR163 BIND_VAR163
BIND_VAR164 BIND_VAR164
BIND_VAR165 BIND_VAR165
BIND_VAR166 BIND_VAR166
BIND_VAR167 BIND_VAR167
BIND_VAR168 BIND_VAR168
BIND_VAR7 BIND_VAR7
BIND_VAR169 BIND_VAR169
BIND_VAR170 BIND_VAR170
BIND_VAR171 BIND_VAR171
BIND_VAR172 BIND_VAR172
BIND_VAR173 BIND_VAR173
BIND_VAR174 BIND_VAR174
BIND_VAR175 BIND_VAR175
BIND_VAR176 BIND_VAR176
BIND_VAR177 BIND_VAR177
BIND_VAR178 BIND_VAR178
BIND_VAR8 BIND_VAR8
BIND_VAR179 BIND_VAR179
BIND_VAR180 BIND_VAR180
BIND_VAR181 BIND_VAR181
BIND_VAR182 BIND_VAR182
BIND_VAR183 BIND_VAR183
BIND_VAR184 BIND_VAR184
BIND_VAR185 BIND_VAR185
BIND_VAR186 BIND_VAR186
BIND_VAR187 BIND_VAR187
BIND_VAR188 BIND_VAR188
LCT_FILE LCT_FILE
BIND_VAR9 BIND_VAR9
BIND_VAR189 BIND_VAR189
BIND_VAR190 BIND_VAR190
BIND_VAR191 BIND_VAR191
BIND_VAR192 BIND_VAR192
BIND_VAR193 BIND_VAR193
BIND_VAR194 BIND_VAR194
BIND_VAR195 BIND_VAR195
BIND_VAR196 BIND_VAR196
BIND_VAR197 BIND_VAR197
BIND_VAR198 BIND_VAR198
BIND_VAR10 BIND_VAR10
BIND_VAR199 BIND_VAR199
BIND_VAR200 BIND_VAR200
BIND_VAR201 BIND_VAR201
BIND_VAR202 BIND_VAR202
BIND_VAR203 BIND_VAR203
BIND_VAR204 BIND_VAR204
BIND_VAR205 BIND_VAR205
BIND_VAR206 BIND_VAR206
BIND_VAR207 BIND_VAR207
BIND_VAR208 BIND_VAR208
BIND_VAR11 BIND_VAR11
BIND_VAR209 BIND_VAR209
BIND_VAR210 BIND_VAR210
BIND_VAR211 BIND_VAR211
BIND_VAR212 BIND_VAR212
BIND_VAR213 BIND_VAR213
BIND_VAR214 BIND_VAR214
BIND_VAR215 BIND_VAR215
BIND_VAR216 BIND_VAR216
BIND_VAR217 BIND_VAR217
BIND_VAR218 BIND_VAR218
BIND_VAR12 BIND_VAR12
BIND_VAR219 BIND_VAR219
BIND_VAR220 BIND_VAR220
BIND_VAR221 BIND_VAR221
BIND_VAR222 BIND_VAR222
BIND_VAR223 BIND_VAR223
BIND_VAR224 BIND_VAR224
BIND_VAR225 BIND_VAR225
BIND_VAR226 BIND_VAR226
BIND_VAR227 BIND_VAR227
BIND_VAR228 BIND_VAR228
BIND_VAR13 BIND_VAR13
BIND_VAR229 BIND_VAR229
BIND_VAR230 BIND_VAR230
BIND_VAR231 BIND_VAR231
BIND_VAR232 BIND_VAR232
BIND_VAR233 BIND_VAR233
BIND_VAR234 BIND_VAR234
BIND_VAR235 BIND_VAR235
BIND_VAR236 BIND_VAR236
BIND_VAR237 BIND_VAR237
BIND_VAR238 BIND_VAR238
BIND_VAR14 BIND_VAR14
BIND_VAR239 BIND_VAR239
BIND_VAR240 BIND_VAR240
BIND_VAR241 BIND_VAR241
BIND_VAR242 BIND_VAR242
BIND_VAR243 BIND_VAR243
BIND_VAR244 BIND_VAR244
BIND_VAR245 BIND_VAR245
BIND_VAR246 BIND_VAR246
BIND_VAR247 BIND_VAR247
BIND_VAR248 BIND_VAR248
BIND_VAR15 BIND_VAR15
BIND_VAR249 BIND_VAR249
BIND_VAR250 BIND_VAR250
BIND_VAR251 BIND_VAR251
BIND_VAR252 BIND_VAR252
BIND_VAR253 BIND_VAR253
BIND_VAR254 BIND_VAR254
BIND_VAR255 BIND_VAR255
BIND_VAR256 BIND_VAR256
BIND_VAR257 BIND_VAR257
BIND_VAR258 BIND_VAR258
BIND_VAR16 BIND_VAR16
BIND_VAR259 BIND_VAR259
BIND_VAR260 BIND_VAR260
BIND_VAR261 BIND_VAR261
BIND_VAR262 BIND_VAR262
BIND_VAR263 BIND_VAR263
BIND_VAR264 BIND_VAR264
BIND_VAR265 BIND_VAR265
BIND_VAR266 BIND_VAR266
BIND_VAR267 BIND_VAR267
BIND_VAR268 BIND_VAR268
BIND_VAR17 BIND_VAR17
BIND_VAR269 BIND_VAR269
BIND_VAR270 BIND_VAR270
BIND_VAR271 BIND_VAR271
BIND_VAR272 BIND_VAR272
BIND_VAR273 BIND_VAR273
BIND_VAR274 BIND_VAR274
BIND_VAR275 BIND_VAR275
BIND_VAR276 BIND_VAR276
BIND_VAR277 BIND_VAR277
BIND_VAR278 BIND_VAR278
BIND_VAR18 BIND_VAR18
BIND_VAR279 BIND_VAR279
BIND_VAR280 BIND_VAR280
BIND_VAR281 BIND_VAR281
BIND_VAR282 BIND_VAR282
BIND_VAR283 BIND_VAR283
BIND_VAR284 BIND_VAR284
BIND_VAR285 BIND_VAR285
BIND_VAR286 BIND_VAR286
BIND_VAR287 BIND_VAR287
BIND_VAR288 BIND_VAR288
LDT_FILE LDT_FILE
BIND_VAR19 BIND_VAR19
BIND_VAR289 BIND_VAR289
BIND_VAR290 BIND_VAR290
BIND_VAR291 BIND_VAR291
BIND_VAR292 BIND_VAR292
BIND_VAR293 BIND_VAR293
BIND_VAR294 BIND_VAR294
BIND_VAR295 BIND_VAR295
BIND_VAR296 BIND_VAR296
BIND_VAR297 BIND_VAR297
BIND_VAR298 BIND_VAR298
BIND_VAR20 BIND_VAR20
BIND_VAR299 BIND_VAR299
BIND_VAR300 BIND_VAR300
BIND_VAR21 BIND_VAR21
BIND_VAR22 BIND_VAR22
BIND_VAR23 BIND_VAR23
BIND_VAR24 BIND_VAR24
BIND_VAR25 BIND_VAR25
BIND_VAR26 BIND_VAR26
BIND_VAR27 BIND_VAR27
BIND_VAR28 BIND_VAR28
ENTITY_NAME ENTITY_NAME
BIND_VAR29 BIND_VAR29
BIND_VAR30 BIND_VAR30
BIND_VAR31 BIND_VAR31
BIND_VAR32 BIND_VAR32
BIND_VAR33 BIND_VAR33
BIND_VAR34 BIND_VAR34
BIND_VAR35 BIND_VAR35
BIND_VAR36 BIND_VAR36
BIND_VAR37 BIND_VAR37
BIND_VAR38 BIND_VAR38
STMT_TYPE STMT_TYPE
BIND_VAR39 BIND_VAR39
BIND_VAR40 BIND_VAR40
BIND_VAR41 BIND_VAR41
BIND_VAR42 BIND_VAR42
BIND_VAR43 BIND_VAR43
BIND_VAR44 BIND_VAR44
BIND_VAR45 BIND_VAR45
BIND_VAR46 BIND_VAR46
BIND_VAR47 BIND_VAR47
BIND_VAR48 BIND_VAR48
UPLOAD_STMT UPLOAD_STMT
BIND_VAR49 BIND_VAR49
BIND_VAR50 BIND_VAR50
BIND_VAR51 BIND_VAR51
BIND_VAR52 BIND_VAR52
BIND_VAR53 BIND_VAR53
BIND_VAR54 BIND_VAR54
BIND_VAR55 BIND_VAR55
BIND_VAR56 BIND_VAR56
BIND_VAR57 BIND_VAR57
BIND_VAR58 BIND_VAR58
GET_WHO_STMT GET_WHO_STMT
BIND_VAR59 BIND_VAR59
BIND_VAR60 BIND_VAR60
BIND_VAR61 BIND_VAR61
BIND_VAR62 BIND_VAR62
BIND_VAR63 BIND_VAR63
BIND_VAR64 BIND_VAR64
BIND_VAR65 BIND_VAR65
BIND_VAR66 BIND_VAR66
BIND_VAR67 BIND_VAR67
BIND_VAR68 BIND_VAR68
BIND_VAR_CNT BIND_VAR_CNT
BIND_VAR69 BIND_VAR69
BIND_VAR70 BIND_VAR70
BIND_VAR71 BIND_VAR71
BIND_VAR72 BIND_VAR72
BIND_VAR73 BIND_VAR73
BIND_VAR74 BIND_VAR74
BIND_VAR75 BIND_VAR75
BIND_VAR76 BIND_VAR76
BIND_VAR77 BIND_VAR77
BIND_VAR78 BIND_VAR78
PK_VAR_CNT PK_VAR_CNT
BIND_VAR79 BIND_VAR79
BIND_VAR80 BIND_VAR80
BIND_VAR81 BIND_VAR81
BIND_VAR82 BIND_VAR82
BIND_VAR83 BIND_VAR83
BIND_VAR84 BIND_VAR84
BIND_VAR85 BIND_VAR85
BIND_VAR86 BIND_VAR86
BIND_VAR87 BIND_VAR87
BIND_VAR88 BIND_VAR88
Application Object Library - FND_SEED_STAGE_ENTITY FND_SEED_STAGE_ENTITY
Column Name Descritpion
LDT_FILE LDT_FILE
ACTION ACTION
BIND_VALUE87 BIND_VALUE87
BIND_VALUE88 BIND_VALUE88
BIND_VALUE89 BIND_VALUE89
BIND_VALUE90 BIND_VALUE90
BIND_VALUE91 BIND_VALUE91
BIND_VALUE92 BIND_VALUE92
BIND_VALUE93 BIND_VALUE93
BIND_VALUE94 BIND_VALUE94
BIND_VALUE95 BIND_VALUE95
BIND_VALUE96 BIND_VALUE96
COMMIT_FLAG COMMIT_FLAG
BIND_VALUE97 BIND_VALUE97
BIND_VALUE98 BIND_VALUE98
BIND_VALUE99 BIND_VALUE99
BIND_VALUE100 BIND_VALUE100
BIND_VALUE101 BIND_VALUE101
BIND_VALUE102 BIND_VALUE102
BIND_VALUE103 BIND_VALUE103
BIND_VALUE104 BIND_VALUE104
BIND_VALUE105 BIND_VALUE105
BIND_VALUE106 BIND_VALUE106
EXEC_STATUS EXEC_STATUS
BIND_VALUE107 BIND_VALUE107
BIND_VALUE108 BIND_VALUE108
BIND_VALUE109 BIND_VALUE109
BIND_VALUE110 BIND_VALUE110
BIND_VALUE111 BIND_VALUE111
BIND_VALUE112 BIND_VALUE112
BIND_VALUE113 BIND_VALUE113
BIND_VALUE114 BIND_VALUE114
BIND_VALUE115 BIND_VALUE115
BIND_VALUE116 BIND_VALUE116
BIND_VALUE0 BIND_VALUE0
BIND_VALUE117 BIND_VALUE117
BIND_VALUE118 BIND_VALUE118
BIND_VALUE119 BIND_VALUE119
BIND_VALUE120 BIND_VALUE120
BIND_VALUE121 BIND_VALUE121
BIND_VALUE122 BIND_VALUE122
BIND_VALUE123 BIND_VALUE123
BIND_VALUE124 BIND_VALUE124
BIND_VALUE125 BIND_VALUE125
BIND_VALUE126 BIND_VALUE126
BIND_VALUE1 BIND_VALUE1
BIND_VALUE127 BIND_VALUE127
BIND_VALUE128 BIND_VALUE128
BIND_VALUE129 BIND_VALUE129
BIND_VALUE130 BIND_VALUE130
BIND_VALUE131 BIND_VALUE131
BIND_VALUE132 BIND_VALUE132
BIND_VALUE133 BIND_VALUE133
BIND_VALUE134 BIND_VALUE134
BIND_VALUE135 BIND_VALUE135
BIND_VALUE136 BIND_VALUE136
BIND_VALUE2 BIND_VALUE2
BIND_VALUE137 BIND_VALUE137
BIND_VALUE138 BIND_VALUE138
BIND_VALUE139 BIND_VALUE139
BIND_VALUE140 BIND_VALUE140
BIND_VALUE141 BIND_VALUE141
BIND_VALUE142 BIND_VALUE142
BIND_VALUE143 BIND_VALUE143
BIND_VALUE144 BIND_VALUE144
BIND_VALUE145 BIND_VALUE145
BIND_VALUE146 BIND_VALUE146
BIND_VALUE3 BIND_VALUE3
BIND_VALUE147 BIND_VALUE147
BIND_VALUE148 BIND_VALUE148
BIND_VALUE149 BIND_VALUE149
BIND_VALUE150 BIND_VALUE150
BIND_VALUE151 BIND_VALUE151
BIND_VALUE152 BIND_VALUE152
BIND_VALUE153 BIND_VALUE153
BIND_VALUE154 BIND_VALUE154
BIND_VALUE155 BIND_VALUE155
BIND_VALUE156 BIND_VALUE156
BIND_VALUE4 BIND_VALUE4
BIND_VALUE157 BIND_VALUE157
BIND_VALUE158 BIND_VALUE158
BIND_VALUE159 BIND_VALUE159
BIND_VALUE160 BIND_VALUE160
BIND_VALUE161 BIND_VALUE161
BIND_VALUE162 BIND_VALUE162
BIND_VALUE163 BIND_VALUE163
BIND_VALUE164 BIND_VALUE164
BIND_VALUE165 BIND_VALUE165
BIND_VALUE166 BIND_VALUE166
BIND_VALUE5 BIND_VALUE5
BIND_VALUE167 BIND_VALUE167
BIND_VALUE168 BIND_VALUE168
BIND_VALUE169 BIND_VALUE169
BIND_VALUE170 BIND_VALUE170
BIND_VALUE171 BIND_VALUE171
BIND_VALUE172 BIND_VALUE172
BIND_VALUE173 BIND_VALUE173
BIND_VALUE174 BIND_VALUE174
BIND_VALUE175 BIND_VALUE175
BIND_VALUE176 BIND_VALUE176
BIND_VALUE6 BIND_VALUE6
BIND_VALUE177 BIND_VALUE177
BIND_VALUE178 BIND_VALUE178
BIND_VALUE179 BIND_VALUE179
BIND_VALUE180 BIND_VALUE180
BIND_VALUE181 BIND_VALUE181
BIND_VALUE182 BIND_VALUE182
BIND_VALUE183 BIND_VALUE183
BIND_VALUE184 BIND_VALUE184
BIND_VALUE185 BIND_VALUE185
BIND_VALUE186 BIND_VALUE186
LCT_FILE LCT_FILE
BIND_VALUE7 BIND_VALUE7
BIND_VALUE187 BIND_VALUE187
BIND_VALUE188 BIND_VALUE188
BIND_VALUE189 BIND_VALUE189
BIND_VALUE190 BIND_VALUE190
BIND_VALUE191 BIND_VALUE191
BIND_VALUE192 BIND_VALUE192
BIND_VALUE193 BIND_VALUE193
BIND_VALUE194 BIND_VALUE194
BIND_VALUE195 BIND_VALUE195
BIND_VALUE196 BIND_VALUE196
BIND_VALUE8 BIND_VALUE8
BIND_VALUE197 BIND_VALUE197
BIND_VALUE198 BIND_VALUE198
BIND_VALUE199 BIND_VALUE199
BIND_VALUE200 BIND_VALUE200
BIND_VALUE201 BIND_VALUE201
BIND_VALUE202 BIND_VALUE202
BIND_VALUE203 BIND_VALUE203
BIND_VALUE204 BIND_VALUE204
BIND_VALUE205 BIND_VALUE205
BIND_VALUE206 BIND_VALUE206
BIND_VALUE9 BIND_VALUE9
BIND_VALUE207 BIND_VALUE207
BIND_VALUE208 BIND_VALUE208
BIND_VALUE209 BIND_VALUE209
BIND_VALUE210 BIND_VALUE210
BIND_VALUE211 BIND_VALUE211
BIND_VALUE212 BIND_VALUE212
BIND_VALUE213 BIND_VALUE213
BIND_VALUE214 BIND_VALUE214
BIND_VALUE215 BIND_VALUE215
BIND_VALUE216 BIND_VALUE216
BIND_VALUE10 BIND_VALUE10
BIND_VALUE217 BIND_VALUE217
BIND_VALUE218 BIND_VALUE218
BIND_VALUE219 BIND_VALUE219
BIND_VALUE220 BIND_VALUE220
BIND_VALUE221 BIND_VALUE221
BIND_VALUE222 BIND_VALUE222
BIND_VALUE223 BIND_VALUE223
BIND_VALUE224 BIND_VALUE224
BIND_VALUE225 BIND_VALUE225
BIND_VALUE226 BIND_VALUE226
BIND_VALUE11 BIND_VALUE11
BIND_VALUE227 BIND_VALUE227
BIND_VALUE228 BIND_VALUE228
BIND_VALUE229 BIND_VALUE229
BIND_VALUE230 BIND_VALUE230
BIND_VALUE231 BIND_VALUE231
BIND_VALUE232 BIND_VALUE232
BIND_VALUE233 BIND_VALUE233
BIND_VALUE234 BIND_VALUE234
BIND_VALUE235 BIND_VALUE235
BIND_VALUE236 BIND_VALUE236
BIND_VALUE12 BIND_VALUE12
BIND_VALUE237 BIND_VALUE237
BIND_VALUE238 BIND_VALUE238
BIND_VALUE239 BIND_VALUE239
BIND_VALUE240 BIND_VALUE240
BIND_VALUE241 BIND_VALUE241
BIND_VALUE242 BIND_VALUE242
BIND_VALUE243 BIND_VALUE243
BIND_VALUE244 BIND_VALUE244
BIND_VALUE245 BIND_VALUE245
BIND_VALUE246 BIND_VALUE246
BIND_VALUE13 BIND_VALUE13
BIND_VALUE247 BIND_VALUE247
BIND_VALUE248 BIND_VALUE248
BIND_VALUE249 BIND_VALUE249
BIND_VALUE250 BIND_VALUE250
BIND_VALUE251 BIND_VALUE251
BIND_VALUE252 BIND_VALUE252
BIND_VALUE253 BIND_VALUE253
BIND_VALUE254 BIND_VALUE254
BIND_VALUE255 BIND_VALUE255
BIND_VALUE256 BIND_VALUE256
BIND_VALUE14 BIND_VALUE14
BIND_VALUE257 BIND_VALUE257
BIND_VALUE258 BIND_VALUE258
BIND_VALUE259 BIND_VALUE259
BIND_VALUE260 BIND_VALUE260
BIND_VALUE261 BIND_VALUE261
BIND_VALUE262 BIND_VALUE262
BIND_VALUE263 BIND_VALUE263
BIND_VALUE264 BIND_VALUE264
BIND_VALUE265 BIND_VALUE265
BIND_VALUE266 BIND_VALUE266
BIND_VALUE15 BIND_VALUE15
BIND_VALUE267 BIND_VALUE267
BIND_VALUE268 BIND_VALUE268
BIND_VALUE269 BIND_VALUE269
BIND_VALUE270 BIND_VALUE270
BIND_VALUE271 BIND_VALUE271
BIND_VALUE272 BIND_VALUE272
BIND_VALUE273 BIND_VALUE273
BIND_VALUE274 BIND_VALUE274
BIND_VALUE275 BIND_VALUE275
BIND_VALUE276 BIND_VALUE276
BIND_VALUE16 BIND_VALUE16
BIND_VALUE277 BIND_VALUE277
BIND_VALUE278 BIND_VALUE278
BIND_VALUE279 BIND_VALUE279
BIND_VALUE280 BIND_VALUE280
BIND_VALUE281 BIND_VALUE281
BIND_VALUE282 BIND_VALUE282
BIND_VALUE283 BIND_VALUE283
BIND_VALUE284 BIND_VALUE284
BIND_VALUE285 BIND_VALUE285
BIND_VALUE286 BIND_VALUE286
SEQ SEQ
BIND_VALUE17 BIND_VALUE17
BIND_VALUE287 BIND_VALUE287
BIND_VALUE288 BIND_VALUE288
BIND_VALUE289 BIND_VALUE289
BIND_VALUE290 BIND_VALUE290
BIND_VALUE291 BIND_VALUE291
BIND_VALUE292 BIND_VALUE292
BIND_VALUE293 BIND_VALUE293
BIND_VALUE294 BIND_VALUE294
BIND_VALUE295 BIND_VALUE295
BIND_VALUE296 BIND_VALUE296
BIND_VALUE18 BIND_VALUE18
BIND_VALUE297 BIND_VALUE297
BIND_VALUE298 BIND_VALUE298
BIND_VALUE299 BIND_VALUE299
BIND_VALUE300 BIND_VALUE300
BIND_VAR_METADATA BIND_VAR_METADATA
BIND_VALUE19 BIND_VALUE19
BIND_VALUE20 BIND_VALUE20
BIND_VALUE21 BIND_VALUE21
BIND_VALUE22 BIND_VALUE22
BIND_VALUE23 BIND_VALUE23
BIND_VALUE24 BIND_VALUE24
BIND_VALUE25 BIND_VALUE25
BIND_VALUE26 BIND_VALUE26
CONFIG_ID CONFIG_ID
BIND_VALUE27 BIND_VALUE27
BIND_VALUE28 BIND_VALUE28
BIND_VALUE29 BIND_VALUE29
BIND_VALUE30 BIND_VALUE30
BIND_VALUE31 BIND_VALUE31
BIND_VALUE32 BIND_VALUE32
BIND_VALUE33 BIND_VALUE33
BIND_VALUE34 BIND_VALUE34
BIND_VALUE35 BIND_VALUE35
BIND_VALUE36 BIND_VALUE36
TOP_ENTITY_SEQ TOP_ENTITY_SEQ
BIND_VALUE37 BIND_VALUE37
BIND_VALUE38 BIND_VALUE38
BIND_VALUE39 BIND_VALUE39
BIND_VALUE40 BIND_VALUE40
BIND_VALUE41 BIND_VALUE41
BIND_VALUE42 BIND_VALUE42
BIND_VALUE43 BIND_VALUE43
BIND_VALUE44 BIND_VALUE44
BIND_VALUE45 BIND_VALUE45
BIND_VALUE46 BIND_VALUE46
LAST_DB_UPDATED_BY LAST_DB_UPDATED_BY
BIND_VALUE47 BIND_VALUE47
BIND_VALUE48 BIND_VALUE48
BIND_VALUE49 BIND_VALUE49
BIND_VALUE50 BIND_VALUE50
BIND_VALUE51 BIND_VALUE51
BIND_VALUE52 BIND_VALUE52
BIND_VALUE53 BIND_VALUE53
BIND_VALUE54 BIND_VALUE54
BIND_VALUE55 BIND_VALUE55
BIND_VALUE56 BIND_VALUE56
LAST_DB_UPDATE_DATE LAST_DB_UPDATE_DATE
BIND_VALUE57 BIND_VALUE57
BIND_VALUE58 BIND_VALUE58
BIND_VALUE59 BIND_VALUE59
BIND_VALUE60 BIND_VALUE60
BIND_VALUE61 BIND_VALUE61
BIND_VALUE62 BIND_VALUE62
BIND_VALUE63 BIND_VALUE63
BIND_VALUE64 BIND_VALUE64
BIND_VALUE65 BIND_VALUE65
BIND_VALUE66 BIND_VALUE66
LAST_FILE_UPDATED_BY LAST_FILE_UPDATED_BY
BIND_VALUE67 BIND_VALUE67
BIND_VALUE68 BIND_VALUE68
BIND_VALUE69 BIND_VALUE69
BIND_VALUE70 BIND_VALUE70
BIND_VALUE71 BIND_VALUE71
BIND_VALUE72 BIND_VALUE72
BIND_VALUE73 BIND_VALUE73
BIND_VALUE74 BIND_VALUE74
BIND_VALUE75 BIND_VALUE75
BIND_VALUE76 BIND_VALUE76
LAST_FILE_UPDATE_DATE LAST_FILE_UPDATE_DATE
BIND_VALUE77 BIND_VALUE77
BIND_VALUE78 BIND_VALUE78
BIND_VALUE79 BIND_VALUE79
BIND_VALUE80 BIND_VALUE80
BIND_VALUE81 BIND_VALUE81
BIND_VALUE82 BIND_VALUE82
BIND_VALUE83 BIND_VALUE83
BIND_VALUE84 BIND_VALUE84
BIND_VALUE85 BIND_VALUE85
BIND_VALUE86 BIND_VALUE86
Application Object Library - FND_OBJECT_KEY_SETS
Column Name Descritpion
OBJECT_ID
ALT2_MEMBER_NAME
ALT3_MEMBER_NAME
ALT4_MEMBER_NAME
ALT5_MEMBER_NAME
KEY_SET_NAME
KEY_SET_SEQUENCE
KEY1_MEMBER_NAME
KEY2_MEMBER_NAME
KEY3_MEMBER_NAME
KEY4_MEMBER_NAME
KEY5_MEMBER_NAME
ALT1_MEMBER_NAME
Application Object Library - FND_RAND_STATES This table stores the state information used by the secure pseudo random number generator
Column Name Descritpion
LOCK_ID PRNG id
POOL4 entropy pool4
POOL5 entropy pool5
POOL6 entropy pool6
POOL7 entropy pool7
POOL8 entropy pool8
POOL9 entropy pool9
POOL10 entropy pool10
POOL11 entropy pool11
POOL12 entropy pool12
POOL13 entropy pool13
LAST_SEQUENCE Value of the sequence the last time the key was updated
POOL14 entropy pool14
POOL15 entropy pool15
POOL16 entropy pool16
POOL17 entropy pool17
POOL18 entropy pool18
POOL19 entropy pool19
POOL20 entropy pool20
POOL21 entropy pool21
POOL22 entropy pool22
POOL23 entropy pool23
RESEED_COUNTER How many reseed operations have been done to the key
POOL24 entropy pool24
POOL25 entropy pool25
POOL26 entropy pool26
POOL27 entropy pool27
POOL28 entropy pool28
POOL29 entropy pool29
POOL30 entropy pool30
POOL31 entropy pool31
EVENT_COUNT Number of entropy events that have been added to the pool since the last reseed operation
RANDOM_KEY A random key that is part of the internal state of the random number generator
POOL0 entropy pool0
POOL1 entropy pool1
POOL2 entropy pool2
POOL3 entropy pool3
Application Object Library - FND_TS_MIG_STATUS
Column Name Descritpion
ORD_ID
START_DATE
END_DATE
STATUS
ITEM
ITEM_PARAM
DETAIL_MESSAGE
LOG_FILE
NUM_THREADS
Application Object Library - IEU_UWQM_ITEMS_GTT
Column Name Descritpion
PROCESSING_SET_ID
OWNER_TYPE
OWNER_ID
ASSIGNEE_TYPE
ASSIGNEE_ID
SOURCE_OBJECT_ID
SOURCE_OBJECT_TYPE_CODE
OWNER_TYPE_ACTUAL
ASSIGNEE_TYPE_ACTUAL
APPLICATION_ID
IEU_ENUM_TYPE_UUID
WORKITEM_OBJ_CODE
STATUS_UPDATE_USER_ID
WORK_ITEM_NUMBER
RESCHEDULE_TIME
WS_ID
DISTRIBUTION_STATUS_ID
WORKITEM_STATUS
PRIORITY_CODE
WS_ID1
WS_ID2
ASSOCIATION_WS_ID
WORKITEM_PK_ID
DIST_ST_BASED_ON_PARENT_FLAG
DIST_FROM
DIST_TO
PARENT_STATUS_ID
PARENT_DIST_STATUS_ID
DIST_ID_FLAG
PLANNED_START_DATE
PLANNED_END_DATE
SCHEDULED_START_DATE
SCHEDULED_END_DATE
STATUS_ID
ACTUAL_START_DATE
ACTUAL_END_DATE
DATE_SELECTED
TASK_TYPE_ID
TASK_PRIORITY_ID
UWQ_DEF_WORK_ITEM_STATUS
UWQ_DEF_PRIORITY_CODE
UWQ_DEF_DUE_DATE
UWQ_DEF_IEU_ENUM_TYPE_UUID
UWQ_DEF_ORIGINAL_GRP_OWNER
PRIORITY_ID
PRIORITY_LEVEL
DUE_DATE
TITLE
PARTY_ID
Application Object Library - HRI_MDP_BDGTS_HDCNT_MV
Column Name Descritpion
SYS_NC00006$
ORGMGR_ID
EFFECTIVE_START_DATE
SYS_NC00008$
EFFECTIVE_END_DATE
BUDGET_AGGREGATE
SYS_NC00007$
HEADCOUNT_VALUE
SYS_NC00009$
Application Object Library - HRI_MDP_BDGTS_LBRCST_MV
Column Name Descritpion
SYS_NC00006$
ORGMGR_ID
EFFECTIVE_START_DATE
SYS_NC00008$
EFFECTIVE_END_DATE
CURRENCY_CODE
SYS_NC00007$
BUDGET_VALUE
SYS_NC00009$
Application Object Library - HRI_MDP_BDGTS_LBRCST_ORG_MV
Column Name Descritpion
SYS_NC00009$
ORGMGR_ID
EFFECTIVE_START_DATE
SYS_NC00008$
EFFECTIVE_END_DATE
ORGANIZATION_ID
SYS_NC00010$
CURRENCY_CODE
BUDGET_VALUE
SYS_NC00007$
SYS_NC00011$
Application Object Library - HRI_MDP_BDGTS_HDCNT_ORG_MV
Column Name Descritpion
SYS_NC00009$
ORGMGR_ID
EFFECTIVE_START_DATE
SYS_NC00008$
EFFECTIVE_END_DATE
ORGANIZATION_ID
SYS_NC00010$
BUDGET_AGGREGATE
HEADCOUNT_VALUE
SYS_NC00007$
SYS_NC00011$
Application Object Library - HRI_MDP_CMNTS_ACTLS_ORG_MV
Column Name Descritpion
SYS_NC00009$
ORGMGR_ID
EFFECTIVE_START_DATE
SYS_NC00008$
EFFECTIVE_END_DATE
ORGANIZATION_ID
SYS_NC00010$
CURRENCY_CODE
COMMITMENT_VALUE
SYS_NC00012$
ACTUAL_VALUE
SYS_NC00011$
Application Object Library - HRI_MDP_CMNTS_ACTLS_MV
Column Name Descritpion
SYS_NC00009$
ORGMGR_ID
EFFECTIVE_START_DATE
SYS_NC00008$
EFFECTIVE_END_DATE
CURRENCY_CODE
SYS_NC00010$
COMMITMENT_VALUE
ACTUAL_VALUE
SYS_NC00007$
Application Object Library - HRI_MDP_SUP_GAIN_HIRE_MV
Column Name Descritpion
SYS_NC00013$
SUPERVISOR_ID
CNT3
CNT
JOB_ID
SYS_NC00015$
EFFECTIVE_DATE
CURRENCY
SYS_NC00012$
HEADCOUNT_VALUE
FTE_VALUE
SYS_NC00014$
SALARY
CNT1
CNT2
Application Object Library - HRI_MDP_SUP_WCNT_CHG_ASG_MV
Column Name Descritpion
SUPERVISOR_PERSON_ID
TERMINATION_HDC
TRANSFER_IN_HDC
TRANSFER_OUT_HDC
OTHER_GAINS_HDC
OTHER_LOSSES_HDC
HIRE_FTE
TERMINATION_FTE
TRANSFER_IN_FTE
TRANSFER_OUT_FTE
TERM_VOLUNTARY_IND
EFFECTIVE_DATE
TERM_INVOLUNTARY_IND
ADMIN_ROW_TYPE
ADMIN_COUNT_HIRE_HDC
ADMIN_COUNT_TERMINATION_HDC
ADMIN_COUNT_TERM_VOL_HDC
ADMIN_COUNT_TERM_INVOL_HDC
ADMIN_COUNT_TRANSFER_IN_HDC
ADMIN_COUNT_TRANSFER_OUT_HDC
ADMIN_COUNT_OTHER_GAINS_HDC
ADMIN_COUNT_OTHER_LOSSES_HDC
ASSIGNMENT_ID
ADMIN_CHANGE_TYPE_ID
ADMIN_COUNT
PERSON_ID
WKTH_WKTYP_SK_FK
CHANGE_TYPE_ID
DIRECT_RECORD_IND
TRANSFER_WITHIN_COUNT
HIRE_HDC
Application Object Library - HRI_MDP_SUP_WCNT_TERM_ASG_MV
Column Name Descritpion
SYS_NC00036$
SUPERVISOR_PERSON_ID
GEO_COUNTRY_CODE
SYS_NC00032$
JOB_FMLY_CODE
JOB_FNCTN_CODE
SYS_NC00035$
JOB_ID
LEAVING_REASON_CODE
SYS_NC00038$
SEPARATION_CATEGORY
ORGANIZATION_ID
SYS_NC00025$
LOCATION_ID
POW_BAND_SK_FK
SYS_NC00028$
PERF_BAND
DIRECT_SUPERVISOR_PERSON_ID
DIRECT_IND
SYS_NC00041$
SYS_NC00039$
SEPARATION_HDC
ADMIN_SPRTN_HDC_COUNT
SYS_NC00031$
ADMIN_ROW_COUNT
SYS_NC00034$
SYS_NC00037$
SYS_NC00024$
EFFECTIVE_DATE
SYS_NC00027$
SYS_NC00040$
SYS_NC00030$
SYS_NC00033$
WKTH_WKTYP_SK_FK
SYS_NC00026$
POW_START_DATE
POW_MONTHS
SYS_NC00029$
ASSIGNMENT_ID
PERSON_ID
SYS_NC00042$
GEO_AREA_CODE
Application Object Library - FND_SEGMENT_ATTRIBUTE_TYPES Key flexfield qualifiers
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_segment_attribute_types.id_flex_code and rownum = 1
LAST_UPDATE_LOGIN Standard Who column
GLOBAL_FLAG Flag to specify whether the flexfield qualifier applies to all segments
REQUIRED_FLAG Flag to indicate if the qualifier is required for at least one segment
UNIQUE_FLAG Flag to indicate whether the qualifier only applies to one segment
SEGMENT_PROMPT The display prompt for the segment
ID_FLEX_CODE Key flexfield code
DESCRIPTION Description
SEGMENT_ATTRIBUTE_TYPE The data type of the flexfield qualifier
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 - HRI_MDP_SUP_WCNT_CHG_MV
Column Name Descritpion
SUPERVISOR_PERSON_ID
SEPARATION_HDC
SEP_VOL_HDC
SEP_INVOL_HDC
TRANSFER_IN_HDC
TRANSFER_OUT_HDC
GAIN_FTE
LOSS_FTE
NET_GAIN_LOSS_FTE
HIRE_FTE
TERMINATION_FTE
EFFECTIVE_DATE
SEPARATION_FTE
SEP_VOL_FTE
SEP_INVOL_FTE
TRANSFER_IN_FTE
TRANSFER_OUT_FTE
ADMIN_ROW_TYPE
ADMIN_COUNT_GAIN_HDC
ADMIN_COUNT_LOSS_HDC
ADMIN_COUNT_NET_HDC
ADMIN_COUNT_HIRE_HDC
WKTH_WKTYP_SK_FK
ADMIN_COUNT_TERMINATION_HDC
ADMIN_COUNT_SEPARATION_HDC
ADMIN_COUNT_SEP_VOL_HDC
ADMIN_COUNT_SEP_INVOL_HDC
ADMIN_COUNT_TRANSFER_IN_HDC
ADMIN_COUNT_TRANSFER_OUT_HDC
ADMIN_COUNT_GAIN_FTE
ADMIN_COUNT_LOSS_FTE
ADMIN_COUNT_NET_FTE
ADMIN_COUNT_HIRE_FTE
DIRECT_RECORD_IND
ADMIN_COUNT_TERMINATION_FTE
ADMIN_COUNT_SEPARATION_FTE
ADMIN_COUNT_SEP_VOL_FTE
ADMIN_COUNT_SEP_INVOL_FTE
ADMIN_COUNT_TRANSFER_IN_FTE
ADMIN_COUNT_TRANSFER_OUT_FTE
ADMIN_COUNT
GAIN_HDC
LOSS_HDC
NET_GAIN_LOSS_HDC
HIRE_HDC
TERMINATION_HDC
Application Object Library - HRI_MDS_SUP_WCNT_TERM_CTR_MV
Column Name Descritpion
SYS_NC00021$
SUPERVISOR_PERSON_ID
POW_MONTHS
SYS_NC00020$
SEPARATION_HDC
SEP_INVOL_HDC
SYS_NC00015$
SEP_VOL_HDC
SYS_NC00018$
EFFECTIVE_DATE
SYS_NC00016$
PERIOD_TYPE
COMPARISON_TYPE
SYS_NC00019$
WKTH_WKTYP_SK_FK
DIRECT_IND
SYS_NC00014$
GEO_AREA_CODE
GEO_COUNTRY_CODE
SYS_NC00017$
POW_DAYS
Application Object Library - HRI_MDS_SUP_WMV_SUP_MV
Column Name Descritpion
SUPERVISOR_PERSON_ID
COMP_TOTAL_HDC_END
COMP_DIRECT_HDC_END
COMP_TOTAL_PASG_CNT_END
COMP_DIRECT_PASG_CNT_END
CURR_TOTAL_HDC_START
CURR_DIRECT_HDC_START
COMP_TOTAL_HDC_START
COMP_DIRECT_HDC_START
CURR_TOTAL_POW_END
CURR_DIRECT_POW_END
EFFECTIVE_DATE
COMP_TOTAL_POW_END
COMP_DIRECT_POW_END
CURR_EXTN_ASG_CNT_END
CURR_TOTAL_POW_EXTN_END
CURR_DIRECT_POW_EXTN_END
COMP_EXTN_ASG_CNT_END
COMP_TOTAL_POW_EXTN_END
COMP_DIRECT_POW_EXTN_END
WKTH_WKTYP_SK_FK
PERIOD_TYPE
COMPARISON_TYPE
CURR_TOTAL_HDC_END
CURR_DIRECT_HDC_END
CURR_TOTAL_PASG_CNT_END
CURR_DIRECT_PASG_CNT_END
Application Object Library - IBW_CART_BASE_MV
Column Name Descritpion
UMARKER
SOURCE_PRIMARY_REFERENCE
D_TOTAL_CNT
TRANSACTION_DATE
SITE_ID
CUSTOMER_ID
CARTS
ORDERS
ANONYMOUS_CARTS
LEAD_RANK
MARKETING_SOURCE_CODE_ID_HDR
Application Object Library - IBE_BI_MSITEORG_MV
Column Name Descritpion
MSITE_ID
ORG_ID
Application Object Library - HRI_MDS_SUP_WCNT_CHG_MV
Column Name Descritpion
SYS_NC00027$
SUPERVISOR_PERSON_ID
HIRE_HDC
SYS_NC00032$
TERMINATION_HDC
SEPARATION_HDC
SEP_VOL_HDC
SEP_INVOL_HDC
TRANSFER_IN_HDC
TRANSFER_OUT_HDC
GAIN_FTE
LOSS_FTE
NET_GAIN_LOSS_FTE
EFFECTIVE_DATE
HIRE_FTE
SYS_NC00030$
TERMINATION_FTE
SEPARATION_FTE
TERM_VOL_FTE
TERM_INVOL_FTE
TRANSFER_IN_FTE
TRANSFER_OUT_FTE
PERIOD_TYPE
COMPARISON_TYPE
SYS_NC00028$
WKTH_WKTYP_SK_FK
DIRECT_RECORD_IND
SYS_NC00031$
GAIN_HDC
LOSS_HDC
SYS_NC00029$
NET_GAIN_LOSS_HDC
Application Object Library - IBE_BI_CAT_MV
Column Name Descritpion
UMARKER
LEAF_NODE
ASSIST_FLAG
BOOKED_AMT_G
BOOKED_AMT_G1
BOOKED_AMT_F
LIST_AMT_G
LIST_AMT_G1
LIST_AMT_F
DISCOUNT_AMT_G
DISCOUNT_AMT_G1
BOOKED_DATE_ID
DISCOUNT_AMT_F
D_BOOKED_AMT_G_CNT
D_BOOKED_AMT_G1_CNT
D_BOOKED_AMT_F_CNT
D_LIST_AMT_G_CNT
D_LIST_AMT_G1_CNT
D_LIST_AMT_F_CNT
D_DISCOUNT_AMT_G_CNT
D_DISCOUNT_AMT_G1_CNT
D_DISCOUNT_AMT_F_CNT
HEADER_ID
D_TOT_CNT
D_GID
ORDER_ID
MINISITE_ID
CURRENCY_CD_F
CATEGORY_ID
PARENT_CATEGORY_ID
TOP_NODE_FLAG
Application Object Library - IBW_PAGE_SA_TIME_MV
Column Name Descritpion
SYS_NC00027$
SITE_ID
D_PAGE_VIEW_DURATION_CNT
SYS_NC00028$
GROUPING_SETS_ID
TIME_ID
SYS_NC00031$
PERIOD_TYPE_ID
ENT_YEAR_ID
SYS_NC00023$
ENT_QTR_ID
ENT_PERIOD_ID
SYS_NC00026$
REPORT_DATE_JULIAN
WEEK_ID
SYS_NC00029$
D_GID
TRANSACTION_DATE
D_TOT
SYS_NC00030$
SYS_NC00032$
SYS_NC00021$
SYS_NC00024$
PAGE_INSTANCE_ID
SITE_AREA_ID
SYS_NC00033$
VISITANT_ID
VISIT_ID
SYS_NC00022$
PAGE_VIEWS
PAGE_VIEW_DURATION
SYS_NC00025$
D_PAGE_VIEWS
Application Object Library - IBE_BI_ITEM_MV
Column Name Descritpion
UMARKER
RESOURCE_FLAG
CURRENCY_CD_F
BOOKED_AMT_G
BOOKED_AMT_G1
BOOKED_AMT_F
BOOKED_LIST_AMT_G
BOOKED_LIST_AMT_G1
BOOKED_LIST_AMT_F
DISCOUNT_AMT_G
DISCOUNT_AMT_G1
BOOKED_DATE_ID
DISCOUNT_AMT_F
NUM_OF_LINES
D_BOOKED_AMT_G_CNT
D_BOOKED_AMT_G1_CNT
D_BOOKED_AMT_F_CNT
D_DISCOUNT_AMT_G_CNT
D_DISCOUNT_AMT_G1_CNT
D_DISCOUNT_AMT_F_CNT
D_BOOKED_LIST_AMT_G_CNT
D_BOOKED_LIST_AMT_G1_CNT
HEADER_ID
D_BOOKED_LIST_AMT_F_CNT
D_NUM_OF_LINES_CNT
D_TOT_CNT
NUM_OF_ORD_CART
NO_ORDERS
ORDER_HEADER_ID
MINISITE_ID
ITEM_ID
CATEGORY_ID
Application Object Library - IBE_BI_CART_ORD_MV
Column Name Descritpion
UMARKER
LIST_AMOUNT_F
LIST_AMOUNT_G
LIST_AMOUNT_G1
DISC_AMOUNT_F
DISC_AMOUNT_G
DISC_AMOUNT_G1
NO_LINES
TOT_COUNT
CON_ORD
D_LINES_F
MINISITE_ID
D_LINES_G
D_LINES_G1
D_LIST_LINES_F
D_LIST_LINES_G
D_LIST_LINES_G1
D_DISC_LINES_F
D_DISC_LINES_G
D_DISC_LINES_G1
D_NO_OF_LINES_CNT
D_TOTAL_NUMBER
MEASURE_TYPE
ENT_YEAR_ID
ENT_QTR_ID
ENT_PERIOD_ID
REPORT_DATE_JULIAN
WEEK_ID
D_GID
RESOURCE_FLAG
TIME_ID
PERIOD_TYPE_ID
CURRENCY_CD_F
AMOUNT_F
AMOUNT_G
AMOUNT_G1
Application Object Library - IBE_BI_TOP_PROD_MV
Column Name Descritpion
SYS_NC00049$
TIME_ID
CON_ORD
SYS_NC00054$
NUM_OF_ORD_LINES
NUM_OF_CART_LINES
SYS_NC00057$
BOOKED_AMOUNT_F
BOOKED_AMOUNT_G
SYS_NC00050$
BOOKED_AMOUNT_G1
CARTS_AMT_F
SYS_NC00053$
CARTS_AMT_G
CARTS_AMT_G1
SYS_NC00056$
BOOKED_LIST_AMT_F
PERIOD_TYPE_ID
BOOKED_LIST_AMT_G
SYS_NC00059$
SYS_NC00052$
BOOKED_LIST_AMT_G1
DISCOUNT_AMOUNT_F
DISCOUNT_AMOUNT_G
DISCOUNT_AMOUNT_G1
ENT_YEAR_ID
ENT_QTR_ID
ENT_PERIOD_ID
WEEK_ID
REPORT_DATE_JULIAN
MINISITE_ID
D_TOT_ORD_COUNT_CNT
D_TOT_CART_COUNT_CNT
D_CON_ORD_CNT
D_BOOKED_AMOUNT_F_CNT
D_BOOKED_AMOUNT_G_CNT
D_BOOKED_AMOUNT_G1_CNT
D_CARTS_AMT_F_CNT
D_CARTS_AMT_G_CNT
D_CARTS_AMT_G1_CNT
D_NUM_OF_ORD_LINES_CNT
CATEGORY_ID
D_NUM_OF_CART_LINES_CNT
SYS_NC00055$
D_BOOKED_LIST_AMT_F_CNT
D_BOOKED_LIST_AMT_G_CNT
D_BOOKED_LIST_AMT_G1_CNT
D_DISCOUNT_AMOUNT_F_CNT
D_DISCOUNT_AMOUNT_G_CNT
D_DISCOUNT_AMOUNT_G1_CNT
D_GID
D_TOTAL_COUNT_TIME_MV
ITEM_ID
RESOURCE_FLAG
SYS_NC00058$
CURRENCY_CD_F
TOT_ORD_COUNT
SYS_NC00051$
TOT_CART_COUNT
Application Object Library - IBW_REFANALYSIS_MV
Column Name Descritpion
UMARKER
ORDERS_SITE_VISITS
WEB_REGISTRATIONS
CARTS
ORDERS
A_LEADS
BOOKED_AMT_F
BOOKED_AMT_G
BOOKED_AMT_G1
D_VISITS
D_PAGE_VIEWS
SITE_ID
D_ORDERS_SITE_VISITS
D_WEB_REGISTRATIONS
D_CARTS
D_ORDERS
D_BOOKED_AMT_F
D_BOOKED_AMT_G
D_BOOKED_AMT_G1
D_TOTAL_CNT
CUSTOMER_ID
TRANSACTION_DATE
REFERRAL_CATEGORY_ID
SOURCE_PRIMARY_REFERENCE
CURRENCY_CD_F
VISITS
PAGE_VIEWS
Application Object Library - IBW_VISIT_CUST_MV
Column Name Descritpion
UMARKER
PAGE_VIEWS
DAILY_UNIQ_VISITORS
NEW_WEB_CUSTOMERS
NEW_WEB_CUSTOMERS_ALL
ORDERS_SITE_VISITS
WEB_REGISTRATIONS
CARTS
ORDERS
REPEAT_WEB_ORDERS
ANONYMOUS_CARTS
SITE_ID
TOTAL_ORDER_INQUIRIES
TOTAL_PAYMENT_INQUIRIES
TOTAL_INVOICE_INQUIRIES
A_LEADS
BOOKED_AMT_F
BOOKED_AMT_G
BOOKED_AMT_G1
BOOKED_WEB_ORDERS
ASSISTED_WEB_ORDERS
TOTAL_BOOKED_AMT_F
HEADER_ID
TOTAL_BOOKED_AMT_G
TOTAL_BOOKED_AMT_G1
TOTAL_BOOKED_ORDERS
OPT_OUTS
D_VISITS
D_REPEAT_VISITS
D_VISIT_DURATION
D_PAGE_VIEWS
D_ORDERS_SITE_VISITS
D_WEB_REGISTRATIONS
CUSTOMER_ID
D_CARTS
D_ORDERS
D_ANONYMOUS_CARTS
D_TOTAL_ORDER_INQUIRIES
D_TOTAL_PAYMENT_INQUIRIES
D_TOTAL_INVOICE_INQUIRIES
D_A_LEADS
D_BOOKED_AMT_F
D_BOOKED_AMT_G
D_BOOKED_AMT_G1
TRANSACTION_DATE
D_TOTAL_BOOKED_AMT_F
D_TOTAL_BOOKED_AMT_G
D_TOTAL_BOOKED_AMT_G1
D_OPT_OUTS
D_TOTAL_CNT
CURRENCY_CD_F
VISITS
REPEAT_VISITS
VISIT_DURATION
Application Object Library - IBE_BI_CAT_TIME_MV
Column Name Descritpion
UMAR
LEAF_NODE
ASSIST_FLAG
CURR_F
ORD_COUNT
CON_ORD
ORD_AMT_G
ORD_AMT_G1
ORD_AMT_F
ORD_LIST_G
ORD_LIST_G1
TIME_ID
ORD_LIST_F
ORD_DISC_G
ORD_DISC_G1
ORD_DISC_F
CART_COUNT
CART_AMT_G
CART_AMT_G1
CART_AMT_F
T_ORD_COUNT
T_CON_ORD
PERIOD_TYPE_ID
T_ORD_AMT_G
T_ORD_AMT_G1
T_ORD_AMT_F
T_ORD_LIST_G
T_ORD_LIST_G1
T_ORD_LIST_F
T_ORD_DISC_G
T_ORD_DISC_G1
T_ORD_DISC_F
T_CART_COUNT
MINISITE_ID
T_CART_AMT_G
T_CART_AMT_G1
T_CART_AMT_F
ENT_YEAR_ID
ENT_QTR_ID
ENT_PERIOD_ID
WEEK_ID
REPORT_DATE_JULIAN
D_ORD_AMT_G_CNT
D_ORD_AMT_G1_CNT
UMARK
D_ORD_AMT_F_CNT
D_ORD_LIST_G_CNT
D_ORD_LIST_G1_CNT
D_ORD_LIST_F_CNT
D_ORD_DISC_G_CNT
D_ORD_DISC_G1_CNT
D_ORD_DISC_F_CNT
D_CART_AMT_G_CNT
D_CART_AMT_G1_CNT
D_CART_AMT_F_CNT
UMARKER
D_CON_ORD
D_CART_COUNT
D_GID
D_TOTAL_CNT
D_ORD_COUNT
D_ORD_AMT_G
D_ORD_AMT_G1
D_ORD_AMT_F
D_ORD_DISC_G
D_ORD_DISC_G1
CATID
D_ORD_DISC_F
D_ORD_LIST_G
D_ORD_LIST_G1
D_ORD_LIST_F
PARENT_CATEGORY_ID
TOP_NODE_FLAG
Application Object Library - IBW_PRODUCT_MV
Column Name Descritpion
UMARKER
PAGE_VIEWS
ORDERS_SITE_VISITS
D_PAGE_VIEWS
CURRENCY_CD_F
ORDER_ID
QOT_ORDER_ID
CART_ID
BOOKED_AMT_F
BOOKED_AMT_G
BOOKED_AMT_G1
SITE_ID
D_BOOKED_AMT_F
D_BOOKED_AMT_G
D_BOOKED_AMT_G1
GROUPING_SETS_ID
D_TOTAL_CNT
TRANSACTION_DATE
LEAF_CATEG_ID
PRODUCT_ID
VISITANT_ID
VISIT_ID
NO_VISITS
D_NO_VISITS
Application Object Library - IBW_KPI_METRICS_TIME_MV
Column Name Descritpion
SYS_NC00043$
SITE_ID
BOOKED_AMT_G1
SYS_NC00041$
ORDERS_SITE_VISITS
BOOKED_WEB_ORDERS
SYS_NC00044$
NEW_WEB_CUSTOMERS
REPEAT_WEB_ORDERS
SYS_NC00037$
TOTAL_BOOKED_ORDERS
TIME_ID
SYS_NC00040$
PERIOD_TYPE_ID
ENT_YEAR_ID
ENT_QTR_ID
TRANSACTION_DATE
ENT_PERIOD_ID
SYS_NC00039$
WEEK_ID
REPORT_DATE_JULIAN
D_GID
D_VISITS
D_WEB_REGISTRATIONS
D_CARTS
D_ANONYMOUS_CARTS
D_BOOKED_AMT_F
D_BOOKED_AMT_G
CURRENCY_CD_F
D_BOOKED_AMT_G1
D_ORDERS_SITE_VISITS
D_BOOKED_WEB_ORDERS
D_NEW_WEB_CUSTOMERS
D_REPEAT_WEB_ORDERS
D_TOTAL_BOOKED_ORDERS
D_CNT
VISITS
SYS_NC00042$
WEB_REGISTRATIONS
CARTS
SYS_NC00045$
ANONYMOUS_CARTS
BOOKED_AMT_F
SYS_NC00038$
BOOKED_AMT_G
Application Object Library - IBW_REFANALYSIS_TIME_MV
Column Name Descritpion
SYS_NC00036$
UMARK
WEB_REGISTRATIONS
SYS_NC00041$
CARTS
ORDERS
SYS_NC00044$
A_LEADS
BOOKED_AMT_F
SYS_NC00037$
BOOKED_AMT_G
BOOKED_AMT_G1
SYS_NC00040$
TIME_ID
PERIOD_TYPE_ID
SYS_NC00043$
ENT_YEAR_ID
SITE_ID
ENT_QTR_ID
SYS_NC00046$
SYS_NC00039$
ENT_PERIOD_ID
WEEK_ID
REPORT_DATE_JULIAN
D_GID
D_VISITS
D_PAGE_VIEWS
D_ORDERS_SITE_VISITS
D_WEB_REGISTRATIONS
D_CARTS
CUSTOMER_ID
D_ORDERS
D_A_LEADS
D_BOOKED_AMT_F
D_BOOKED_AMT_G
D_BOOKED_AMT_G1
D_TOTAL_CNT
TRANSACTION_DATE
SYS_NC00042$
REFERRAL_CATEGORY_ID
CURRENCY_CD_F
SYS_NC00045$
VISITS
PAGE_VIEWS
SYS_NC00038$
ORDERS_SITE_VISITS
Application Object Library - IBW_VISIT_CUST_TIME_MV
Column Name Descritpion
SYS_NC00076$
SITE_ID
NEW_WEB_CUSTOMERS
SYS_NC00072$
NEW_WEB_CUSTOMERS_ALL
ORDERS_SITE_VISITS
SYS_NC00068$
WEB_REGISTRATIONS
CARTS
SYS_NC00071$
ORDERS
REPEAT_WEB_ORDERS
SYS_NC00077$
ANONYMOUS_CARTS
TOTAL_ORDER_INQUIRIES
SYS_NC00070$
TOTAL_PAYMENT_INQUIRIES
CUSTOMER_ID
TOTAL_INVOICE_INQUIRIES
SYS_NC00075$
A_LEADS
BOOKED_AMT_F
BOOKED_AMT_G
BOOKED_AMT_G1
BOOKED_WEB_ORDERS
ASSISTED_WEB_ORDERS
TOTAL_BOOKED_AMT_F
TOTAL_BOOKED_AMT_G
TOTAL_BOOKED_AMT_G1
TRANSACTION_DATE
TOTAL_BOOKED_ORDERS
OPT_OUTS
TIME_ID
PERIOD_TYPE_ID
ENT_YEAR_ID
ENT_QTR_ID
ENT_PERIOD_ID
WEEK_ID
REPORT_DATE_JULIAN
D_GID
CURRENCY_CD_F
D_VISITS
SYS_NC00074$
D_REPEAT_VISITS
D_VISIT_DURATION
D_PAGE_VIEWS
D_DAILY_UNIQ_VISITORS
D_NEW_WEB_CUSTOMERS
D_NEW_WEB_CUSTOMERS_ALL
D_ORDERS_SITE_VISITS
D_WEB_REGISTRATIONS
D_CARTS
VISITS
D_ORDERS
D_REPEAT_WEB_ORDERS
D_ANONYMOUS_CARTS
D_TOTAL_ORDER_INQUIRIES
D_TOTAL_PAYMENT_INQUIRIES
D_TOTAL_INVOICE_INQUIRIES
D_A_LEADS
D_BOOKED_AMT_F
D_BOOKED_AMT_G
D_BOOKED_AMT_G1
REPEAT_VISITS
D_BOOKED_WEB_ORDERS
SYS_NC00073$
D_ASSISTED_WEB_ORDERS
D_TOTAL_BOOKED_AMT_F
D_TOTAL_BOOKED_AMT_G
D_TOTAL_BOOKED_AMT_G1
D_TOTAL_BOOKED_ORDERS
D_OPT_OUTS
D_TOTAL_CNT
VISIT_DURATION
PAGE_VIEWS
SYS_NC00069$
DAILY_UNIQ_VISITORS
Application Object Library - IBW_CMPANLYS_CMPDIM_TIME_MV
Column Name Descritpion
SYS_NC00049$
UMARKER
PAGE_VIEWS
SYS_NC00038$
WEB_REGISTRATIONS
CARTS
SYS_NC00041$
ORDERS
DAILY_UNIQ_VISITORS
SYS_NC00044$
A_LEADS
BOOKED_AMT_F
SYS_NC00047$
BOOKED_AMT_G
BOOKED_AMT_G1
SYS_NC00050$
TIME_ID
SITE_ID
PERIOD_TYPE_ID
SYS_NC00040$
SYS_NC00039$
ENT_YEAR_ID
ENT_QTR_ID
SYS_NC00043$
ENT_PERIOD_ID
WEEK_ID
SYS_NC00046$
REPORT_DATE_JULIAN
D_VISITS
D_VISIT_DURATION
D_PAGE_VIEWS
D_WEB_REGISTRATIONS
TRANSACTION_DATE
D_CARTS
D_ORDERS
D_DAILY_UNIQ_VISITORS
D_A_LEADS
D_BOOKED_AMT_F
D_BOOKED_AMT_G
D_BOOKED_AMT_G1
D_TOTAL_CNT
CAMPAIGN_SOURCE_CODE_ID
SYS_NC00042$
PARENT_SOURCE_CODE_ID
PRIOR_ID
SYS_NC00045$
CURRENCY_CD_F
VISITS
SYS_NC00048$
VISIT_DURATION
Application Object Library - IBW_PRODUCT_TIME_MV
Column Name Descritpion
SYS_NC00036$
SITE_ID
ORDER_ID
SYS_NC00035$
QOT_ORDER_ID
CART_ID
SYS_NC00038$
CURRENCY_CD_F
BOOKED_AMT_F
SYS_NC00041$
BOOKED_AMT_G
BOOKED_AMT_G1
SYS_NC00044$
D_NO_VISITS
D_PAGE_VIEWS
SYS_NC00047$
D_BOOKED_AMT_F
TRANSACTION_DATE
D_BOOKED_AMT_G
SYS_NC00031$
SYS_NC00039$
D_BOOKED_AMT_G1
D_TOT_COL
SYS_NC00034$
TIME_ID
PERIOD_TYPE_ID
SYS_NC00037$
ENT_YEAR_ID
ENT_QTR_ID
SYS_NC00040$
ENT_PERIOD_ID
REPORT_DATE_JULIAN
SYS_NC00043$
WEEK_ID
LEAF_CATEG_ID
D_GID
SYS_NC00046$
SYS_NC00033$
PRODUCT_ID
SYS_NC00042$
VISITANT_ID
VISIT_ID
SYS_NC00045$
NO_VISITS
PAGE_VIEWS
SYS_NC00032$
ORDERS_SITE_VISITS
Application Object Library - IGI_CIS_MTH_RET_PAY_GT
Column Name Descritpion
VENDOR_ID
CHILD_VENDOR_ID
INVOICE_ID
INVOICE_PAYMENT_ID
AMOUNT
DISCOUNT_AMOUNT
LABOUR_COST
MATERIAL_COST
TOTAL_DEDUCTIONS
Application Object Library - IEX_POP_UWQ_SUMM_GT
Column Name Descritpion
OBJECT_ID
OBJECT_TYPE
ORG_ID
Application Object Library - HRI_MDP_SUP_ABSNC_CAT_MV
Column Name Descritpion
SUPERVISOR_PERSON_ID
ABS_DRTN_HRS_UNPLND
ABS_START_BLNC
ABS_NSTART_BLNC
ABS_START_BLNC_PLND
ABS_START_BLNC_UNPLND
ABS_NSTART_BLNC_PLND
ABS_NSTART_BLNC_UNPLND
ABS_NTFCTN_DAYS_START_BLNC
ABS_NTFCTN_DAYS_NSTART_BLNC
ABS_NTFCTN_START_BLNC_PLND
EFFECTIVE_DATE
ABS_NTFCTN_START_BLNC_UNPLND
ABS_NTFCTN_NSTART_BLNC_PLND
ABS_NTFCTN_NSTART_BLNC_UNPLND
ABSENCE_CATEGORY_CODE
DIRECT_RECORD_IND
ABS_DRTN_DAYS
ABS_DRTN_HRS
ABS_DRTN_DAYS_PLND
ABS_DRTN_DAYS_UNPLND
ABS_DRTN_HRS_PLND
Application Object Library - HRI_MDP_SUP_ABSNC_SUP_MV
Column Name Descritpion
SUPERVISOR_PERSON_ID
ABS_START_BLNC
ABS_NSTART_BLNC
ABS_START_BLNC_PLND
ABS_START_BLNC_UNPLND
ABS_NSTART_BLNC_PLND
ABS_NSTART_BLNC_UNPLND
ABS_NTFCTN_DAYS_START_BLNC
ABS_NTFCTN_DAYS_NSTART_BLNC
ABS_NTFCTN_START_BLNC_PLND
ABS_NTFCTN_START_BLNC_UNPLND
EFFECTIVE_DATE
ABS_NTFCTN_NSTART_BLNC_PLND
ABS_NTFCTN_NSTART_BLNC_UNPLND
DIRECT_RECORD_IND
ABS_DRTN_DAYS
ABS_DRTN_HRS
ABS_DRTN_DAYS_PLND
ABS_DRTN_DAYS_UNPLND
ABS_DRTN_HRS_PLND
ABS_DRTN_HRS_UNPLND
Application Object Library - FV_EXTRACT_DETAIL_GT
Column Name Descritpion
EVENT_ID Event identifier
ENTERED_PYA_AMT Entered Prior year amount
ENTERED_PYA_DIFF_AMT Entered Prior year difference amount
ANTICIPATION Denotes whether the amount is anticipated, unanticipated or partial
ANTICIPATED_AMT Anticipated amount
UNANTICIPATED_AMT Unanticipated amount
TCF_AMT Treasury confirmed Amount. Paid amount only from payments that are not voided and are treasury confirmed.
UNEXPENDED_OBLIGATION Unexpended obligation
PAID_UNEXPENDED_OBLIGATION Paid Unexpended obligation
PAID_RECEIVED_AMT Paid portion of unexpended obligation. Receipt must correctly liquidate the obligation based on its paid amount confirmed with Treasury.
UNPAID_UNEXPENDED_OBLIGATION UnPaid Unexpended obligation
LINE_NUMBER Line number
UNPAID_RECEIVED_AMT Unpaid portion of unexpended obligation. Receipt must correctly liquidate the obligation based on its unpaid amount confirmed with Treasury.
UNPAID_OPEN_AMT Calculated financed amount only from payments that are not voided and are treasury confirmed
FUND_TIME_FRAME Fund time frame
RCV_PARENT_SUB_LEDGER_ID Receivable sub ledger identifier
ACCOUNT_VALID_FLAG Flag denotes whether the account is valid for that transaction
ACCOUNT_RULE Account rule
OLD_CCID The Old CCID
RECEIVABLE_WITH_ADVANCE
ENT_COMMITMENT_AMOUNT
ENT_UNPAID_OBL_AMOUNT
APPLICATION_ID Application Identifier
ACC_COMMITMENT_AMOUNT
ACC_UNPAID_OBL_AMOUNT
ENT_UNPAID_OBL_PYA_AMOUNT
ACC_UNPAID_OBL_PYA_AMOUNT
ENT_UNPAID_OBL_PYA_OFF_AMOUNT
ACC_UNPAID_OBL_PYA_OFF_AMOUNT
ENT_ANTICIPATED_BUDGET_AMOUNT
ACC_ANTICIPATED_BUDGET_AMOUNT
ENT_UNANTICIPATED_BUD_AMOUNT
ACC_UNANTICIPATED_BUD_AMOUNT
FUND_VALUE Balancing segment value
ENT_UNRESERVED_BUDGET_AMOUNT
ACC_UNRESERVED_BUDGET_AMOUNT
ENT_CHARGE_AMOUNT
ACC_CHARGE_AMOUNT
ENT_UNPAID_EXP_AMOUNT
ACC_UNPAID_EXP_AMOUNT
ENT_PAID_EXP_AMOUNT
ACC_PAID_EXP_AMOUNT
AR_TRANSACTION_CATEGORY
ACC_PAID_EXP_PYA_OFF_AMOUNT
FUND_CATEGORY Fund category
ENT_PAID_EXP_PYA_OFF_AMOUNT
ENT_PAID_OBL_AMOUNT
ACC_PAID_OBL_AMOUNT
ENT_UNPAID_EXP_PYA_AMOUNT
ACC_UNPAID_EXP_PYA_AMOUNT
ENT_UNPAID_EXP_PYA_OFF_AMOUNT
ACC_UNPAID_EXP_PYA_OFF_AMOUNT
EXP_APPROPRIATIONS_AMOUNT
ENT_PAID_EXP_PYA_AMOUNT
ACC_PAID_EXP_PYA_AMOUNT
FUND_EXPIRED_STATUS Expired status of fund
ACC_EXPENDED_APPROP_AMOUNT
ENT_EXPENDED_APPROP_AMOUNT
TREASURY_SYMBOL_ID
DIRECT_OR_REIMB
PO_DISTRIBUTION_ID
PRIOR_YEAR_FLAG Flag to denote a prior year transaction
ADJUSTMENT_TYPE Upward or Downward adjustment type
NET_PYA_ADJ_AMT Prior year adjustment amount
Application Object Library - FND_SEARCHABLE_CHANGE_LOG
Column Name Descritpion
EVENT_INSTANCE_ID
PK_VALUE_2
PK_NAME_3
PK_VALUE_3
PK_NAME_4
PK_VALUE_4
PK_NAME_5
PK_VALUE_5
CRAWL_STATUS
CHANGE_DATE
OBJECT_NAME
CHANGE_TYPE
ID_TYPE
ROW_FROM
ROW_TO
PK_NAME_1
PK_VALUE_1
PK_NAME_2
Application Object Library - FND_OBJECT_DEFINITIONS
Column Name Descritpion
OBJECT_DEFINITION_ID
END_DATE_ACTIVE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
OBJECT_DEFINITION
OBJECT_REFERENCE
APPLICATION_ID
OBJECT_ID
OBJECT_DEFINITION_TYPE
OBJECT_VERSION
OBJECT_EXTENSION_VERSION
STATUS
ENABLED_FLAG
START_DATE_ACTIVE
Application Object Library - IBY_DOCS_IN_PMT_GT
Column Name Descritpion
PAYMENT_ID
DOCUMENT_AMOUNT
DOCUMENT_CURRENCY_CODE
PAYMENT_GROUPING_NUMBER
DOCUMENT_STATUS
AMOUNT_WITHHELD
PAYMENT_DUE_DATE
DISCOUNT_DATE
INTERNAL_BANK_ACCOUNT_ID
EXT_PAYEE_ID
PAYEE_PARTY_ID
DOCUMENT_PAYABLE_ID
PARTY_SITE_ID
SUPPLIER_SITE_ID
ORG_ID
ORG_TYPE
EXTERNAL_BANK_ACCOUNT_ID
PAYMENT_CURR_DISCOUNT_TAKEN
DELIVERY_CHANNEL_CODE
UNIQUE_REMITTANCE_IDENTIFIER
URI_CHECK_DIGIT
CREATED_BY
CALLING_APP_ID
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
DONT_PAY_FLAG
DONT_PAY_REASON_CODE
DONT_PAY_DESCRIPTION
CALLING_APP_DOC_UNIQUE_REF1
CALLING_APP_DOC_UNIQUE_REF2
CALLING_APP_DOC_UNIQUE_REF3
CALLING_APP_DOC_UNIQUE_REF4
CALLING_APP_DOC_UNIQUE_REF5
PAY_PROC_TRXN_TYPE_CODE
Application Object Library - FUN_BAL_INTER_INT3_GT
Column Name Descritpion
GROUP_ID
LEDGER_ID
LE_ID
ACCOUNTED_AMT_CR
ACCOUNTED_AMT_DR
TYPE
DRIVING_DR_LE_BSV
DRIVING_CR_LE_BSV
LINE_LE_BSV
Application Object Library - FND_SOA_ATTACHMENT
Column Name Descritpion
CREATED_BY
ATTRIB1
ATTRIB2
ATTRIB3
ATTRIB4
ATTRIB5
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
MESSAGE_ID
NAME
MIME_TYPE
BELONGS_TO
Application Object Library - FND_SOA_BODY_PIECE
Column Name Descritpion
CREATED_BY
ATTRIB1
ATTRIB2
ATTRIB3
ATTRIB4
ATTRIB5
BODY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
MESSAGE_ID
BELONGS_TO
PIECE_NO
PIECE
Application Object Library - FND_SOA_REQUEST
Column Name Descritpion
CREATED_BY
RESPONSIBILITY_APPLICATION_ID
NLS_LANGUAGE
SECURITY_GROUP_NAME
IREP_NAME
IP_ADDRESS
TARGET_URI
METHOD
INTERFACE
NO_OF_ATTACHMENTS
ATTRIB1
CREATION_DATE
ATTRIB2
ATTRIB3
ATTRIB4
ATTRIB5
ATTRIB6
ATTRIB7
ATTRIB8
ATTRIB9
ATTRIB10
ATTRIB11
LAST_UPDATED_BY
ATTRIB12
ATTRIB13
ATTRIB14
ATTRIB15
REQUEST_STATUS
RESPONSE_STATUS
REQUEST_STARTED
REQUEST_COMPLETED
REQUEST_RESPONDED
REQUEST_PATTERN
LAST_UPDATE_DATE
EXECUTION_ATTEMPTS
DELIVERY_ATTEMPTS
NO_OF_RESPONSE_ATTACHMENTS
LAST_UPDATE_LOGIN
MESSAGE_ID
REQUEST_TIMESTAMP
USER_ID
RESPONSIBILITY_ID
Application Object Library - FND_SOA_RESPONSE
Column Name Descritpion
CREATED_BY
ERROR_DETAIL
NO_OF_ATTACHMENTS
ATTRIB1
ATTRIB2
ATTRIB3
ATTRIB4
ATTRIB5
ATTRIB6
ATTRIB7
ATTRIB8
CREATION_DATE
ATTRIB9
ATTRIB10
ATTRIB11
ATTRIB12
ATTRIB13
ATTRIB14
ATTRIB15
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
MESSAGE_ID
RESPONSE_TIMESTAMP
STATUS
ERROR_DESCRIPTION
Application Object Library - FND_SOA_RESPONSE_METHOD
Column Name Descritpion
CREATED_BY
ERROR_DETAIL
ATTRIB1
ATTRIB2
ATTRIB3
ATTRIB4
ATTRIB5
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
MESSAGE_ID
METHOD
STATUS
ERROR_DESCRIPTION
Application Object Library - FND_SEGMENT_ATTRIBUTE_VALUES Values of flexfield qualifiers for different segments of key flexfield structures
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_segment_attribute_values.id_flex_code and rownum = 1
LAST_UPDATED_BY Standard Who column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
ATTRIBUTE_VALUE The qualifier value
ID_FLEX_CODE Key flexfield code
ID_FLEX_NUM Key flexfield structure number
APPLICATION_COLUMN_NAME Name of column corresponding to the segment with the flexfield qualifier
SEGMENT_ATTRIBUTE_TYPE Flexfield segment qualifier
LAST_UPDATE_DATE Standard Who column
Application Object Library - FND_SOA_LOG_CATEGORY
Column Name Descritpion
CATEGORY_ID
CATEGORY
CATEGORY_VALUE
LOG_LEVEL
Application Object Library - FND_SOA_LOG_SERVICE_DETAILS
Column Name Descritpion
CATEGORY_ID
CLASS_ID
FUNCTION_ID
LOG_LEVEL
Application Object Library - FND_SOA_RUNTIME_ERROR
Column Name Descritpion
MESSAGE_ID
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ATTRIB1
ATTRIB2
ATTRIB3
ATTRIB4
ATTRIB5
ERROR_DATE
ERROR_CODE
ERROR_SUBCODE
ERROR_REASON
ERROR_NODE
ERROR_ROLE
ERROR_DETAIL
CREATED_BY
Application Object Library - FND_SOA_SERVICE_OPERATIONS
Column Name Descritpion
CLASS_ID
FUNCTION_ID
OVERLOAD_SEQ
PATTERN
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
Application Object Library - FND_SOA_SERVICES
Column Name Descritpion
CLASS_ID
DERIVED_CLASS_ID
WSDL_URL
AUTH_TYPE
DEPLOYED_FLAG
Application Object Library - FWK_PORTLET_GEN_MV
Column Name Descritpion
DOCUMENT_ID
DOCUMENT_NAME
REGION_NAME
REGION_TYPE
APP_SHORT_NAME
Application Object Library - IBY_DOCS_PAYABLE_VAL_GT
Column Name Descritpion
CALLING_APP_ID
DOCUMENT_PAY_CURRENCY
EXCLUSIVE_PAYMENT_FLAG
DELIVERY_CHANNEL_CODE
DELIVERY_CHN_FORMAT_VAL
UNIQUE_REMIT_ID_CODE
PAYMENT_REASON_COMMENTS
SETTLEMENT_PRIORITY
REMITTANCE_MESSAGE1
REMITTANCE_MESSAGE2
REMITTANCE_MESSAGE3
CALLING_APP_DOC_ID1
URI_CHECK_DIGIT
EXTERNAL_BANK_ACCOUNT_ID
INT_BANK_NUM
INT_BANK_NAME
INT_BANK_NAME_ALT
INT_BANK_BRANCH_NUM
INT_BANK_BRANCH_NAME
INT_BANK_BRANCH_NAME_ALT
INT_BANK_ACC_NUM
INT_BANK_ACC_NAME
CALLING_APP_DOC_ID2
INT_BANK_ACC_NAME_ALT
INT_BANK_ACC_TYPE
INT_BANK_ACC_IBAN
INT_BANK_ACC_CURR
INT_BANK_ASSIGNED_ID1
INT_BANK_ASSIGNED_ID2
INT_EFT_USER_NUMBER
INT_BANK_ACC_CHK_DGTS
INT_EFT_REQ_IDENTIFIER
INT_BANK_ACC_SHORT_NAME
CALLING_APP_DOC_ID3
INT_BANK_ACC_HOLDER_NAME
INT_BANK_ACC_HOLDER_NAME_ALT
PAYER_LE_NAME
PAYER_LE_COUNTRY
PAYER_PHONE
PAYER_REGISTRATION_NUMBER
PAYER_TAX_REGISTRATION_NUMBER
EXT_BANK_NUM
EXT_BANK_NAME
EXT_BANK_NAME_ALT
CALLING_APP_DOC_ID4
EXT_BANK_BRANCH_NUM
EXT_BANK_BRANCH_NAME
EXT_BANK_BRANCH_NAME_ALT
EXT_BANK_COUNTRY
EXT_BANK_BRANCH_ADDR1
EXT_BANK_BRANCH_COUNTRY
EXT_BANK_ACC_NUM
EXT_BANK_ACC_NAME
EXT_BANK_ACC_NAME_ALT
EXT_BANK_ACC_TYPE
CALLING_APP_DOC_ID5
EXT_BANK_ACC_IBAN
EXT_BANK_ACC_CHK_DGTS
EXT_BANK_ACC_SHORT_NAME
EXT_BANK_ACC_HOLDER_NAME
EXT_BANK_ACC_HOLDER_NAME_ALT
EXT_BANK_ACC_BIC
PAYEE_PARTY_NAME
PAYEE_PARTY_ADDR1
PAYEE_PARTY_ADDR2
PAYEE_PARTY_ADDR3
PAY_PROC_TRXN_TYPE_CD
PAYEE_PARTY_CITY
PAYEE_PARTY_STATE
PAYEE_PARTY_PROVINCE
PAYEE_PARTY_COUNTY
PAYEE_PARTY_POSTAL
PAYEE_PARTY_COUNTRY
BANK_CHARGE_BEARER
PAYMENT_REASON_CODE
PAYMENT_METHOD_CD
PAYEE_PAYMENT_FORMAT_CD
DOCUMENT_ID
PAYEE_PARTY_SITE_NAME
INT_BANK_BRANCH_TYPE
EXT_BANK_BRANCH_TYPE
DOCUMENT_AMOUNT

No hay comentarios:

Publicar un comentario