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®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, 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 - FUN Tables and Views

TABLE - FUN.FUN_BALANCE_ACCOUNTS
TABLE - FUN.FUN_BALANCE_OPTIONS
TABLE - FUN.FUN_BAL_ERRORS_GT
TABLE - FUN.FUN_BAL_ERRORS_T
TABLE - FUN.FUN_BAL_GENERATE_LINES
TABLE - FUN.FUN_BAL_HEADERS_GT
TABLE - FUN.FUN_BAL_HEADERS_T
TABLE - FUN.FUN_BAL_INTER_BSV_MAP_T
TABLE - FUN.FUN_BAL_INTER_INT_GT
TABLE - FUN.FUN_BAL_INTER_INT_T
TABLE - FUN.FUN_BAL_INTRA_BSV_MAP_T
TABLE - FUN.FUN_BAL_INTRA_INT_GT
TABLE - FUN.FUN_BAL_INTRA_INT_T
TABLE - FUN.FUN_BAL_LE_BSV_MAP_GT
TABLE - FUN.FUN_BAL_LINES_GT
TABLE - FUN.FUN_BAL_LINES_T
TABLE - FUN.FUN_BAL_RESULTS_GT
TABLE - FUN.FUN_BAL_RESULTS_T
TABLE - FUN.FUN_BATCH_DISTS
TABLE - FUN.FUN_CONTACTUS_REQUEST_DATA
TABLE - FUN.FUN_CONTACTUS_SETUP
TABLE - FUN.FUN_CUSTOMER_MAPS
TABLE - FUN.FUN_DIST_LINES
TABLE - FUN.FUN_INTERFACE_BATCHDISTS
TABLE - FUN.FUN_INTERFACE_BATCHES
TABLE - FUN.FUN_INTERFACE_CONTROLS
TABLE - FUN.FUN_INTERFACE_DIST_LINES
TABLE - FUN.FUN_INTERFACE_HEADERS
TABLE - FUN.FUN_INTERFACE_REJECTIONS
TABLE - FUN.FUN_INTER_ACCOUNTS
TABLE - FUN.FUN_INTER_ACCOUNTS_ADDL
TABLE - FUN.FUN_NET_AGREEMENTS_ALL
TABLE - FUN.FUN_NET_AP_INVS_ALL
TABLE - FUN.FUN_NET_AP_INV_TYPES_ALL
TABLE - FUN.FUN_NET_AR_TRX_TYPES_ALL
TABLE - FUN.FUN_NET_AR_TXNS_ALL
TABLE - FUN.FUN_NET_BATCHES_ALL
TABLE - FUN.FUN_NET_CUSTOMERS_ALL
TABLE - FUN.FUN_NET_SUPPLIERS_ALL
TABLE - FUN.FUN_PERIOD_STATUSES
TABLE - FUN.FUN_RICH_MESSAGES_B
TABLE - FUN.FUN_RICH_MESSAGES_TL
TABLE - FUN.FUN_RULE_BULK_RESULT_GT
TABLE - FUN.FUN_RULE_CRITERIA
TABLE - FUN.FUN_RULE_CRIT_PARAMS_B
TABLE - FUN.FUN_RULE_CRIT_PARAMS_TL
TABLE - FUN.FUN_RULE_DETAILS
TABLE - FUN.FUN_RULE_OBJECTS_B
TABLE - FUN.FUN_RULE_OBJECTS_TL
TABLE - FUN.FUN_RULE_OBJ_ATTRIBUTES
TABLE - FUN.FUN_RULE_PARAM_VALUES
TABLE - FUN.FUN_RULE_TESTS
TABLE - FUN.FUN_RULE_TEST_MULTIRULE
TABLE - FUN.FUN_RULE_TEST_MVAL_RES
TABLE - FUN.FUN_RULE_TEST_PARAMS
TABLE - FUN.FUN_RULE_TEST_RESULTS
TABLE - FUN.FUN_SEQ_ASSIGNMENTS
TABLE - FUN.FUN_SEQ_CONTEXTS
TABLE - FUN.FUN_SEQ_ENTITIES
TABLE - FUN.FUN_SEQ_HEADERS
TABLE - FUN.FUN_SEQ_REQUESTS
TABLE - FUN.FUN_SEQ_RULES
TABLE - FUN.FUN_SEQ_VERSIONS
TABLE - FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS
TABLE - FUN.FUN_SUPPLIER_MAPS
TABLE - FUN.FUN_SYSTEM_OPTIONS
TABLE - FUN.FUN_TRADE_RELATIONS
TABLE - FUN.FUN_TRANSFERS
TABLE - FUN.FUN_TRX_ACCT_DEFINITIONS
TABLE - FUN.FUN_TRX_BATCHES
TABLE - FUN.FUN_TRX_HEADERS
TABLE - FUN.FUN_TRX_LINES
TABLE - FUN.FUN_TRX_TYPES_B
TABLE - FUN.FUN_TRX_TYPES_TL
TABLE - FUN.FUN_TRX_TYPE_AR_MAPS
TABLE - FUN.FUN_XLA_TAB_GT
VIEW - APPS.FUN_RULE_OBJECTS_VL

