eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
Oracle eBusiness Suite Technical Reference
Release 11i - Copyright (c) 2001 - 2005 Oracle
This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is
provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and
other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to
safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or
a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential
Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c)
restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was
disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends
or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or
by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this
TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter,
please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is'
with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements.
Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this
TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's
responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the
Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs.
Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose.
Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and
use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the
applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal
Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this
TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500
Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™,
.comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM,
GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™,
NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™,
On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE ®, Oracle Business OnLine®,
OracleDevConnect SM, Oracle® Discoverer™,
Oracle® Expert™, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP™,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile™, Oracle Names®,
Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services™, Oracle® SQL*TutorSM,
OracleSTERLING SM, Oracle Store®,
Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™,
PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®,
Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®,
Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™,
Secure Access 2.0™, Secure Network Services®, Security Without Compromise™,
SellingPoint®, SQL*Plus®, Tutor™ are trademarks or
registered trademarks of Oracle. Other names may be trademarks of their respective owners.
The absence of a product or service name, slogan, or logo from this list does not constitute a
waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan,
or logo.
eTRM - FF Tables and Views
TABLE - HR.FF_ARCHIVE_ITEMS
TABLE - HR.FF_ARCHIVE_ITEM_CONTEXTS
TABLE - HR.FF_COMPILED_INFO_F
TABLE - HR.FF_CONTEXTS
TABLE - HR.FF_DATABASE_ITEMS
TABLE - HR.FF_DATABASE_ITEMS_TL
TABLE - HR.FF_FDI_USAGES_F
TABLE - HR.FF_FORMULAS_F
TABLE - HR.FF_FORMULA_TYPES
TABLE - HR.FF_FORMULA_TYPE_COMPONENTS
TABLE - HR.FF_FTYPE_CONTEXT_USAGES
TABLE - HR.FF_FUNCTIONS
TABLE - HR.FF_FUNCTION_CONTEXT_USAGES
TABLE - HR.FF_FUNCTION_PARAMETERS
TABLE - HR.FF_GLOBALS_F
TABLE - HR.FF_HARNESS
TABLE - HR.FF_LOOKUPS
TABLE - HR.FF_QP_REPORTS
TABLE - HR.FF_ROUTES
TABLE - HR.FF_ROUTE_CONTEXT_USAGES
TABLE - HR.FF_ROUTE_PARAMETERS
TABLE - HR.FF_ROUTE_PARAMETER_VALUES
TABLE - HR.FF_USER_ENTITIES
VIEW - APPS.FFBV_CONTEXT
VIEW - APPS.FFBV_FORMULA
VIEW - APPS.FFBV_FORMULA_TYPE
VIEW - APPS.FF_ARCHIVE_ITEMS_V
VIEW - APPS.FF_ARCHIVE_ITEM_CONTEXTS_V
VIEW - APPS.FF_COMPILED_INFO
VIEW - APPS.FF_COMPILED_INFO_X
VIEW - APPS.FF_DATABASE_ITEMS_V
VIEW - APPS.FF_DATABASE_ITEMS_VL
VIEW - APPS.FF_DATABASE_ITEMS_VL1
VIEW - APPS.FF_DATABASE_ITEMS_VL2
VIEW - APPS.FF_FDI_USAGES
VIEW - APPS.FF_FDI_USAGES_X
VIEW - APPS.FF_FORMULAS
VIEW - APPS.FF_FORMULAS_F_V
VIEW - APPS.FF_FORMULAS_LOV
VIEW - APPS.FF_FORMULAS_X
VIEW - APPS.FF_FUNCTIONS_V
VIEW - APPS.FF_FUNCTION_CONTEXT_USAGES_V
VIEW - APPS.FF_FUNCTION_PARAMETERS_V
VIEW - APPS.FF_GLOBALS
VIEW - APPS.FF_GLOBALS_F_V
VIEW - APPS.FF_GLOBALS_X
Table: FF_ARCHIVE_ITEMS
Description: Archive recording results of evaluating database items.
Primary Key: FF_ARCHIVE_ITEMS_PK
ARCHIVE_ITEM_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_ARCHIVE_ITEMS.USER_ENTITY_ID
FF_USER_ENTITIES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
FF_ARCHIVE_ITEM_CONTEXTS.ARCHIVE_ITEM_ID
FF_ARCHIVE_ITEMS
[top of page]
HR.FF_ARCHIVE_ITEMS does not reference any database object
HR.FF_ARCHIVE_ITEMS is referenced by following:
APPS
SYNONYM - FF_ARCHIVE_ITEMS
TRIGGER - FF_ARCHIVE_ITEMS_BRU
TRIGGER - FF_ARCHIVE_ITEMS_WHO
PUBLIC
SYNONYM - FF_ARCHIVE_ITEMS
[top of page]
Table: FF_ARCHIVE_ITEM_CONTEXTS
Description: Context values for retrieving FF_ARCHIVE_ITEMS.
Primary Key: FF_ARCHIVE_ITEM_CONTEXT_PK
ARCHIVE_ITEM_ID
CONTEXT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_ARCHIVE_ITEM_CONTEXTS.ARCHIVE_ITEM_ID
FF_ARCHIVE_ITEMS
[top of page]
HR.FF_ARCHIVE_ITEM_CONTEXTS does not reference any database object
HR.FF_ARCHIVE_ITEM_CONTEXTS is referenced by following:
APPS
SYNONYM - FF_ARCHIVE_ITEM_CONTEXTS
PUBLIC
SYNONYM - FF_ARCHIVE_ITEM_CONTEXTS
[top of page]
Table: FF_COMPILED_INFO_F
Description: Compiled versions of user-defined formulas.
Primary Key: FF_COMPILED_INFO_F_PK
FORMULA_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
[top of page]
HR.FF_COMPILED_INFO_F does not reference any database object
HR.FF_COMPILED_INFO_F is referenced by following:
APPS
SYNONYM - FF_COMPILED_INFO_F
PUBLIC
SYNONYM - FF_COMPILED_INFO_F
[top of page]
Table: FF_CONTEXTS
Description: Identifies the context for specific formulas, for example EMPLOYEE_ID.
Primary Key: FF_CONTEXTS_PK
CONTEXT_ID
Primary Key: FF_CONTEXTS_UK2
CONTEXT_NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
FF_FTYPE_CONTEXT_USAGES.CONTEXT_ID
FF_CONTEXTS
FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID
FF_CONTEXTS
FF_ROUTE_CONTEXT_USAGES.CONTEXT_ID
FF_CONTEXTS
PAY_ACTION_CONTEXTS.CONTEXT_ID
FF_CONTEXTS
PAY_BALANCE_CONTEXT_VALUES.CONTEXT_ID
FF_CONTEXTS
[top of page]
HR.FF_CONTEXTS does not reference any database object
HR.FF_CONTEXTS is referenced by following:
APPS
SYNONYM - FF_CONTEXTS
TRIGGER - FF_CONTEXTS_BRD
TRIGGER - FF_CONTEXTS_BRI
TRIGGER - FF_CONTEXTS_BRU
PUBLIC
SYNONYM - FF_CONTEXTS
[top of page]
Table: FF_DATABASE_ITEMS
Description: Basic items of data in the application database.
Primary Key: FF_DATABASE_ITEMS_PK
USER_NAME
USER_ENTITY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_DATABASE_ITEMS.USER_ENTITY_ID
FF_USER_ENTITIES
[top of page]
HR.FF_DATABASE_ITEMS does not reference any database object
HR.FF_DATABASE_ITEMS is referenced by following:
APPS
SYNONYM - FF_DATABASE_ITEMS
TRIGGER - FF_DATABASE_ITEMS_ARI
TRIGGER - FF_DATABASE_ITEMS_BRD
TRIGGER - FF_DATABASE_ITEMS_BRI
TRIGGER - FF_DATABASE_ITEMS_BRU
TRIGGER - FF_DATABASE_ITEMS_WHO
PUBLIC
SYNONYM - FF_DATABASE_ITEMS
[top of page]
Table: FF_DATABASE_ITEMS_TL
Description: Translated database item definitions.
Primary Key: FF_DATABASE_ITEMS_TL_PK
USER_NAME
USER_ENTITY_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_DATABASE_ITEMS_TL.USER_ENTITY_ID
FF_USER_ENTITIES
[top of page]
HR.FF_DATABASE_ITEMS_TL does not reference any database object
HR.FF_DATABASE_ITEMS_TL is referenced by following:
APPS
SYNONYM - FF_DATABASE_ITEMS_TL
TRIGGER - FF_DATABASE_ITEMS_TL041416_WHO
PUBLIC
SYNONYM - FF_DATABASE_ITEMS_TL
[top of page]
Table: FF_FDI_USAGES_F
Description: Compiler generated description of data items used in a formula.
Primary Key: FF_FDI_USAGES_F_PK
FORMULA_ID
ITEM_NAME
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_FDI_USAGES_F.ROUTE_ID
FF_ROUTES
[top of page]
HR.FF_FDI_USAGES_F does not reference any database object
HR.FF_FDI_USAGES_F is referenced by following:
APPS
SYNONYM - FF_FDI_USAGES_F
PUBLIC
SYNONYM - FF_FDI_USAGES_F
[top of page]
Table: FF_FORMULAS_F
Description: Formula definitions and text.
Primary Key: FF_FORMULAS_F_PK
FORMULA_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Primary Key: FF_FORMULAS_F_UK2
FORMULA_NAME
FORMULA_TYPE_ID
BUSINESS_GROUP_ID
LEGISLATION_CODE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_FORMULAS_F.FORMULA_TYPE_ID
FF_FORMULA_TYPES
[top of page]
HR.FF_FORMULAS_F does not reference any database object
HR.FF_FORMULAS_F is referenced by following:
APPS
SYNONYM - FF_FORMULAS_F
TRIGGER - FF_FORMULAS_F_BRI
TRIGGER - FF_FORMULAS_F_BRU
TRIGGER - FF_FORMULAS_F_MNT_TL_ARI
TRIGGER - FF_FORMULAS_F_MNT_TL_ARU
TRIGGER - FF_FORMULAS_F_MNT_TL_ASD
TRIGGER - FF_FORMULAS_F_MNT_TL_ASI
TRIGGER - FF_FORMULAS_F_MNT_TL_BRD
TRIGGER - FF_FORMULAS_F_WHO
PUBLIC
SYNONYM - FF_FORMULAS_F
[top of page]
Table: FF_FORMULA_TYPES
Description: Used to define groups of formulas to associate with formula contexts.
Primary Key: FF_FORMULA_TYPES_PK
FORMULA_TYPE_ID
Primary Key: FF_FORMULA_TYPES_UK2
FORMULA_TYPE_NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
FF_FORMULAS_F.FORMULA_TYPE_ID
FF_FORMULA_TYPES
FF_FORMULA_TYPE_COMPONENTS.FORMULA_TYPE_ID
FF_FORMULA_TYPES
FF_FTYPE_CONTEXT_USAGES.FORMULA_TYPE_ID
FF_FORMULA_TYPES
FF_QP_REPORTS.FORMULA_TYPE_ID
FF_FORMULA_TYPES
[top of page]
HR.FF_FORMULA_TYPES does not reference any database object
HR.FF_FORMULA_TYPES is referenced by following:
APPS
SYNONYM - FF_FORMULA_TYPES
TRIGGER - FF_FORMULA_TYPES_WHO
PUBLIC
SYNONYM - FF_FORMULA_TYPES
[top of page]
Table: FF_FORMULA_TYPE_COMPONENTS
Description: Used to define components, such as inputs and outputs, associated with a formula type.
Primary Key: FF_FORMULA_TYPE_COMPONENTS_PK
COMPONENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_FORMULA_TYPE_COMPONENTS.FORMULA_TYPE_ID
FF_FORMULA_TYPES
[top of page]
HR.FF_FORMULA_TYPE_COMPONENTS does not reference any database object
HR.FF_FORMULA_TYPE_COMPONENTS is referenced by following:
APPS
SYNONYM - FF_FORMULA_TYPE_COMPONENTS
TRIGGER - FF_FORMULA_TYPE_COMPONENTS_WHO
PUBLIC
SYNONYM - FF_FORMULA_TYPE_COMPONENTS
[top of page]
Table: FF_FTYPE_CONTEXT_USAGES
Description: Contexts for a specific formula type.
Primary Key: FF_FTYPE_CONTEXT_USAGES_PK
FORMULA_TYPE_ID
CONTEXT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_FTYPE_CONTEXT_USAGES.FORMULA_TYPE_ID
FF_FORMULA_TYPES
FF_FTYPE_CONTEXT_USAGES.CONTEXT_ID
FF_CONTEXTS
[top of page]
HR.FF_FTYPE_CONTEXT_USAGES does not reference any database object
HR.FF_FTYPE_CONTEXT_USAGES is referenced by following:
APPS
SYNONYM - FF_FTYPE_CONTEXT_USAGES
TRIGGER - FF_FTYPE_CONTEXT_USAGES_BRD
TRIGGER - FF_FTYPE_CONTEXT_USAGES_BRU
PUBLIC
SYNONYM - FF_FTYPE_CONTEXT_USAGES
[top of page]
Table: FF_FUNCTIONS
Description: FastFormula Function definitions.
Primary Key: FF_FUNCTIONS_PK
FUNCTION_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID
FF_FUNCTIONS
FF_FUNCTION_PARAMETERS.FUNCTION_ID
FF_FUNCTIONS
[top of page]
HR.FF_FUNCTIONS does not reference any database object
HR.FF_FUNCTIONS is referenced by following:
APPS
SYNONYM - FF_FUNCTIONS
TRIGGER - FF_FUNCTIONS_BRI
TRIGGER - FF_FUNCTIONS_BRU
TRIGGER - FF_FUNCTIONS_OVN
TRIGGER - FF_FUNCTIONS_WHO
PUBLIC
SYNONYM - FF_FUNCTIONS
[top of page]
Table: FF_FUNCTION_CONTEXT_USAGES
Description: Contexts required by a function.
Primary Key: FF_FUNCTION_CONTEXT_USAGES_PK
FUNCTION_ID
SEQUENCE_NUMBER
Primary Key: FF_FUNCTION_CONTEXT_USAGES_UK2
FUNCTION_ID
CONTEXT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID
FF_FUNCTIONS
FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID
FF_CONTEXTS
[top of page]
HR.FF_FUNCTION_CONTEXT_USAGES does not reference any database object
HR.FF_FUNCTION_CONTEXT_USAGES is referenced by following:
APPS
SYNONYM - FF_FUNCTION_CONTEXT_USAGES
TRIGGER - FF_FUNCTION_CONTEXT_USAGES_OVN
TRIGGER - FF_FUNCTION_CONTEXT_USAGES_WHO
PUBLIC
SYNONYM - FF_FUNCTION_CONTEXT_USAGES
[top of page]
Table: FF_FUNCTION_PARAMETERS
Description: Definitions of parameters for a specific FastFormula function.
Primary Key: FF_FUNCTION_PARAMETERS_PK
FUNCTION_ID
SEQUENCE_NUMBER
Primary Key: FF_FUNCTION_PARAMETERS_UK2
FUNCTION_ID
NAME
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_FUNCTION_PARAMETERS.FUNCTION_ID
FF_FUNCTIONS
[top of page]
HR.FF_FUNCTION_PARAMETERS does not reference any database object
HR.FF_FUNCTION_PARAMETERS is referenced by following:
APPS
SYNONYM - FF_FUNCTION_PARAMETERS
TRIGGER - FF_FUNCTION_PARAMETERS_OVN
TRIGGER - FF_FUNCTION_PARAMETERS_WHO
PUBLIC
SYNONYM - FF_FUNCTION_PARAMETERS
[top of page]
Table: FF_GLOBALS_F
Description: Global Values and data types.
Primary Key: FF_GLOBALS_F_PK
GLOBAL_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Primary Key: FF_GLOBALS_F_UK2
GLOBAL_NAME
BUSINESS_GROUP_ID
LEGISLATION_CODE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
[top of page]
HR.FF_GLOBALS_F does not reference any database object
HR.FF_GLOBALS_F is referenced by following:
APPS
SYNONYM - FF_GLOBALS_F
TRIGGER - FF_GLOBALS_F_AD
TRIGGER - FF_GLOBALS_F_ASD
TRIGGER - FF_GLOBALS_F_BD
TRIGGER - FF_GLOBALS_F_BRD
TRIGGER - FF_GLOBALS_F_BRI
TRIGGER - FF_GLOBALS_F_BRU
TRIGGER - FF_GLOBALS_F_BSD
TRIGGER - FF_GLOBALS_F_MNT_TL_ARI
TRIGGER - FF_GLOBALS_F_MNT_TL_ARU
TRIGGER - FF_GLOBALS_F_MNT_TL_ASD
TRIGGER - FF_GLOBALS_F_MNT_TL_ASI
TRIGGER - FF_GLOBALS_F_MNT_TL_BRD
TRIGGER - FF_GLOBALS_F_OVN
TRIGGER - FF_GLOBALS_F_WHO
PUBLIC
SYNONYM - FF_GLOBALS_F
[top of page]
Table: FF_HARNESS
Description: Not currently used.
Primary Key: FF_HARNESS_PK
TEST_ID
FORMULA_ID
ITEM_NAME
USAGE
[top of page]
HR.FF_HARNESS does not reference any database object
HR.FF_HARNESS is referenced by following:
APPS
SYNONYM - FF_HARNESS
TRIGGER - FF_HARNESS_WHO
PUBLIC
SYNONYM - FF_HARNESS
[top of page]
Table: FF_LOOKUPS
Description: Lookups used specifically for FastFormula.
Primary Key: FF_LOOKUPS_PK
LOOKUP_TYPE
LOOKUP_CODE
[top of page]
HR.FF_LOOKUPS does not reference any database object
HR.FF_LOOKUPS is referenced by following:
APPS
SYNONYM - FF_LOOKUPS
TRIGGER - FF_LOOKUPS_WHO
PUBLIC
SYNONYM - FF_LOOKUPS
[top of page]
Table: FF_QP_REPORTS
Description: QuickPaint report definitions.
Primary Key: FF_QP_REPORTS_PK
QP_REPORT_ID
Primary Key: FF_QP_REPORTS_UK2
QP_REPORT_NAME
FORMULA_TYPE_ID
BUSINESS_GROUP_ID
LEGISLATION_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_QP_REPORTS.FORMULA_TYPE_ID
FF_FORMULA_TYPES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
PER_QUICKPAINT_INVOCATIONS.QP_REPORT_ID
FF_QP_REPORTS
[top of page]
HR.FF_QP_REPORTS does not reference any database object
HR.FF_QP_REPORTS is referenced by following:
APPS
SYNONYM - FF_QP_REPORTS
TRIGGER - FF_QP_REPORTS_WHO
PUBLIC
SYNONYM - FF_QP_REPORTS
[top of page]
Table: FF_ROUTES
Description: FROM and WHERE clauses of a SQL statement for a specific database item.
Primary Key: FF_ROUTES_PK
ROUTE_ID
Primary Key: FF_ROUTES_UK2
ROUTE_NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
FF_FDI_USAGES_F.ROUTE_ID
FF_ROUTES
FF_ROUTE_CONTEXT_USAGES.ROUTE_ID
FF_ROUTES
FF_ROUTE_PARAMETERS.ROUTE_ID
FF_ROUTES
FF_USER_ENTITIES.ROUTE_ID
FF_ROUTES
PAY_BALANCE_DIMENSIONS.ROUTE_ID
FF_ROUTES
PAY_DIMENSION_ROUTES.ROUTE_ID
FF_ROUTES
[top of page]
HR.FF_ROUTES does not reference any database object
HR.FF_ROUTES is referenced by following:
APPS
SYNONYM - FF_ROUTES
TRIGGER - FF_ROUTES_WHO
PUBLIC
SYNONYM - FF_ROUTES
[top of page]
Table: FF_ROUTE_CONTEXT_USAGES
Description: A single usage of a context as a bind variable in the ROUTE sql statement.
Primary Key: FF_ROUTE_CONTEXT_USAGES_PK
ROUTE_ID
CONTEXT_ID
Primary Key: FF_ROUTE_CONTEXT_USAGES_UK2
ROUTE_ID
SEQUENCE_NO
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_ROUTE_CONTEXT_USAGES.CONTEXT_ID
FF_CONTEXTS
FF_ROUTE_CONTEXT_USAGES.ROUTE_ID
FF_ROUTES
[top of page]
HR.FF_ROUTE_CONTEXT_USAGES does not reference any database object
HR.FF_ROUTE_CONTEXT_USAGES is referenced by following:
APPS
SYNONYM - FF_ROUTE_CONTEXT_USAGES
TRIGGER - FF_ROUTE_CONTEXT_USAGES_BRD
TRIGGER - FF_ROUTE_CONTEXT_USAGES_BRI
PUBLIC
SYNONYM - FF_ROUTE_CONTEXT_USAGES
[top of page]
Table: FF_ROUTE_PARAMETERS
Description: Parameters that can be passed to a ROUTE to restrict the number of rows returned by the ROUTE.
Primary Key: FF_ROUTE_PARAMETERS_PK
ROUTE_PARAMETER_ID
Primary Key: FF_ROUTE_PARAMETERS_UK2
ROUTE_ID
SEQUENCE_NO
Primary Key: FF_ROUTE_PARAMETERS_UK3
PARAMETER_NAME
ROUTE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_ROUTE_PARAMETERS.ROUTE_ID
FF_ROUTES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
FF_ROUTE_PARAMETER_VALUES.ROUTE_PARAMETER_ID
FF_ROUTE_PARAMETERS
[top of page]
HR.FF_ROUTE_PARAMETERS does not reference any database object
HR.FF_ROUTE_PARAMETERS is referenced by following:
APPS
SYNONYM - FF_ROUTE_PARAMETERS
TRIGGER - FF_ROUTE_PARAMETERS_BRI
TRIGGER - FF_ROUTE_PARAMETERS_BRUD
PUBLIC
SYNONYM - FF_ROUTE_PARAMETERS
[top of page]
Table: FF_ROUTE_PARAMETER_VALUES
Description: Values provided for route parameters by a database item.
Primary Key: FF_ROUTE_PARAMETER_VALUES_PK
ROUTE_PARAMETER_ID
USER_ENTITY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_ROUTE_PARAMETER_VALUES.USER_ENTITY_ID
FF_USER_ENTITIES
FF_ROUTE_PARAMETER_VALUES.ROUTE_PARAMETER_ID
FF_ROUTE_PARAMETERS
[top of page]
HR.FF_ROUTE_PARAMETER_VALUES does not reference any database object
HR.FF_ROUTE_PARAMETER_VALUES is referenced by following:
APPS
SYNONYM - FF_ROUTE_PARAMETER_VALUES
TRIGGER - FF_ROUTE_PARAMETER_VALUES_WHO
TRIGGER - FF_RPV_BRI
TRIGGER - FF_RPV_BRUD
PUBLIC
SYNONYM - FF_ROUTE_PARAMETER_VALUES
[top of page]
Table: FF_USER_ENTITIES
Description: Table and selection criteria combination used to define database items.
Primary Key: FF_USER_ENTITIES_PK
USER_ENTITY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
FF_USER_ENTITIES.ROUTE_ID
FF_ROUTES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
FF_ARCHIVE_ITEMS.USER_ENTITY_ID
FF_USER_ENTITIES
FF_DATABASE_ITEMS.USER_ENTITY_ID
FF_USER_ENTITIES
FF_DATABASE_ITEMS_TL.USER_ENTITY_ID
FF_USER_ENTITIES
FF_ROUTE_PARAMETER_VALUES.USER_ENTITY_ID
FF_USER_ENTITIES
[top of page]
HR.FF_USER_ENTITIES does not reference any database object
HR.FF_USER_ENTITIES is referenced by following:
APPS
SYNONYM - FF_USER_ENTITIES
TRIGGER - FF_USER_ENTITIES_ARD
TRIGGER - FF_USER_ENTITIES_BRD
TRIGGER - FF_USER_ENTITIES_BRI
TRIGGER - FF_USER_ENTITIES_BRU
TRIGGER - FF_USER_ENTITIES_WHO
PUBLIC
SYNONYM - FF_USER_ENTITIES
[top of page]
View: FFBV_CONTEXT
[top of page]
APPS.FFBV_CONTEXT references the following:
APPS
SYNONYM - FF_CONTEXTS
PACKAGE - HR_BIS
APPS.FFBV_CONTEXT is referenced by following:
PUBLIC
SYNONYM - FFBV_CONTEXT
[top of page]
View: FFBV_FORMULA
[top of page]
APPS.FFBV_FORMULA references the following:
APPS
SYNONYM - FF_FORMULAS_F
PACKAGE - HR_BIS
APPS.FFBV_FORMULA is referenced by following:
PUBLIC
SYNONYM - FFBV_FORMULA
[top of page]
View: FFBV_FORMULA_TYPE
[top of page]
APPS.FFBV_FORMULA_TYPE references the following:
APPS
SYNONYM - FF_FORMULA_TYPES
PACKAGE - HR_BIS
APPS.FFBV_FORMULA_TYPE is referenced by following:
PUBLIC
SYNONYM - FFBV_FORMULA_TYPE
[top of page]
View: FF_ARCHIVE_ITEMS_V
[top of page]
APPS.FF_ARCHIVE_ITEMS_V references the following:
APPS
SYNONYM - FF_ARCHIVE_ITEMS
SYNONYM - FF_DATABASE_ITEMS
SYNONYM - FND_SESSIONS
SYNONYM - PAY_REPORT_FORMAT_ITEMS_F
APPS.FF_ARCHIVE_ITEMS_V is referenced by following:
PUBLIC
SYNONYM - FF_ARCHIVE_ITEMS_V
[top of page]
View: FF_ARCHIVE_ITEM_CONTEXTS_V
[top of page]
APPS.FF_ARCHIVE_ITEM_CONTEXTS_V references the following:
APPS
SYNONYM - FF_ARCHIVE_ITEM_CONTEXTS
PACKAGE - FF_ARCHIVE_UTILS
SYNONYM - FF_CONTEXTS
PACKAGE - FND_PROFILE
APPS.FF_ARCHIVE_ITEM_CONTEXTS_V is referenced by following:
PUBLIC
SYNONYM - FF_ARCHIVE_ITEM_CONTEXTS_V
[top of page]
View: FF_COMPILED_INFO
[top of page]
APPS.FF_COMPILED_INFO references the following:
APPS
SYNONYM - FF_COMPILED_INFO_F
SYNONYM - FND_SESSIONS
APPS.FF_COMPILED_INFO is referenced by following:
APPS
PACKAGE BODY - PAY_US_GARN_UPGRADE
PUBLIC
SYNONYM - FF_COMPILED_INFO
[top of page]
View: FF_COMPILED_INFO_X
[top of page]
APPS.FF_COMPILED_INFO_X references the following:
APPS
SYNONYM - FF_COMPILED_INFO_F
APPS.FF_COMPILED_INFO_X is referenced by following:
PUBLIC
SYNONYM - FF_COMPILED_INFO_X
[top of page]
View: FF_DATABASE_ITEMS_V
[top of page]
APPS.FF_DATABASE_ITEMS_V references the following:
APPS
SYNONYM - FF_DATABASE_ITEMS
SYNONYM - FF_ROUTES
SYNONYM - FF_USER_ENTITIES
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
APPS.FF_DATABASE_ITEMS_V is referenced by following:
PUBLIC
SYNONYM - FF_DATABASE_ITEMS_V
[top of page]
View: FF_DATABASE_ITEMS_VL
[top of page]
APPS.FF_DATABASE_ITEMS_VL references the following:
APPS
SYNONYM - FF_DATABASE_ITEMS
SYNONYM - FF_DATABASE_ITEMS_TL
APPS.FF_DATABASE_ITEMS_VL is referenced by following:
PUBLIC
SYNONYM - FF_DATABASE_ITEMS_VL
[top of page]
View: FF_DATABASE_ITEMS_VL1
[top of page]
APPS.FF_DATABASE_ITEMS_VL1 references the following:
APPS
SYNONYM - FF_DATABASE_ITEMS
SYNONYM - FF_DATABASE_ITEMS_TL
SYNONYM - FF_ROUTES
SYNONYM - FF_USER_ENTITIES
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
APPS.FF_DATABASE_ITEMS_VL1 is referenced by following:
PUBLIC
SYNONYM - FF_DATABASE_ITEMS_VL1
[top of page]
View: FF_DATABASE_ITEMS_VL2
[top of page]
APPS.FF_DATABASE_ITEMS_VL2 references the following:
APPS
SYNONYM - FF_DATABASE_ITEMS
SYNONYM - FF_DATABASE_ITEMS_TL
APPS.FF_DATABASE_ITEMS_VL2 is referenced by following:
PUBLIC
SYNONYM - FF_DATABASE_ITEMS_VL2
[top of page]
View: FF_FDI_USAGES
[top of page]
APPS.FF_FDI_USAGES references the following:
APPS
SYNONYM - FF_FDI_USAGES_F
SYNONYM - FND_SESSIONS
APPS.FF_FDI_USAGES is referenced by following:
APPS
PACKAGE BODY - FFHUTL
PACKAGE BODY - PAY_US_GARN_UPGRADE
PUBLIC
SYNONYM - FF_FDI_USAGES
[top of page]
View: FF_FDI_USAGES_X
[top of page]
APPS.FF_FDI_USAGES_X references the following:
APPS
SYNONYM - FF_FDI_USAGES_F
APPS.FF_FDI_USAGES_X is referenced by following:
PUBLIC
SYNONYM - FF_FDI_USAGES_X
[top of page]
View: FF_FORMULAS
[top of page]
APPS.FF_FORMULAS references the following:
APPS
SYNONYM - FF_FORMULAS_F
SYNONYM - FND_SESSIONS
APPS.FF_FORMULAS is referenced by following:
APPS
VIEW - BEN_LER_BNFT_RSTRN_D
PACKAGE BODY - HR_BIS_ALERTS
PACKAGE BODY - HR_FR_MMO
PACKAGE BODY - HR_ITP_BUS
VIEW - PER_CAGR_ENTITLEMENTS_V
PACKAGE BODY - PQP_GB_GAP_BEN_FORMULAS
PACKAGE BODY - PQP_UK_VEHICLE_TEMPLATE
PUBLIC
SYNONYM - FF_FORMULAS
[top of page]
View: FF_FORMULAS_F_V
[top of page]
APPS.FF_FORMULAS_F_V references the following:
APPS
SYNONYM - FF_COMPILED_INFO_F
SYNONYM - FF_FORMULAS_F
SYNONYM - FF_FORMULA_TYPES
SYNONYM - FND_SESSIONS
PACKAGE - HR_GENERAL
APPS.FF_FORMULAS_F_V is referenced by following:
APPS
PACKAGE BODY - HR_NL_CALC_TARGET_GROUP
VIEW - PQH_BDGT_CMMTMNT_ELMNTS_V
PUBLIC
SYNONYM - FF_FORMULAS_F_V
[top of page]
View: FF_FORMULAS_LOV
[top of page]
APPS.FF_FORMULAS_LOV references the following:
APPS
SYNONYM - FF_COMPILED_INFO_F
SYNONYM - FF_FORMULAS_F
SYNONYM - FF_FORMULA_TYPES
SYNONYM - FND_SESSIONS
APPS.FF_FORMULAS_LOV is referenced by following:
PUBLIC
SYNONYM - FF_FORMULAS_LOV
[top of page]
View: FF_FORMULAS_X
[top of page]
APPS.FF_FORMULAS_X references the following:
APPS
SYNONYM - FF_FORMULAS_F
APPS.FF_FORMULAS_X is referenced by following:
APPS
PACKAGE BODY - HRI_OLTP_DISC_WRKFRC
PUBLIC
SYNONYM - FF_FORMULAS_X
[top of page]
View: FF_FUNCTIONS_V
[top of page]
APPS.FF_FUNCTIONS_V references the following:
APPS
SYNONYM - FF_FUNCTIONS
SYNONYM - FF_LOOKUPS
APPS.FF_FUNCTIONS_V is referenced by following:
PUBLIC
SYNONYM - FF_FUNCTIONS_V
[top of page]
View: FF_FUNCTION_CONTEXT_USAGES_V
[top of page]
APPS.FF_FUNCTION_CONTEXT_USAGES_V references the following:
APPS
SYNONYM - FF_CONTEXTS
SYNONYM - FF_FUNCTION_CONTEXT_USAGES
SYNONYM - FF_LOOKUPS
APPS.FF_FUNCTION_CONTEXT_USAGES_V is referenced by following:
PUBLIC
SYNONYM - FF_FUNCTION_CONTEXT_USAGES_V
[top of page]
View: FF_FUNCTION_PARAMETERS_V
[top of page]
APPS.FF_FUNCTION_PARAMETERS_V references the following:
APPS
SYNONYM - FF_FUNCTION_PARAMETERS
SYNONYM - FF_LOOKUPS
APPS.FF_FUNCTION_PARAMETERS_V is referenced by following:
PUBLIC
SYNONYM - FF_FUNCTION_PARAMETERS_V
[top of page]
View: FF_GLOBALS
[top of page]
APPS.FF_GLOBALS references the following:
APPS
SYNONYM - FF_GLOBALS_F
SYNONYM - FND_SESSIONS
APPS.FF_GLOBALS is referenced by following:
PUBLIC
SYNONYM - FF_GLOBALS
[top of page]
View: FF_GLOBALS_F_V
[top of page]
APPS.FF_GLOBALS_F_V references the following:
APPS
SYNONYM - FF_GLOBALS_F
PACKAGE - FND_GLOBAL
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
APPS.FF_GLOBALS_F_V is referenced by following:
PUBLIC
SYNONYM - FF_GLOBALS_F_V
[top of page]
View: FF_GLOBALS_X
[top of page]
APPS.FF_GLOBALS_X references the following:
APPS
SYNONYM - FF_GLOBALS_F
APPS.FF_GLOBALS_X is referenced by following:
PUBLIC
SYNONYM - FF_GLOBALS_X
[top of page]