This view returns information about individual columns in application tables, consistent with the technical reference manual. Also returned is information on whether this column is related to a flexfield, and other values identifying the flexfield that is using the table column and the value set to which this column belongs.

This view returns shared QuickCodes that are used by Oracle Applications for QuickPicks. Each row includes an application identifier, a QuickCode type, the QuickCode, and the meaning of the QuickCode.

Information about Concurrent Managers and their specialization rules. Included are application identifier, a complex rule for each identifier, and the name of the complex rule.

This view returns information about concurrent programs. Each row includes a name and description of the concurrent program. Each row also includes the execution methods for the program, the argument method, and whether the program is constrained.

This view returns information about the arguments or parameters for pending and completed concurrent requests. This view has arguments 26 through 100 available and the request identifier.

This view returns information about concurrent programs. Each row includes a name and description of the concurrent program. Each row also includes the execution methods for the program, the argument method, and whether the program is constrained.

This view returns historical information about pending and completed concurrent requests and their parameters, such as who submitted, the request type, whether the request should run sequentially with other requests in the same logical database or instance.

This view stores information about currencies. Each row includes the Currency_Code established by ISO (International Standards Organization) standard, the name of the Currency, an Enabled_Flag to indicate whether the Currency is enabled for use at your site, a Currency_Flag to indicate if this is a Currency or a statistical unit, and Issuing_Territory_Code which indicates the issuing country. Issuing_Territory_Description and Issuing_Territory_Short_Name are listed too.

Basic information about descriptive flexfields. This view only returns information about table related descriptive flexfields that have actually been defined, Standard Report Submission descriptive flexfields are not available here.

Basic information about all table related descriptive flexfields is available. All possible table related descriptive flexfields are returned, even if no segments are actually defined for the flexfield.

This view returns information about incompatible concurrent programs. This means that the programs cannot run at the same time. Each row identifies a concurrent program and another concurrent program that is incompatible with it.

This view returns information about key flexfield cross-validation rules. Each row includes values that identify the application with which the key flexfield is registered, the key flexfield structure, and the name and description of the cross-validation rule.

This view stores information about flexfield hierarchies. Each row includes a value set identifier and name, a hierarchy identifier, and a hierarchy name. One row is returned for each flexfield hierarchy. Oracle Applications use this information to build and process multi-level hierarchies of flexfield data.

This view returns information about child value ranges for key flexfield segment values. Each row includes an identification of the parent value the range belongs to, as well as the low and high values that make up the range of child values.

This view returns information about flexfield and segment qualifiers. A flexfield qualifier describes segments defined when customizing key flexfields. Each row includes a key flexfield code, a flexfield qualifier, a segment qualifier, and the date these qualifiers were assigned to the flexfield. One row is returned for each qualifier assignment.

This view returns information about key flexfield value security rules. Each row includes the security rule's name and description, as well as the Error_Message a user sees after entering a value that violates the rule.

This view returns information about the registered foreign keys in your applications. Each row includes the name and description of the foreign key, the primary key it references, the cascade behavior, the relation, and any special condition.

This view returns information about your registered application forms. Each row includes the form's file name, the EasyForm title, and a description of the form.

This view returns the accounting flexfield value security rules associated with each user and responsibility. The view lists the details of the value rule including the Segment_Name and the ranges of included or excluded values.

This view returns information about individual columns in the Application indexes. Each row includes the index column and its sequence in the index.

This view returns information about the registered indexes in Oracle Applications. Each row includes the name and description of the index, information about the storage parameters for the index and an Auto_Size flag which indicates whether the install should automatically apply a sizing factor to the storage parameters.

This view returns information regarding national dialects. The territory is also available for each available dialect.

For version 10.7 - 10.9999, This view is used to select the CURRENCY_CODE and NAME from FND_CURRENCIES. For version 11+, This view is used to select the CURRENCY_CODE and NAME from FND_CURRENCIES_TL. This LOV was designed to work with Answers.

This view selects expression 0 from n_application_owners where rownum = 1.

For version 9.0 - 10.9999, This view is used to select the APPLICATION_NAME from FND_APPLICATION. For version 11+, This view is used to select the APPLICATION_NAME from N_FND_APPLICATION_VL. This LOV was designed to work with Answers.

This view is used to select the REQUEST_ID from FND_CONCURRENT_REQUESTS. This LOV was designed to work with Answers.

This view selects expression sysdate from n_application_owners where rownum = 1.

For version 10.7 - 10.9999, This view is used to select the DESCRIPTIVE_FLEXFIELD_NAME from FND_DESCR_FLEX_COLUMN_USAGES. For version 11+, This view is used to select the DESCRIPTIVE_FLEXFIELD_NAME from N_FND_DESCR_FLEX_COL_USAGE_VL. This LOV was designed to work with Answers.

In query 1, for version 10.7 - 11.4999, This view is used to select the PRINTER_NAME from FND_PRINTER. For version 11.5+, This view is used to select the PRINTER_NAME from N_FND_PRINTER_VL. In query 2, for version 11+, this view is used to gather general printer information.

In query 1, for version 10.7 - 11.4999, This view is used to select the PRINTER_NAME from FND_PRINTER. For version 11.5+, This view is used to select the PRINTER_NAME from N_FND_PRINTER_VL. In query 2, for version 11+, this view is used to gather general printer information.

This view is used to select the USER_NAME from FND_USERS. This LOV was designed to work with Answers.

This view is used to select the LOOKUP_CODE for YES/NO values from FND_LOOKUP_VALUES. This LOV was designed to work with Answers.

This view returns information about defined menus. Oracle and site specific menus are returned, as well as detailed information about submenus, macros, forms, and subroutines.

This view returns information about printer drivers and subroutines that are defined with Oracle Application Object Library. Each row includes a driver name, user driver name or title for the driver, an optional platform code, and the initialization and reset strings that are used to format printers.

This view returns information about all the printers that are defined with Oracle Application Object Library. Each row includes a printer type, a print style, and the name of the printer driver.

This view returns information about user profile options. Each row includes the actual profile option name, the more descriptive end-user name, and a description of the profile option.

This view returns information about report security groups. Each row includes a value identifying a report security group, the name of a report security group, the group code, and a description of the report security group. One row is returned for each report security group you defined in the Define Report Group form.

This view returns information about responsibilities. Each row includes the name and description of the responsibility, the application it belongs to, and values that identify the main menu and the first form that it uses.

This view returns alias information for shorthand flexfield entry. This capability provides users with a quick way to enter key flexfield data in Oracle applications. Each row includes the name and description of the shorthand alias, as well as values that identify the key flexfield structure to which the alias belongs.

This view returns information about the registered tables in the Applications. Each row includes Table_Name, Application_Name, User_Table_Name (title), and a Description.

Information about user logins and forms that they have accessed. This view only returns information for users whose Signon Audit level has been set at the User level or higher. Responsibility information is only returned if the Signon Audit Level is set to 'Responsibility' or higher for a particular user.

Basic information about Users and their Responsibilities as defined to Application Object Library. Each row includes the username (what a user types in at the sign-on screen) and information on when the user should change the password. Each row also contains information on when the user last signed on, start and end dates for when a username is valid and a description of the user.