Table: FUN_BALANCE_ACCOUNTS

Description: FUN_BALANCE_ACCOUNTS table stores the intracompany accounts defined between each trading and transacting balancing segment value. These accounts are used by the Intercompany Balancing API to balancing Intracompany journals.

[top of page]

FUN.FUN_BALANCE_ACCOUNTS does not reference any database object

FUN.FUN_BALANCE_ACCOUNTS is referenced by following:

APPS
SYNONYM - FUN_BALANCE_ACCOUNTS

[top of page]

Table: FUN_BALANCE_OPTIONS

Description: FUN_BALANCE_OPTIONS table stores the ledger, journal source and category information for which the Intracompany balancing rules have been defined. These rules are used by the Intercompany Balancing API to balancing Intracompany journals.

[top of page]

FUN.FUN_BALANCE_OPTIONS does not reference any database object

FUN.FUN_BALANCE_OPTIONS is referenced by following:

APPS
SYNONYM - FUN_BALANCE_OPTIONS

[top of page]

Table: FUN_BAL_ERRORS_GT

Description:

[top of page]

FUN.FUN_BAL_ERRORS_GT does not reference any database object

FUN.FUN_BAL_ERRORS_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_ERRORS_GT

[top of page]

Table: FUN_BAL_ERRORS_T

Description: FUN_BAL_ERRORS_T is a temporary table used internally by the Intercompany Balancing API.

[top of page]

FUN.FUN_BAL_ERRORS_T does not reference any database object

FUN.FUN_BAL_ERRORS_T is referenced by following:

APPS
SYNONYM - FUN_BAL_ERRORS_T

[top of page]

Table: FUN_BAL_GENERATE_LINES

Description: FUN_BAL_GENERATE_LINES is a temporary table used internally by the Intercompany balancing API.

[top of page]

FUN.FUN_BAL_GENERATE_LINES does not reference any database object

FUN.FUN_BAL_GENERATE_LINES is referenced by following:

APPS
SYNONYM - FUN_BAL_GENERATE_LINES

[top of page]

Table: FUN_BAL_HEADERS_GT

Description: FUN_BAL_HEADERS_GT is a global temporary table used by the Intercompany Balancing API. Calling modules like SLA and GL populate this table with the details of the journals that needs to be balanced and then invoke the Intercompany Balancing

[top of page]

FUN.FUN_BAL_HEADERS_GT does not reference any database object

FUN.FUN_BAL_HEADERS_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_HEADERS_GT

[top of page]

Table: FUN_BAL_HEADERS_T

Description: FUN_BAL_HEADERS_T is a temporary table used internally by the Intercompany Balancing API.

[top of page]

FUN.FUN_BAL_HEADERS_T does not reference any database object

FUN.FUN_BAL_HEADERS_T is referenced by following:

APPS
SYNONYM - FUN_BAL_HEADERS_T

[top of page]

Table: FUN_BAL_INTER_BSV_MAP_T

Description: FUN_BAL_INTER_BSV_MAP_T is a temporary table used internally by the Intercompany balancing API.

[top of page]

FUN.FUN_BAL_INTER_BSV_MAP_T does not reference any database object

FUN.FUN_BAL_INTER_BSV_MAP_T is referenced by following:

APPS
SYNONYM - FUN_BAL_INTER_BSV_MAP_T

[top of page]

Table: FUN_BAL_INTER_INT_GT

Description: FUN_BAL_INTER_INT_GT is a global temporary table used internally by the Intercompany Balancing API.

[top of page]

FUN.FUN_BAL_INTER_INT_GT does not reference any database object

FUN.FUN_BAL_INTER_INT_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_INTER_INT_GT

[top of page]

