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. |
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