Table: FUN_BAL_INTER_INT_T

Description: FUN_BAL_INTER_INT_T is a temporary table used internally by the Intercompany Balancing API.

[top of page]

FUN.FUN_BAL_INTER_INT_T does not reference any database object

FUN.FUN_BAL_INTER_INT_T is referenced by following:

APPS
SYNONYM - FUN_BAL_INTER_INT_T

[top of page]

Table: FUN_BAL_INTRA_BSV_MAP_T

Description: FUN_BAL_INTRA_BSV_MAP_T is a temporary table used internally by the Intercompany balancing API.

[top of page]

FUN.FUN_BAL_INTRA_BSV_MAP_T does not reference any database object

FUN.FUN_BAL_INTRA_BSV_MAP_T is referenced by following:

APPS
SYNONYM - FUN_BAL_INTRA_BSV_MAP_T

[top of page]

Table: FUN_BAL_INTRA_INT_GT

Description: FUN_BAL_INTRA_INT_GT is a global temporary table used internally by the Intercompany Balancing API

[top of page]

FUN.FUN_BAL_INTRA_INT_GT does not reference any database object

FUN.FUN_BAL_INTRA_INT_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_INTRA_INT_GT

[top of page]

Table: FUN_BAL_INTRA_INT_T

Description: FUN_BAL_IINTRA_INT_T is a temporary table used internally by the Intercompany Balancing API.

[top of page]

FUN.FUN_BAL_INTRA_INT_T does not reference any database object

FUN.FUN_BAL_INTRA_INT_T is referenced by following:

APPS
SYNONYM - FUN_BAL_INTRA_INT_T

[top of page]

Table: FUN_BAL_LE_BSV_MAP_GT

Description: FUN_BAL_LE_BSV_MAP_GT is a global temporary table used internally by the Intercompany Balancing API

[top of page]

FUN.FUN_BAL_LE_BSV_MAP_GT does not reference any database object

FUN.FUN_BAL_LE_BSV_MAP_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_LE_BSV_MAP_GT

[top of page]

Table: FUN_BAL_LINES_GT

Description: FUN_BAL_LINES_GT is a global temporary table used by the Intercompany Balancing API. Calling modules like SLA and GL populate this table with the details of the journals that needs to be balanced and then invoke the Intercompany Balancing A

[top of page]

FUN.FUN_BAL_LINES_GT does not reference any database object

FUN.FUN_BAL_LINES_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_LINES_GT

[top of page]

Table: FUN_BAL_LINES_T

Description: FUN_BAL_LINES_T is a temporary table used internally by the Intercompany Balancing API.

[top of page]

FUN.FUN_BAL_LINES_T does not reference any database object

FUN.FUN_BAL_LINES_T is referenced by following:

APPS
SYNONYM - FUN_BAL_LINES_T

[top of page]

Table: FUN_BAL_RESULTS_GT

Description: FUN_BAL_RESULTS_GT is a global temporary table used by the Intercompany balancing API. After balancing an Intercompany journal, the Intercompany balancing API inserts the resulting balancing lines into this table. Calling modules like SLA a

[top of page]

FUN.FUN_BAL_RESULTS_GT does not reference any database object

FUN.FUN_BAL_RESULTS_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_RESULTS_GT

[top of page]

Table: FUN_BAL_RESULTS_T

Description: FUN_BAL_RESULTS_T is a temporary table used internally by the Intercompany balancing API.

[top of page]

FUN.FUN_BAL_RESULTS_T does not reference any database object

FUN.FUN_BAL_RESULTS_T is referenced by following:

APPS
SYNONYM - FUN_BAL_RESULTS_T

[top of page]

Table: FUN_BATCH_DISTS

Description: FUN_BATCH_DISTS stores the distribution details if user has chosen to enter distributions using the automatic proration mode. The amounts entered in this case are prorated for the recipients and distributions lines created in FUN_DIST_LINES

[top of page]

FUN.FUN_BATCH_DISTS does not reference any database object

FUN.FUN_BATCH_DISTS is referenced by following:

APPS
SYNONYM - FUN_BATCH_DISTS

[top of page]

Table: FUN_CONTACTUS_REQUEST_DATA

Description: This table contains information about the question or problem submitted by the end user that is stored in a prompt-value pair format.

[top of page]

FUN.FUN_CONTACTUS_REQUEST_DATA does not reference any database object

FUN.FUN_CONTACTUS_REQUEST_DATA is referenced by following:

APPS
SYNONYM - FUN_CONTACTUS_REQUEST_DATA

[top of page]

Table: FUN_CONTACTUS_SETUP

Description: This table contains the definition for the behavior of the Contact Us global button.

[top of page]

FUN.FUN_CONTACTUS_SETUP does not reference any database object

FUN.FUN_CONTACTUS_SETUP is referenced by following:

APPS
SYNONYM - FUN_CONTACTUS_SETUP

[top of page]

Table: FUN_CUSTOMER_MAPS

Description: FUN_CUSTOMER_MAPS stores the details of the customer to which an Intercompany organization is mapped. When an invoice is created in receivables for the Intercompany organization, the customer used will the one setup in this table.

[top of page]

FUN.FUN_CUSTOMER_MAPS does not reference any database object

FUN.FUN_CUSTOMER_MAPS is referenced by following:

APPS
SYNONYM - FUN_CUSTOMER_MAPS

[top of page]

Table: FUN_DIST_LINES

Description: FUN_DIST_LINES stores the distributions for the Intercompany transactions. Both recipient and initiator distributions are stored in this table. Party_type_flag = I and dist_type_flag = L indicates an Initiator distribution line. Party_type_

[top of page]

FUN.FUN_DIST_LINES does not reference any database object

FUN.FUN_DIST_LINES is referenced by following:

APPS
SYNONYM - FUN_DIST_LINES

[top of page]

Table: FUN_INTERFACE_BATCHDISTS

Description: /*# * Intercompany Batch Distributions Interface * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Batch Distributions Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */

[top of page]

FUN.FUN_INTERFACE_BATCHDISTS does not reference any database object

FUN.FUN_INTERFACE_BATCHDISTS is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_BATCHDISTS

[top of page]

Table: FUN_INTERFACE_BATCHES

Description: /*# * Open interface table for Intercompany Batches. * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Batches Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */

[top of page]

FUN.FUN_INTERFACE_BATCHES does not reference any database object

FUN.FUN_INTERFACE_BATCHES is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_BATCHES

[top of page]

Table: FUN_INTERFACE_CONTROLS

Description: /*# * Intercompany Open Interface Control table. * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Control Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */

[top of page]

FUN.FUN_INTERFACE_CONTROLS does not reference any database object

FUN.FUN_INTERFACE_CONTROLS is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_CONTROLS

[top of page]

Table: FUN_INTERFACE_DIST_LINES

Description: /*# * Intercompany Distributions Open Interface * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Distributions Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */

[top of page]

FUN.FUN_INTERFACE_DIST_LINES does not reference any database object

FUN.FUN_INTERFACE_DIST_LINES is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_DIST_LINES

[top of page]

Table: FUN_INTERFACE_HEADERS

Description: /*# * Intercompany Transactions Open Interface * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Transaction Headers Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */

[top of page]

FUN.FUN_INTERFACE_HEADERS does not reference any database object

FUN.FUN_INTERFACE_HEADERS is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_HEADERS

[top of page]

Table: FUN_INTERFACE_REJECTIONS

Description:

[top of page]

FUN.FUN_INTERFACE_REJECTIONS does not reference any database object

FUN.FUN_INTERFACE_REJECTIONS is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_REJECTIONS

[top of page]

Table: FUN_INTER_ACCOUNTS

Description: FUN_INTER_ACCOUNTS table stores the Intercompany receivables and payables accounts defined for each transacting and trading legal entity relationship. The accounts can be defined either at the legal entity level or at the balancing segment

[top of page]

FUN.FUN_INTER_ACCOUNTS does not reference any database object

FUN.FUN_INTER_ACCOUNTS is referenced by following:

APPS
SYNONYM - FUN_INTER_ACCOUNTS

[top of page]

Table: FUN_INTER_ACCOUNTS_ADDL

Description: FUN_INTER_ACCOUNTS_ADDL table stores the accounts generated by replacing the intercompany and balancing segment value from the defined Intercompany receivables and payables accounts with the trading partner and trasnacting BSV.

[top of page]

FUN.FUN_INTER_ACCOUNTS_ADDL does not reference any database object

FUN.FUN_INTER_ACCOUNTS_ADDL is referenced by following:

APPS
SYNONYM - FUN_INTER_ACCOUNTS_ADDL

[top of page]

Table: FUN_NET_AGREEMENTS_ALL

Description: FUN_NET_AGREEMENTS_ALL stores general information about Netting Agreements

[top of page]

FUN.FUN_NET_AGREEMENTS_ALL does not reference any database object

FUN.FUN_NET_AGREEMENTS_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_AGREEMENTS
SYNONYM - FUN_NET_AGREEMENTS_ALL

[top of page]

Table: FUN_NET_AP_INVS_ALL

Description: FUN_NET_AP_INVS_ALL stores information about Payables invoices included in Netting Batch.

[top of page]

FUN.FUN_NET_AP_INVS_ALL does not reference any database object

FUN.FUN_NET_AP_INVS_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_AP_INVS
SYNONYM - FUN_NET_AP_INVS_ALL

[top of page]

Table: FUN_NET_AP_INV_TYPES_ALL

Description: FUN_NET_AP_INV_TYPES_ALL stores information about the Payables Invoice Types that are included in a Netting Agreement

[top of page]

FUN.FUN_NET_AP_INV_TYPES_ALL does not reference any database object

FUN.FUN_NET_AP_INV_TYPES_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_AP_INV_TYPES
SYNONYM - FUN_NET_AP_INV_TYPES_ALL

[top of page]

Table: FUN_NET_AR_TRX_TYPES_ALL

Description: FUN_NET_AR_TRX_TYPES_ALL stores information about the ReceivablesTransaction Types that are included in a Netting Agreement.

[top of page]

FUN.FUN_NET_AR_TRX_TYPES_ALL does not reference any database object

FUN.FUN_NET_AR_TRX_TYPES_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_AR_TRX_TYPES
SYNONYM - FUN_NET_AR_TRX_TYPES_ALL

[top of page]

Table: FUN_NET_AR_TXNS_ALL

Description: FUN_NET_AR_TXNS_ALL stores information about Receivables Transactions included in Netting Batch.

[top of page]

FUN.FUN_NET_AR_TXNS_ALL does not reference any database object

FUN.FUN_NET_AR_TXNS_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_AR_TXNS
SYNONYM - FUN_NET_AR_TXNS_ALL

[top of page]

Table: FUN_NET_BATCHES_ALL

Description: FUN_NET_BATCHES_ALL stores information about Netting Batches.

[top of page]

FUN.FUN_NET_BATCHES_ALL does not reference any database object

FUN.FUN_NET_BATCHES_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_BATCHES
SYNONYM - FUN_NET_BATCHES_ALL

[top of page]

Table: FUN_NET_CUSTOMERS_ALL

Description: FUN_NET_CUSTOMERS_ALL stores information about the Customers that are included in a Netting Agreement.

[top of page]

FUN.FUN_NET_CUSTOMERS_ALL does not reference any database object

FUN.FUN_NET_CUSTOMERS_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_CUSTOMERS
SYNONYM - FUN_NET_CUSTOMERS_ALL

[top of page]

Table: FUN_NET_SUPPLIERS_ALL

Description: FUN_NET_SUPPLIERS_ALL stores information about the Suppliers that are included in a Netting Agreement.

[top of page]

FUN.FUN_NET_SUPPLIERS_ALL does not reference any database object

FUN.FUN_NET_SUPPLIERS_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_SUPPLIERS
SYNONYM - FUN_NET_SUPPLIERS_ALL

[top of page]

Table: FUN_PERIOD_STATUSES

Description: FUN_PERIOD_STATUSES stores the Intercompany period statuses if an Intercompany calendar has been defined in system options. Intercompany period statuses are maintained at the Intercompany Transaction Type level i.e. periods can be opened an

[top of page]

FUN.FUN_PERIOD_STATUSES does not reference any database object

FUN.FUN_PERIOD_STATUSES is referenced by following:

APPS
SYNONYM - FUN_PERIOD_STATUSES

[top of page]

Table: FUN_RICH_MESSAGES_B

Description: Stores information about rich messages which may contain HTML tags for pretty formatting.

[top of page]

FUN.FUN_RICH_MESSAGES_B does not reference any database object

FUN.FUN_RICH_MESSAGES_B is referenced by following:

APPS
SYNONYM - FUN_RICH_MESSAGES_B

[top of page]

Table: FUN_RICH_MESSAGES_TL

Description: Stores information about rich messages which may contain HTML tags for pretty formatting.

[top of page]

FUN.FUN_RICH_MESSAGES_TL does not reference any database object

FUN.FUN_RICH_MESSAGES_TL is referenced by following:

APPS
SYNONYM - FUN_RICH_MESSAGES_TL

[top of page]

Table: FUN_RULE_BULK_RESULT_GT

Description: Global temporary table used by the bulk API to store the result values.

[top of page]

FUN.FUN_RULE_BULK_RESULT_GT does not reference any database object

FUN.FUN_RULE_BULK_RESULT_GT is referenced by following:

APPS
SYNONYM - FUN_RULE_BULK_RESULT_GT

[top of page]

Table: FUN_RULE_CRITERIA

Description: Stores a single criteria for a rule.

[top of page]

FUN.FUN_RULE_CRITERIA does not reference any database object

FUN.FUN_RULE_CRITERIA is referenced by following:

APPS
SYNONYM - FUN_RULE_CRITERIA

[top of page]

Table: FUN_RULE_CRIT_PARAMS_B

Description: Stores the available criteria parameters for a Rule Object.

[top of page]

FUN.FUN_RULE_CRIT_PARAMS_B does not reference any database object

FUN.FUN_RULE_CRIT_PARAMS_B is referenced by following:

APPS
SYNONYM - FUN_RULE_CRIT_PARAMS_B

[top of page]

Table: FUN_RULE_CRIT_PARAMS_TL

Description: Stores the available criteria parameters for a Rule Object.

[top of page]

FUN.FUN_RULE_CRIT_PARAMS_TL does not reference any database object

FUN.FUN_RULE_CRIT_PARAMS_TL is referenced by following:

APPS
SYNONYM - FUN_RULE_CRIT_PARAMS_TL

[top of page]

Table: FUN_RULE_DETAILS

Description: Stores details about a rule.

[top of page]

FUN.FUN_RULE_DETAILS does not reference any database object

FUN.FUN_RULE_DETAILS is referenced by following:

APPS
SYNONYM - FUN_RULE_DETAILS

[top of page]

Table: FUN_RULE_OBJECTS_B

Description: Stores information about Rule Objects.

[top of page]

FUN.FUN_RULE_OBJECTS_B does not reference any database object

FUN.FUN_RULE_OBJECTS_B is referenced by following:

APPS
SYNONYM - FUN_RULE_OBJECTS_B

[top of page]

Table: FUN_RULE_OBJECTS_TL

Description: Stores information about Rule Objects.

[top of page]

FUN.FUN_RULE_OBJECTS_TL does not reference any database object

FUN.FUN_RULE_OBJECTS_TL is referenced by following:

APPS
SYNONYM - FUN_RULE_OBJECTS_TL

[top of page]

Table: FUN_RULE_OBJ_ATTRIBUTES

Description: Stores additional Rule Object attributes.

[top of page]

FUN.FUN_RULE_OBJ_ATTRIBUTES does not reference any database object

FUN.FUN_RULE_OBJ_ATTRIBUTES is referenced by following:

APPS
SYNONYM - FUN_RULE_OBJ_ATTRIBUTES

[top of page]

Table: FUN_RULE_PARAM_VALUES

Description: Stores the multiple criteria parameter values that are used in evaluation of a criteria. If a criteria uses a parameters that is based on an independent or table based value set, the parameter value is compared against multiple values to se

[top of page]

FUN.FUN_RULE_PARAM_VALUES does not reference any database object

FUN.FUN_RULE_PARAM_VALUES is referenced by following:

APPS
SYNONYM - FUN_RULE_PARAM_VALUES

[top of page]

Table: FUN_RULE_TESTS

Description: Stores test cases for the Financials Rules Engine

[top of page]

FUN.FUN_RULE_TESTS does not reference any database object

FUN.FUN_RULE_TESTS is referenced by following:

APPS
SYNONYM - FUN_RULE_TESTS

[top of page]

Table: FUN_RULE_TEST_MULTIRULE

Description: Stores the test results for a test if multiple results are allowed for the Rule Object

[top of page]

FUN.FUN_RULE_TEST_MULTIRULE does not reference any database object

FUN.FUN_RULE_TEST_MULTIRULE is referenced by following:

APPS
SYNONYM - FUN_RULE_TEST_MULTIRULE

[top of page]

Table: FUN_RULE_TEST_MVAL_RES

Description:

[top of page]

FUN.FUN_RULE_TEST_MVAL_RES does not reference any database object

FUN.FUN_RULE_TEST_MVAL_RES is referenced by following:

APPS
SYNONYM - FUN_RULE_TEST_MVAL_RES

[top of page]

Table: FUN_RULE_TEST_PARAMS

Description: Stores parameter values for tests.

[top of page]

FUN.FUN_RULE_TEST_PARAMS does not reference any database object

FUN.FUN_RULE_TEST_PARAMS is referenced by following:

APPS
SYNONYM - FUN_RULE_TEST_PARAMS

[top of page]

Table: FUN_RULE_TEST_RESULTS

Description:

[top of page]

FUN.FUN_RULE_TEST_RESULTS does not reference any database object

FUN.FUN_RULE_TEST_RESULTS is referenced by following:

APPS
SYNONYM - FUN_RULE_TEST_RESULTS

[top of page]

Table: FUN_SEQ_ASSIGNMENTS

Description:

[top of page]

FUN.FUN_SEQ_ASSIGNMENTS does not reference any database object

FUN.FUN_SEQ_ASSIGNMENTS is referenced by following:

APPS
SYNONYM - FUN_SEQ_ASSIGNMENTS

[top of page]

Table: FUN_SEQ_CONTEXTS

Description:

[top of page]

FUN.FUN_SEQ_CONTEXTS does not reference any database object

FUN.FUN_SEQ_CONTEXTS is referenced by following:

APPS
SYNONYM - FUN_SEQ_CONTEXTS

[top of page]

Table: FUN_SEQ_ENTITIES

Description:

[top of page]

FUN.FUN_SEQ_ENTITIES does not reference any database object

FUN.FUN_SEQ_ENTITIES is referenced by following:

APPS
SYNONYM - FUN_SEQ_ENTITIES

[top of page]

Table: FUN_SEQ_HEADERS

Description:

[top of page]

FUN.FUN_SEQ_HEADERS does not reference any database object

FUN.FUN_SEQ_HEADERS is referenced by following:

APPS
SYNONYM - FUN_SEQ_HEADERS

[top of page]

Table: FUN_SEQ_REQUESTS

Description:

[top of page]

FUN.FUN_SEQ_REQUESTS does not reference any database object

FUN.FUN_SEQ_REQUESTS is referenced by following:

APPS
SYNONYM - FUN_SEQ_REQUESTS

[top of page]

Table: FUN_SEQ_RULES

Description:

[top of page]

FUN.FUN_SEQ_RULES does not reference any database object

FUN.FUN_SEQ_RULES is referenced by following:

APPS
SYNONYM - FUN_SEQ_RULES

[top of page]

Table: FUN_SEQ_VERSIONS

Description:

[top of page]

FUN.FUN_SEQ_VERSIONS does not reference any database object

FUN.FUN_SEQ_VERSIONS is referenced by following:

APPS
SYNONYM - FUN_SEQ_VERSIONS

[top of page]

Table: FUN_SUBSIDIARY_PARTY_MAPPINGS

Description: FUN_SUBSIDIARY_PARTY_MAPPINGS is used to upgrade GL Subsidiaries as Intercompany Organizations. This table is not used once the organizations and transactions have been upgraded.

[top of page]

FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS does not reference any database object

FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS is referenced by following:

APPS
SYNONYM - FUN_SUBSIDIARY_PARTY_MAPPINGS

[top of page]

Table: FUN_SUPPLIER_MAPS

Description: FUN_SUPPLIER_MAPS stores the details of the supplier to which an Intercompany organization is mapped. When an invoice is created in payables for the Intercompany organization, the supplier used will the one setup in this table.

[top of page]

FUN.FUN_SUPPLIER_MAPS does not reference any database object

FUN.FUN_SUPPLIER_MAPS is referenced by following:

APPS
SYNONYM - FUN_SUPPLIER_MAPS

[top of page]

Table: FUN_SYSTEM_OPTIONS

Description: FUN_SYSTEM_OPTIONS stores setup options defined at the system level which applies across the whole system. This table will always contain only 1 row.

[top of page]

FUN.FUN_SYSTEM_OPTIONS does not reference any database object

FUN.FUN_SYSTEM_OPTIONS is referenced by following:

APPS
SYNONYM - FUN_SYSTEM_OPTIONS

[top of page]

Table: FUN_TRADE_RELATIONS

Description: FUN_TRADE_RELATIONS stores the association of an Intercompany organization as a customer or a supplier. These associations are used when the Intercompany transactions are transferred to Receivables and Payables as invoices.

[top of page]

FUN.FUN_TRADE_RELATIONS does not reference any database object

FUN.FUN_TRADE_RELATIONS is referenced by following:

APPS
SYNONYM - FUN_TRADE_RELATIONS

[top of page]

Table: FUN_TRANSFERS

Description: This table is no longer used.

[top of page]

FUN.FUN_TRANSFERS does not reference any database object

FUN.FUN_TRANSFERS is referenced by following:

APPS
SYNONYM - FUN_TRANSFERS

[top of page]

Table: FUN_TRX_ACCT_DEFINITIONS

Description: FUN_TRX_ACCT_DEFINITIONS stores the association between a ledger and SLA transaction account definition. This association is used to indicate to the Intercompany transaction entry process that user has defined account derivation rules in SL

[top of page]

FUN.FUN_TRX_ACCT_DEFINITIONS does not reference any database object

FUN.FUN_TRX_ACCT_DEFINITIONS is referenced by following:

APPS
SYNONYM - FUN_TRX_ACCT_DEFINITIONS

[top of page]

Table: FUN_TRX_BATCHES

Description: FUN_TRX_BATCHES stores information about the Intercompany transaction batches. The BATCH_NUMBER and INITIATOR_ID together form a unique key. An Intercompany transaction batch can contain many transactions for multiple recipients.

[top of page]

FUN.FUN_TRX_BATCHES does not reference any database object

FUN.FUN_TRX_BATCHES is referenced by following:

APPS
SYNONYM - FUN_TRX_BATCHES

[top of page]

Table: FUN_TRX_HEADERS

Description: FUN_TRX_HEADERS stores the transactions that make up an Intercompany transaction batch. The INITIATOR_ID, RECIPIENT_ID, BATCH_ID together form a unique key. Each transaction is meant for 1 recipient however a batch can contain multiple tran

[top of page]

FUN.FUN_TRX_HEADERS does not reference any database object

FUN.FUN_TRX_HEADERS is referenced by following:

APPS
SYNONYM - FUN_TRX_HEADERS

[top of page]

Table: FUN_TRX_LINES

Description: FUN_TRX_LINES stores some line level information for an intercompany transaction.Each row in FUN_TRX_HEADERS currently maps to 1 row in FUN_TRX_LINES.

[top of page]

FUN.FUN_TRX_LINES does not reference any database object

FUN.FUN_TRX_LINES is referenced by following:

APPS
SYNONYM - FUN_TRX_LINES

[top of page]

Table: FUN_TRX_TYPES_B

Description: FUN_TRX_TYPES_B stores the Intercompany transaction types defined.

[top of page]

FUN.FUN_TRX_TYPES_B does not reference any database object

FUN.FUN_TRX_TYPES_B is referenced by following:

APPS
SYNONYM - FUN_TRX_TYPES_B

[top of page]

Table: FUN_TRX_TYPES_TL

Description: FUN_TRX_TYPES_TL stores the translatable column details for the Intercompany transaction types.

[top of page]

FUN.FUN_TRX_TYPES_TL does not reference any database object

FUN.FUN_TRX_TYPES_TL is referenced by following:

APPS
SYNONYM - FUN_TRX_TYPES_TL

[top of page]

Table: FUN_TRX_TYPE_AR_MAPS

Description: FUN_TRX_TYPE_AR_MAPS stores the mapping between the Intercompany transaction type and the Receivables Transaction Type and Receivables Memo Line. This mapping is used to create Receivables invoices when the Intercompany transactions are tra

[top of page]

FUN.FUN_TRX_TYPE_AR_MAPS does not reference any database object

FUN.FUN_TRX_TYPE_AR_MAPS is referenced by following:

APPS
SYNONYM - FUN_TRX_TYPE_AR_MAPS

[top of page]

Table: FUN_XLA_TAB_GT

Description:

[top of page]

FUN.FUN_XLA_TAB_GT does not reference any database object

FUN.FUN_XLA_TAB_GT is referenced by following:

APPS
SYNONYM - FUN_XLA_TAB_GT

[top of page]

View: FUN_RULE_OBJECTS_VL

[top of page]

APPS.FUN_RULE_OBJECTS_VL references the following:

APPS
SYNONYM - FUN_RULE_OBJECTS_B
SYNONYM - FUN_RULE_OBJECTS_TL
SYNONYM - FUN_RULE_OBJ_ATTRIBUTES
APPS.FUN_RULE_OBJECTS_VL is referenced by following:

APPS
PACKAGE BODY - FUN_RULE_OBJECTS_PKG

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract