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 - FV Tables and Views

TABLE - FV.FV_1096_DATA_ALL
TABLE - FV.FV_1099C_ALL
TABLE - FV.FV_1099_TAPE_DATA_ALL
TABLE - FV.FV_ALC_ADDRESSES_ALL
TABLE - FV.FV_ALC_GWA_CATEGORIES
TABLE - FV.FV_AP_CASH_POS_TEMP
TABLE - FV.FV_AR_BATCHES_ALL
TABLE - FV.FV_AR_CONTROLS_ALL
TABLE - FV.FV_ASSIGN_REASON_CODES_ALL
TABLE - FV.FV_BD_CONTROLS
TABLE - FV.FV_BE_ACCOUNT_PAIRS
TABLE - FV.FV_BE_INTERFACE
TABLE - FV.FV_BE_INTERFACE_CONTROL
TABLE - FV.FV_BE_INTERFACE_HISTORY
TABLE - FV.FV_BE_RPR_TRANSACTIONS
TABLE - FV.FV_BE_TRANSACTION_TYPES
TABLE - FV.FV_BE_TRX_CODES
TABLE - FV.FV_BE_TRX_DTLS
TABLE - FV.FV_BE_TRX_HDRS
TABLE - FV.FV_BE_TRX_SUB_TYPES
TABLE - FV.FV_BUDGET_DISTRIBUTION_DTL
TABLE - FV.FV_BUDGET_DISTRIBUTION_HDR
TABLE - FV.FV_BUDGET_LEVELS
TABLE - FV.FV_BUDGET_OPTIONS
TABLE - FV.FV_BUDGET_USER_DTL
TABLE - FV.FV_BUDGET_USER_HDR
TABLE - FV.FV_CCID_CFS_GT
TABLE - FV.FV_CCR_FILE_TEMP
TABLE - FV.FV_CCR_ORGS
TABLE - FV.FV_CCR_PROCESS_REPORT
TABLE - FV.FV_CCR_VENDORS
TABLE - FV.FV_CFS_REP_LINES
TABLE - FV.FV_CFS_REP_LINE_CALC
TABLE - FV.FV_CFS_REP_LINE_DTL
TABLE - FV.FV_CFS_REP_TEMP
TABLE - FV.FV_CUST_FINANCE_CHRGS_ALL
TABLE - FV.FV_CUST_VEND_XREFS
TABLE - FV.FV_DELINQ_INVOICES_ALL
TABLE - FV.FV_DISCOUNTED_INVOICES
TABLE - FV.FV_DMS_AGENCY_DEFINITIONS_ALL
TABLE - FV.FV_DMS_CODE_ASSIGNMENTS_ALL
TABLE - FV.FV_DMS_CODE_DEFINITIONS_ALL
TABLE - FV.FV_DOC_CR_TEMP
TABLE - FV.FV_ETC_ACTIVITIES
TABLE - FV.FV_EVENTS_TRANSACTION_CODE
TABLE - APPS.FV_EXTRACT_DETAIL_GT
TABLE - FV.FV_FACTS1_DIFF_BALANCES
TABLE - FV.FV_FACTS1_FED_ACCOUNTS
TABLE - FV.FV_FACTS1_HEADER_ID_GT
TABLE - FV.FV_FACTS1_LINE_BALANCES
TABLE - FV.FV_FACTS1_PERIOD_ATTRIBUTES
TABLE - FV.FV_FACTS1_PROCESSED_JE_HDRS
TABLE - FV.FV_FACTS1_RUN
TABLE - FV.FV_FACTSII_ACCOUNTS_GT
TABLE - FV.FV_FACTSII_ENDING_BALANCES
TABLE - FV.FV_FACTSI_TEMP
TABLE - FV.FV_FACTS_ATTRIBUTES
TABLE - FV.FV_FACTS_AUTHORIZATIONS
TABLE - FV.FV_FACTS_BUDGET_ACCOUNTS
TABLE - FV.FV_FACTS_BUD_FED_ACCTS
TABLE - FV.FV_FACTS_EDIT_CHECK_STATUS
TABLE - FV.FV_FACTS_ENDING_BALANCES
TABLE - FV.FV_FACTS_FEDERAL_ACCOUNTS
TABLE - FV.FV_FACTS_FOOTNOTE_HDR
TABLE - FV.FV_FACTS_FOOTNOTE_LINES
TABLE - FV.FV_FACTS_PERIOD_BALANCES
TABLE - FV.FV_FACTS_PRC_DTL
TABLE - FV.FV_FACTS_PRC_HDR
TABLE - FV.FV_FACTS_REPORT_T2
TABLE - FV.FV_FACTS_RT7_ACCOUNTS
TABLE - FV.FV_FACTS_RT7_CODES
TABLE - FV.FV_FACTS_RUN
TABLE - FV.FV_FACTS_SUBMISSION
TABLE - FV.FV_FACTS_TEMP
TABLE - FV.FV_FACTS_TRX_TEMP
TABLE - FV.FV_FACTS_USSGL_ACCOUNTS
TABLE - FV.FV_FINANCE_CHARGE_CONTROLS_ALL
TABLE - FV.FV_FINANCE_CHARGE_HISTORY
TABLE - FV.FV_FINANCE_CHRG_CUST_CLASSES
TABLE - FV.FV_FINCHRG_DEBITMEMO_TEMP
TABLE - FV.FV_FUNDS_AVAIL_ACCT_RANGES
TABLE - FV.FV_FUNDS_AVAIL_REP_DEF
TABLE - FV.FV_FUNDS_AVAIL_TEMP
TABLE - FV.FV_FUND_GROUPS
TABLE - FV.FV_FUND_PARAMETERS
TABLE - FV.FV_FUND_PARAMETERS_HISTORY
TABLE - FV.FV_GOALS_224_TEMP
TABLE - FV.FV_HOLIDAY_DATES
TABLE - FV.FV_INTERAGENCY_FUNDS_ALL
TABLE - FV.FV_INTERIM_CASH_RECEIPTS_ALL
TABLE - FV.FV_INVOICE_FINANCE_CHRGS_ALL
TABLE - FV.FV_INVOICE_RETURNS_ALL
TABLE - FV.FV_INVOICE_RETURN_DATES_ALL
TABLE - FV.FV_INVOICE_STATUSES_ALL
TABLE - FV.FV_INVOICE_STATUSES_HIST_ALL
TABLE - FV.FV_INV_SELECTED_DUEDATE
TABLE - FV.FV_INV_SELECTED_DUEDATE_TEMP
TABLE - FV.FV_IPAC_IMPORT
TABLE - FV.FV_IPAC_IMPORT_ERRORS
TABLE - FV.FV_IPAC_IMPORT_HISTORY
TABLE - FV.FV_IPAC_RECURRING_INV
TABLE - FV.FV_IPAC_TRX_ALL
TABLE - FV.FV_LOCKBOX_IPA_TEMP
TABLE - FV.FV_OPERATING_UNITS_ALL
TABLE - FV.FV_PAYMENT_FORMAT_TEMP
TABLE - FV.FV_PAYMENT_TYPE_MAP_ALL
TABLE - FV.FV_PB_SEQ_ASSIGNMENTS_ALL
TABLE - FV.FV_PROMPT_PAY_TEMP
TABLE - FV.FV_PYA_ACCOUNTS_TRANS_CODES
TABLE - FV.FV_PYA_AUDITS
TABLE - FV.FV_PYA_FISCALYEAR_MAP
TABLE - FV.FV_PYA_FISCALYEAR_SEGMENT
TABLE - FV.FV_PYA_TRANSACTIONS
TABLE - FV.FV_PYA_TRANSACTION_HISTORY
TABLE - FV.FV_RCV_TRANSACTIONS
TABLE - FV.FV_RECEIVABLES_ACTIVITY_TEMP
TABLE - FV.FV_RECEIVABLE_TYPES_ALL
TABLE - FV.FV_REC_CUST_TRX_TYPES_ALL
TABLE - FV.FV_REFUNDS_VOIDS_ALL
TABLE - FV.FV_REPORT_DEFINITIONS
TABLE - FV.FV_SF1080_DETAIL_TEMP
TABLE - FV.FV_SF1080_HEADER_TEMP
TABLE - FV.FV_SF1081_TEMP
TABLE - FV.FV_SF1219_AUDITS
TABLE - FV.FV_SF1219_DEFINITIONS_ACCTS
TABLE - FV.FV_SF1219_MANUAL_LINES
TABLE - FV.FV_SF1219_ORG_TEMP
TABLE - FV.FV_SF1219_REPORT_TEMPLATE
TABLE - FV.FV_SF1219_TEMP
TABLE - FV.FV_SF132_APP_REAPP_SCH
TABLE - FV.FV_SF133_CCIDS_GT
TABLE - FV.FV_SF133_DEFINITIONS_ACCTS
TABLE - FV.FV_SF133_DEFINITIONS_COLS_TEMP
TABLE - FV.FV_SF133_DEFINITIONS_LINES
TABLE - FV.FV_SF133_LOAD_ACCTS
TABLE - FV.FV_SF133_LOAD_LINES
TABLE - FV.FV_SF224_AUDITS
TABLE - FV.FV_SF224_MAP
TABLE - FV.FV_SF224_RUN
TABLE - FV.FV_SF224_TEMP
TABLE - FV.FV_SF224_VOID_TEMP
TABLE - FV.FV_STATUS_FUNDS_FINAL
TABLE - FV.FV_STATUS_FUNDS_TEMP
TABLE - FV.FV_STATUS_OBLIG_TEMP
TABLE - FV.FV_SUMMARY_CONSOLIDATE_ALL
TABLE - FV.FV_SYSTEM_PARAMETERS
TABLE - FV.FV_TC_MAP_DTL_ALL
TABLE - FV.FV_TC_MAP_HDR_ALL
TABLE - FV.FV_TC_OFFSETS
TABLE - FV.FV_TERMS_TYPES
TABLE - FV.FV_THIRD_PARTY_TEMP
TABLE - FV.FV_TOP_EXCLUSION_CRITERIA_ALL
TABLE - FV.FV_TPP_ASSIGNMENTS_ALL
TABLE - FV.FV_TPP_CHECK_DETAILS_ALL
TABLE - FV.FV_TP_BULK_FMT_DATA
TABLE - FV.FV_TP_TS_AMT_DATA
TABLE - FV.FV_TRANSACTION_EVENTS
TABLE - FV.FV_TRANSACTION_HEADERS
TABLE - FV.FV_TREASURY_CHECK_RANGES
TABLE - FV.FV_TREASURY_CONFIRMATIONS_ALL
TABLE - FV.FV_TREASURY_SYMBOLS
TABLE - FV.FV_TREASURY_SYMBOLS_HISTORY
TABLE - FV.FV_VALUE_OF_FUND_PERIODS
TABLE - FV.FV_VOIDED_CHECKS
TABLE - FV.FV_YE_CLOSED_TREASURY_SYMBOLS
TABLE - FV.FV_YE_GROUPS
TABLE - FV.FV_YE_GROUP_SEQUENCES
TABLE - FV.FV_YE_SEQUENCE_ACCOUNTS
TABLE - FV.FV_YE_SEQ_BAL_TEMP
VIEW - APPS.FV_1099T_V
VIEW - APPS.FV_AGENCY_LOCATION_CODES_V
VIEW - APPS.FV_BE_BA_FD_DTL_V
VIEW - APPS.FV_BE_BA_FD_HDR_V
VIEW - APPS.FV_BE_GL_V
VIEW - APPS.FV_BE_RPR_DTL_V
VIEW - APPS.FV_BE_RPR_HDR_V
VIEW - APPS.FV_BE_RPR_XLA_V
VIEW - APPS.FV_BE_XLA_V
VIEW - APPS.FV_BUDGETS_WITH_DATES_V
VIEW - APPS.FV_BUDGET_DISTRIBUTION_HDR_V
VIEW - APPS.FV_FACTS1_PERIOD_BALANCES_V
VIEW - APPS.FV_FACTS1_TB_V
VIEW - APPS.FV_FACTS_CUSTOMERS_V
VIEW - APPS.FV_FACTS_PERIOD_BALANCES_TB_V
VIEW - APPS.FV_FACTS_TB_V
VIEW - APPS.FV_FACTS_TRX_V
VIEW - APPS.FV_FACTS_VENDORS_V
VIEW - APPS.FV_FUND_PARAMETERS_V
VIEW - APPS.FV_INVOICE_DTL_V
VIEW - APPS.FV_INVOICE_MASTER_V
VIEW - APPS.FV_INV_HISTSTAT_V
VIEW - APPS.FV_INV_STATCUST_V
VIEW - APPS.FV_INV_STATUSES_V
VIEW - APPS.FV_LOOKUP_CODES
VIEW - APPS.FV_LOOKUP_TYPES
VIEW - APPS.FV_PAYABLE_REFUNDS_V
VIEW - APPS.FV_PAYMENT_MASTER_V
VIEW - APPS.FV_PO_MASTER_V
VIEW - APPS.FV_PYA_GL_V
VIEW - APPS.FV_RECEIPT_MASTER_V
VIEW - APPS.FV_REQUISITION_MASTER_V
VIEW - APPS.FV_SYSTEM_PARAMETERS_V
VIEW - APPS.FV_TBAL_BY_TS_V
VIEW - APPS.FV_TC_GL_V
VIEW - APPS.FV_TPP_ASSIGNMENTS_V
VIEW - APPS.FV_TREAS_CONFIRM_CHECKS_V
VIEW - APPS.FV_XLA_AP_REF_V
VIEW - APPS.FV_XLA_AR_REF_V
VIEW - APPS.FV_XLA_CST_REF_V
VIEW - APPS.FV_XLA_PO_REF_V

Table: FV_1096_DATA_ALL

Description: Temporary processing table populated by FV 1099-GOV and 1099-INT reports for the generation of FV 1096 report

[top of page]

FV.FV_1096_DATA_ALL does not reference any database object

FV.FV_1096_DATA_ALL is referenced by following:

APPS
SYNONYM - FV_1096_DATA
SYNONYM - FV_1096_DATA_ALL

[top of page]

Table: FV_1099C_ALL

Description: Temporary processing table populated by the FVX1099C process

[top of page]

FV.FV_1099C_ALL does not reference any database object

FV.FV_1099C_ALL is referenced by following:

APPS
SYNONYM - FV_1099C
SYNONYM - FV_1099C_ALL

[top of page]

Table: FV_1099_TAPE_DATA_ALL

Description: Temporary processing table populated by FV 1099-GOV and 1099-INT reports

[top of page]

FV.FV_1099_TAPE_DATA_ALL does not reference any database object

FV.FV_1099_TAPE_DATA_ALL is referenced by following:

APPS
SYNONYM - FV_1099_TAPE_DATA
SYNONYM - FV_1099_TAPE_DATA_ALL

[top of page]

Table: FV_ALC_ADDRESSES_ALL

Description: Stores Agency Location Code Addresses

[top of page]

FV.FV_ALC_ADDRESSES_ALL does not reference any database object

FV.FV_ALC_ADDRESSES_ALL is referenced by following:

APPS
SYNONYM - FV_ALC_ADDRESSES_ALL

[top of page]

Table: FV_ALC_GWA_CATEGORIES

Description: Stores the GWA Reporter Categories with effective start and end dates for each ALC with non-blank business activity.

[top of page]

FV.FV_ALC_GWA_CATEGORIES does not reference any database object

FV.FV_ALC_GWA_CATEGORIES is referenced by following:

APPS
SYNONYM - FV_ALC_GWA_CATEGORIES

[top of page]

Table: FV_AP_CASH_POS_TEMP

Description: Temporary table for processing PMC-29 Cash Position
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_AP_CASH_POS_TEMP.CHECKRUN_ID AP_INV_SELECTION_CRITERIA_ALL

[top of page]

FV.FV_AP_CASH_POS_TEMP does not reference any database object

FV.FV_AP_CASH_POS_TEMP is referenced by following:

APPS
SYNONYM - FV_AP_CASH_POS_TEMP

[top of page]

Table: FV_AR_BATCHES_ALL

Description: Stores receipt batch header information to be processed by the Apply Cash Receipt process
Primary Key: FV_AR_BATCHES_PK
  1. BATCH_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_AR_BATCHES_ALL.BATCH_ID AR_BATCHES_ALL
FV_AR_BATCHES_ALL.BATCH_SOURCE_ID AR_BATCH_SOURCES_ALL
FV_AR_BATCHES_ALL.RECEIPT_CLASS_ID AR_RECEIPT_CLASSES
FV_AR_BATCHES_ALL.RECEIPT_METHOD_ID AR_RECEIPT_METHODS
FV_AR_BATCHES_ALL.BANK_ACCOUNT_ID AP_BANK_ACCOUNTS_ALL
FV_AR_BATCHES_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FV_AR_BATCHES_ALL.CE_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS
FV_AR_BATCHES_ALL.CE_BANK_ACCT_USE_ID CE_BANK_ACCT_USES_ALL

[top of page]

FV.FV_AR_BATCHES_ALL does not reference any database object

FV.FV_AR_BATCHES_ALL is referenced by following:

APPS
SYNONYM - FV_AR_BATCHES
SYNONYM - FV_AR_BATCHES_ALL

[top of page]

Table: FV_AR_CONTROLS_ALL

Description: Contains finance accrual charge information

[top of page]

FV.FV_AR_CONTROLS_ALL does not reference any database object

FV.FV_AR_CONTROLS_ALL is referenced by following:

APPS
SYNONYM - FV_AR_CONTROLS
SYNONYM - FV_AR_CONTROLS_ALL

[top of page]

Table: FV_ASSIGN_REASON_CODES_ALL

Description: Stores data elements needed for the Prompt Payment Statistics report
Primary Key: FV_ASSIGN_REASON_CODES_ALL_U1
  1. INVOICE_ID
  2. ENTRY_SOURCE

[top of page]

FV.FV_ASSIGN_REASON_CODES_ALL does not reference any database object

FV.FV_ASSIGN_REASON_CODES_ALL is referenced by following:

APPS
SYNONYM - FV_ASSIGN_REASON_CODES
SYNONYM - FV_ASSIGN_REASON_CODES_ALL

[top of page]

Table: FV_BD_CONTROLS

Description: Contains budgetary discount transactions
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_BD_CONTROLS.INVOICE_PAYMENT_ID AP_INVOICE_PAYMENTS_ALL

[top of page]

FV.FV_BD_CONTROLS does not reference any database object

FV.FV_BD_CONTROLS is referenced by following:

APPS
SYNONYM - FV_BD_CONTROLS

[top of page]

Table: FV_BE_ACCOUNT_PAIRS

Description: Transaction Type/Sub Type account pairings

[top of page]

FV.FV_BE_ACCOUNT_PAIRS does not reference any database object

FV.FV_BE_ACCOUNT_PAIRS is referenced by following:

APPS
SYNONYM - FV_BE_ACCOUNT_PAIRS

[top of page]

Table: FV_BE_INTERFACE

Description: Users insert records into this table before executing the Budget Execution Transactions Import Process

[top of page]

FV.FV_BE_INTERFACE does not reference any database object

FV.FV_BE_INTERFACE is referenced by following:

APPS
SYNONYM - FV_BE_INTERFACE

[top of page]

Table: FV_BE_INTERFACE_CONTROL

Description: Stores the control information required for import processing

[top of page]

FV.FV_BE_INTERFACE_CONTROL does not reference any database object

FV.FV_BE_INTERFACE_CONTROL is referenced by following:

APPS
SYNONYM - FV_BE_INTERFACE_CONTROL

[top of page]

Table: FV_BE_INTERFACE_HISTORY

Description: Same structure as the FV_BE_INTERFACE table

[top of page]

FV.FV_BE_INTERFACE_HISTORY does not reference any database object

FV.FV_BE_INTERFACE_HISTORY is referenced by following:

APPS
SYNONYM - FV_BE_INTERFACE_HISTORY

[top of page]

Table: FV_BE_RPR_TRANSACTIONS

Description: Stores the details for the reprogramming transactions
Primary Key: FV_BE_RPR_TRANSACTIONS_PK1
  1. TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_BE_RPR_TRANSACTIONS.BU_GROUP_ID FV_BUDGET_USER_HDR

[top of page]

FV.FV_BE_RPR_TRANSACTIONS does not reference any database object

FV.FV_BE_RPR_TRANSACTIONS is referenced by following:

APPS
SYNONYM - FV_BE_RPR_TRANSACTIONS

[top of page]

Table: FV_BE_TRANSACTION_TYPES

Description: FV_BE_TRANSACTION_TYPES is used to store appropriation transaction types. This is the base table for the Define Budget Transaction Type form.
Primary Key: FV_BE_TRANSACTION_TYPE_PK1
  1. BE_TT_ID

[top of page]

FV.FV_BE_TRANSACTION_TYPES does not reference any database object

FV.FV_BE_TRANSACTION_TYPES is referenced by following:

APPS
SYNONYM - FV_BE_TRANSACTION_TYPES

[top of page]

Table: FV_BE_TRX_CODES

Description: Stores the transaction codes associated with a transaction type. This is the base table for the detail block of the Define Budget Transaction Types form.

[top of page]

FV.FV_BE_TRX_CODES does not reference any database object

FV.FV_BE_TRX_CODES is referenced by following:

APPS
SYNONYM - FV_BE_TRX_CODES

[top of page]

Table: FV_BE_TRX_DTLS

Description: Stores the transaction details for all budget execution transactions. This is the base table for the detail block of the Define Appropriations and Define Fund Distributions forms.
Primary Key: FV_BE_TRX_DTLS_PK1
  1. TRANSACTION_ID

[top of page]

FV.FV_BE_TRX_DTLS does not reference any database object

FV.FV_BE_TRX_DTLS is referenced by following:

APPS
SYNONYM - FV_BE_TRX_DTLS

[top of page]

Table: FV_BE_TRX_HDRS

Description: Stores the document information for all budget execution transactions. This is the base table for the header block of the Define Appropriations and Define Fund Distributions forms.
Primary Key: FV_BE_TRX_HDRS_PK1
  1. DOC_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_BE_TRX_HDRS.BU_GROUP_ID FV_BUDGET_USER_HDR

[top of page]

FV.FV_BE_TRX_HDRS does not reference any database object

FV.FV_BE_TRX_HDRS is referenced by following:

APPS
SYNONYM - FV_BE_TRX_HDRS

[top of page]

Table: FV_BE_TRX_SUB_TYPES

Description: Stores the sub types associated with a transaction type. This is the base table for the detail block of the Define Budget Transaction Types form.

[top of page]

FV.FV_BE_TRX_SUB_TYPES does not reference any database object

FV.FV_BE_TRX_SUB_TYPES is referenced by following:

APPS
SYNONYM - FV_BE_TRX_SUB_TYPES

[top of page]

Table: FV_BUDGET_DISTRIBUTION_DTL

Description: Budgeting segments data needed for a budget level
Primary Key: FV_BUDGET_DISTRIBUTION_DTL_PK
  1. DISTRIBUTION_DTL_ID

[top of page]

FV.FV_BUDGET_DISTRIBUTION_DTL does not reference any database object

FV.FV_BUDGET_DISTRIBUTION_DTL is referenced by following:

APPS
SYNONYM - FV_BUDGET_DISTRIBUTION_DTL

[top of page]

Table: FV_BUDGET_DISTRIBUTION_HDR

Description: Treasury symbols and fund values data
Primary Key: FV_BUDGET_DISTRIBUTION_HDR_PK
  1. DISTRIBUTION_ID

[top of page]

FV.FV_BUDGET_DISTRIBUTION_HDR does not reference any database object

FV.FV_BUDGET_DISTRIBUTION_HDR is referenced by following:

APPS
SYNONYM - FV_BUDGET_DISTRIBUTION_HDR

[top of page]

Table: FV_BUDGET_LEVELS

Description: Defines the required level of a budget

[top of page]

FV.FV_BUDGET_LEVELS does not reference any database object

FV.FV_BUDGET_LEVELS is referenced by following:

APPS
SYNONYM - FV_BUDGET_LEVELS

[top of page]

Table: FV_BUDGET_OPTIONS

Description: Budget freeze level for a Set of Books

[top of page]

FV.FV_BUDGET_OPTIONS does not reference any database object

FV.FV_BUDGET_OPTIONS is referenced by following:

APPS
SYNONYM - FV_BUDGET_OPTIONS

[top of page]

Table: FV_BUDGET_USER_DTL

Description: User budget access level options
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_BUDGET_USER_DTL.BU_GROUP_ID FV_BUDGET_USER_HDR

[top of page]

FV.FV_BUDGET_USER_DTL does not reference any database object

FV.FV_BUDGET_USER_DTL is referenced by following:

APPS
SYNONYM - FV_BUDGET_USER_DTL

[top of page]

Table: FV_BUDGET_USER_HDR

Description: Information about a budget user group
Primary Key: FV_BUDGET_USER_HDR_PK
  1. BU_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FV_BE_RPR_TRANSACTIONS.BU_GROUP_ID FV_BUDGET_USER_HDR
FV_BE_TRX_HDRS.BU_GROUP_ID FV_BUDGET_USER_HDR
FV_BUDGET_USER_DTL.BU_GROUP_ID FV_BUDGET_USER_HDR

[top of page]

FV.FV_BUDGET_USER_HDR does not reference any database object

FV.FV_BUDGET_USER_HDR is referenced by following:

APPS
SYNONYM - FV_BUDGET_USER_HDR

[top of page]

Table: FV_CCID_CFS_GT

Description:

[top of page]

FV.FV_CCID_CFS_GT does not reference any database object

FV.FV_CCID_CFS_GT is referenced by following:

APPS
SYNONYM - FV_CCID_CFS_GT

[top of page]

Table: FV_CCR_FILE_TEMP

Description: The FV_CCR_FILE_TEMP table definition includes all the fields present in the complete CCR extract file. The data from the extract files is first loaded into this table and then later copied to the FV_CCR_VENDORS process by the data load pro

[top of page]

FV.FV_CCR_FILE_TEMP does not reference any database object

FV.FV_CCR_FILE_TEMP is referenced by following:

APPS
SYNONYM - FV_CCR_FILE_TEMP

[top of page]

Table: FV_CCR_ORGS

Description: This table stores information about the operating units with access to each DUNS/DUNS+4 number
Primary Key: FV_CCR_ORGS_UK
  1. CCR_ID
  2. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_CCR_ORGS.CCR_ID FV_CCR_VENDORS
FV_CCR_ORGS.MAIN_ADDRESS_SITE_ID PO_VENDOR_SITES_ALL
FV_CCR_ORGS.BANK_ACCOUNT_ID AP_BANK_ACCOUNTS_ALL
FV_CCR_ORGS.PAY_SITE_ID PO_VENDOR_SITES_ALL

[top of page]

FV.FV_CCR_ORGS does not reference any database object

FV.FV_CCR_ORGS is referenced by following:

APPS
SYNONYM - FV_CCR_ORGS

[top of page]

Table: FV_CCR_PROCESS_REPORT

Description: The FV_CCR_PROCESS_REPORT temporarily stores the errors encountered during the upload process for reporting purposes.

[top of page]

FV.FV_CCR_PROCESS_REPORT does not reference any database object

FV.FV_CCR_PROCESS_REPORT is referenced by following:

APPS
SYNONYM - FV_CCR_PROCESS_REPORT

[top of page]

Table: FV_CCR_VENDORS

Description: The FV_CCR_VENDORS table stores all the data from CCR that does not have a logical place in the Payables data model. It also stores a supplier reference, and its primary key is the internal identifier CCR_ID
Primary Key: FV_CCR_VENDORS_PK
  1. CCR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_CCR_VENDORS.VENDOR_ID PO_VENDORS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FV_CCR_ORGS.CCR_ID FV_CCR_VENDORS

[top of page]

FV.FV_CCR_VENDORS does not reference any database object

FV.FV_CCR_VENDORS is referenced by following:

APPS
SYNONYM - FV_CCR_VENDORS

[top of page]

Table: FV_CFS_REP_LINES

Description:

[top of page]

FV.FV_CFS_REP_LINES does not reference any database object

FV.FV_CFS_REP_LINES is referenced by following:

APPS
SYNONYM - FV_CFS_REP_LINES

[top of page]

Table: FV_CFS_REP_LINE_CALC

Description:

[top of page]

FV.FV_CFS_REP_LINE_CALC does not reference any database object

FV.FV_CFS_REP_LINE_CALC is referenced by following:

APPS
SYNONYM - FV_CFS_REP_LINE_CALC

[top of page]

Table: FV_CFS_REP_LINE_DTL

Description:

[top of page]

FV.FV_CFS_REP_LINE_DTL does not reference any database object

FV.FV_CFS_REP_LINE_DTL is referenced by following:

APPS
SYNONYM - FV_CFS_REP_LINE_DTL

[top of page]

Table: FV_CFS_REP_TEMP

Description:

[top of page]

FV.FV_CFS_REP_TEMP does not reference any database object

FV.FV_CFS_REP_TEMP is referenced by following:

APPS
SYNONYM - FV_CFS_REP_TEMP

[top of page]

Table: FV_CUST_FINANCE_CHRGS_ALL

Description: Contains customer finance charge information
Primary Key: FV_CUST_FINANCE_CHRGS_PK
  1. CUSTOMER_ID
  2. CHARGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_CUST_FINANCE_CHRGS_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
Foreign Keys to this table:
Foreign Key Column Foreign Table
FV_INVOICE_FINANCE_CHRGS_ALL.CUSTOMER_ID
FV_INVOICE_FINANCE_CHRGS_ALL.CHARGE_ID 		FV_CUST_FINANCE_CHRGS_ALL

[top of page]

FV.FV_CUST_FINANCE_CHRGS_ALL does not reference any database object

FV.FV_CUST_FINANCE_CHRGS_ALL is referenced by following:

APPS
SYNONYM - FV_CUST_FINANCE_CHRGS
SYNONYM - FV_CUST_FINANCE_CHRGS_ALL

[top of page]

Table: FV_CUST_VEND_XREFS

Description: Base table used for the AR/AP Netting Customer Vendor Cross Reference form
Primary Key: FV_CUST_VEND_XREFS_PK1
  1. CUST_VEND_XREF_ID
Primary Key: FV_CUST_VEND_XREFS_U1
  1. SET_OF_BOOKS_ID
  2. CUSTOMER_ID
  3. VENDOR_ID
Primary Key: FV_CUST_VEND_XREFS_U1_1
  1. SET_OF_BOOKS_ID
  2. CUSTOMER_ID
  3. VENDOR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_CUST_VEND_XREFS.VENDOR_ID PO_VENDORS

[top of page]

FV.FV_CUST_VEND_XREFS does not reference any database object

FV.FV_CUST_VEND_XREFS is referenced by following:

APPS
PACKAGE BODY - FV_CMERGE
SYNONYM - FV_CUST_VEND_XREFS

[top of page]

Table: FV_DELINQ_INVOICES_ALL

Description: Stores temporary information needed by the Delinquent Invoices Referral Process

[top of page]

FV.FV_DELINQ_INVOICES_ALL does not reference any database object

FV.FV_DELINQ_INVOICES_ALL is referenced by following:

APPS
SYNONYM - FV_DELINQ_INVOICES
SYNONYM - FV_DELINQ_INVOICES_ALL

[top of page]

Table: FV_DISCOUNTED_INVOICES

Description: Stores discount information on invoices that had available discounts
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_DISCOUNTED_INVOICES.INVOICE_ID AP_INVOICES_ALL

[top of page]

FV.FV_DISCOUNTED_INVOICES does not reference any database object

FV.FV_DISCOUNTED_INVOICES is referenced by following:

APPS
SYNONYM - FV_DISCOUNTED_INVOICES

[top of page]

Table: FV_DMS_AGENCY_DEFINITIONS_ALL

Description: Stores agency information needed by the Delinquent Invoice Referral process
Primary Key: FV_DMS_AGENCY_DEFINITIONS_PK
  1. AGENCY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FV_DMS_CODE_DEFINITIONS_ALL.AGENCY_ID FV_DMS_AGENCY_DEFINITIONS_ALL

[top of page]

FV.FV_DMS_AGENCY_DEFINITIONS_ALL does not reference any database object

FV.FV_DMS_AGENCY_DEFINITIONS_ALL is referenced by following:

APPS
SYNONYM - FV_DMS_AGENCY_DEFINITIONS
SYNONYM - FV_DMS_AGENCY_DEFINITIONS_ALL

[top of page]

Table: FV_DMS_CODE_ASSIGNMENTS_ALL

Description: Stores program code information needed by the Delinquent Invoice Referral process
Primary Key: FV_DMS_CODE_ASSIGNMENTS_PK
  1. FLEX_VALUE_ID
  2. PROGRAM_CODE_ID

[top of page]

FV.FV_DMS_CODE_ASSIGNMENTS_ALL does not reference any database object

FV.FV_DMS_CODE_ASSIGNMENTS_ALL is referenced by following:

APPS
SYNONYM - FV_DMS_CODE_ASSIGNMENTS
SYNONYM - FV_DMS_CODE_ASSIGNMENTS_ALL

[top of page]

Table: FV_DMS_CODE_DEFINITIONS_ALL

Description: Stores program code assignments information needed by the Delinquent Invoice Referral process
Primary Key: FV_DMS_CODE_DEFINITIONS_PK
  1. PROGRAM_CODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_DMS_CODE_DEFINITIONS_ALL.AGENCY_ID FV_DMS_AGENCY_DEFINITIONS_ALL

[top of page]

FV.FV_DMS_CODE_DEFINITIONS_ALL does not reference any database object

FV.FV_DMS_CODE_DEFINITIONS_ALL is referenced by following:

APPS
SYNONYM - FV_DMS_CODE_DEFINITIONS
SYNONYM - FV_DMS_CODE_DEFINITIONS_ALL

[top of page]

Table: FV_DOC_CR_TEMP

Description: Stores the document identifiers which match the search criteria given in the Find window of the Document Cross-Reference window

[top of page]

FV.FV_DOC_CR_TEMP does not reference any database object

FV.FV_DOC_CR_TEMP is referenced by following:

APPS
SYNONYM - FV_DOC_CR_TEMP

[top of page]

Table: FV_ETC_ACTIVITIES

Description: Stores QuickCodes for public sector applications
Primary Key: FV_ETC_EVENTS_PK
  1. LOOKUP_TYPE
  2. LOOKUP_CODE

[top of page]

FV.FV_ETC_ACTIVITIES does not reference any database object

FV.FV_ETC_ACTIVITIES is referenced by following:

APPS
SYNONYM - FV_ETC_ACTIVITIES

[top of page]

Table: FV_EVENTS_TRANSACTION_CODE

Description: Stores short list of US SGL transaction codes for a particular transaction event
Primary Key: FV_EVENTS_TRANSACTION_CODE_PK
  1. USSGL_TRANSACTION_CODE
  2. TRANSACTION_EVENT_ID

[top of page]

FV.FV_EVENTS_TRANSACTION_CODE does not reference any database object

FV.FV_EVENTS_TRANSACTION_CODE is referenced by following:

APPS
SYNONYM - FV_EVENTS_TRANSACTION_CODE

[top of page]

Table: FV_EXTRACT_DETAIL_GT

Description:

[top of page]

APPS.FV_EXTRACT_DETAIL_GT does not reference any database object

APPS.FV_EXTRACT_DETAIL_GT is referenced by following:

APPS
PACKAGE BODY - FV_SLA_PROCESSING_PKG
VIEW - FV_XLA_AP_REF_V
VIEW - FV_XLA_AR_REF_V
VIEW - FV_XLA_CST_REF_V
VIEW - FV_XLA_PO_REF_V

[top of page]

Table: FV_FACTS1_DIFF_BALANCES

Description: Stores data used for FACTS I report generation.

[top of page]

FV.FV_FACTS1_DIFF_BALANCES does not reference any database object

FV.FV_FACTS1_DIFF_BALANCES is referenced by following:

APPS
SYNONYM - FV_FACTS1_DIFF_BALANCES

[top of page]

Table: FV_FACTS1_FED_ACCOUNTS

Description: Stores the Federal accounts required for FACTS I report generation.

[top of page]

FV.FV_FACTS1_FED_ACCOUNTS does not reference any database object

FV.FV_FACTS1_FED_ACCOUNTS is referenced by following:

APPS
SYNONYM - FV_FACTS1_FED_ACCOUNTS

[top of page]

Table: FV_FACTS1_HEADER_ID_GT

Description:

[top of page]

FV.FV_FACTS1_HEADER_ID_GT does not reference any database object

FV.FV_FACTS1_HEADER_ID_GT is referenced by following:

APPS
SYNONYM - FV_FACTS1_HEADER_ID_GT

[top of page]

Table: FV_FACTS1_LINE_BALANCES

Description: Stores information about the journal lines required for FACTS I report generation.

[top of page]

FV.FV_FACTS1_LINE_BALANCES does not reference any database object

FV.FV_FACTS1_LINE_BALANCES is referenced by following:

APPS
SYNONYM - FV_FACTS1_LINE_BALANCES

[top of page]

Table: FV_FACTS1_PERIOD_ATTRIBUTES

Description: Stores the USSGL accounts and their attributes along with amounts required for the FACTS I report generation.

[top of page]

FV.FV_FACTS1_PERIOD_ATTRIBUTES does not reference any database object

FV.FV_FACTS1_PERIOD_ATTRIBUTES is referenced by following:

APPS
SYNONYM - FV_FACTS1_PERIOD_ATTRIBUTES

[top of page]

Table: FV_FACTS1_PROCESSED_JE_HDRS

Description: Stores Journal Header ID for the processed journal lines required for FACTS I report generation.

[top of page]

FV.FV_FACTS1_PROCESSED_JE_HDRS does not reference any database object

FV.FV_FACTS1_PROCESSED_JE_HDRS is referenced by following:

APPS
SYNONYM - FV_FACTS1_PROCESSED_JE_HDRS

[top of page]

Table: FV_FACTS1_RUN

Description: Stores the periods and status for which the FACTS I report was run.

[top of page]

FV.FV_FACTS1_RUN does not reference any database object

FV.FV_FACTS1_RUN is referenced by following:

APPS
SYNONYM - FV_FACTS1_RUN

[top of page]

Table: FV_FACTSII_ACCOUNTS_GT

Description:

[top of page]

FV.FV_FACTSII_ACCOUNTS_GT does not reference any database object

FV.FV_FACTSII_ACCOUNTS_GT is referenced by following:

APPS
SYNONYM - FV_FACTSII_ACCOUNTS_GT

[top of page]

Table: FV_FACTSII_ENDING_BALANCES

Description: Stores the period year ending balances for the FACTSII reporting.

[top of page]

FV.FV_FACTSII_ENDING_BALANCES does not reference any database object

FV.FV_FACTSII_ENDING_BALANCES is referenced by following:

APPS
SYNONYM - FV_FACTSII_ENDING_BALANCES

[top of page]

Table: FV_FACTSI_TEMP

Description:

[top of page]

FV.FV_FACTSI_TEMP does not reference any database object

FV.FV_FACTSI_TEMP is referenced by following:

APPS
SYNONYM - FV_FACTSI_TEMP

[top of page]

Table: FV_FACTS_ATTRIBUTES

Description: Stores the USSGL accounts required for the FACTS II report generation and all corresponding attributes related to them
Primary Key: FV_FACTS_ATTRIBUTES_PK
  1. SGL_ATTRIBUTES_ID

[top of page]

FV.FV_FACTS_ATTRIBUTES does not reference any database object

FV.FV_FACTS_ATTRIBUTES is referenced by following:

APPS
SYNONYM - FV_FACTS_ATTRIBUTES

[top of page]

Table: FV_FACTS_AUTHORIZATIONS

Description: Authorization records for the Treasury symbol
Primary Key: FV_FACTS_AUTHORIZATIONS_PK
  1. AUTHORIZATION_ID

[top of page]

FV.FV_FACTS_AUTHORIZATIONS does not reference any database object

FV.FV_FACTS_AUTHORIZATIONS is referenced by following:

APPS
SYNONYM - FV_FACTS_AUTHORIZATIONS

[top of page]

Table: FV_FACTS_BUDGET_ACCOUNTS

Description: Stores the budget account codes and related information
Primary Key: FV_FACTS_BUDGET_ACCOUNTS_PK
  1. BUDGET_ACCT_CODE_ID

[top of page]

FV.FV_FACTS_BUDGET_ACCOUNTS does not reference any database object

FV.FV_FACTS_BUDGET_ACCOUNTS is referenced by following:

APPS
SYNONYM - FV_FACTS_BUDGET_ACCOUNTS

[top of page]

Table: FV_FACTS_BUD_FED_ACCTS

Description: Holds information about the federal account symbols associated with the budget account codes
Primary Key: FV_FACTS_BUD_FED_ACCTS_PK
  1. BUD_FED_ACCTS_ID

[top of page]

FV.FV_FACTS_BUD_FED_ACCTS does not reference any database object

FV.FV_FACTS_BUD_FED_ACCTS is referenced by following:

APPS
SYNONYM - FV_FACTS_BUD_FED_ACCTS

[top of page]

Table: FV_FACTS_EDIT_CHECK_STATUS

Description: FV_FACTS_EDIT_CHECK_STATUS

[top of page]

FV.FV_FACTS_EDIT_CHECK_STATUS does not reference any database object

FV.FV_FACTS_EDIT_CHECK_STATUS is referenced by following:

APPS
SYNONYM - FV_FACTS_EDIT_CHECK_STATUS

[top of page]

Table: FV_FACTS_ENDING_BALANCES

Description: Stores the FACTS-I yearly ending balances

[top of page]

FV.FV_FACTS_ENDING_BALANCES does not reference any database object

FV.FV_FACTS_ENDING_BALANCES is referenced by following:

APPS
SYNONYM - FV_FACTS_ENDING_BALANCES

[top of page]

Table: FV_FACTS_FEDERAL_ACCOUNTS

Description: Information about the federal account symbol and its associated budget account, if applicable
Primary Key: FV_FACTS_FEDERAL_ACCOUNTS_PK
  1. FEDERAL_ACCT_SYMBOL_ID

[top of page]

FV.FV_FACTS_FEDERAL_ACCOUNTS does not reference any database object

FV.FV_FACTS_FEDERAL_ACCOUNTS is referenced by following:

APPS
SYNONYM - FV_FACTS_FEDERAL_ACCOUNTS

[top of page]

Table: FV_FACTS_FOOTNOTE_HDR

Description: Stores the footnote comments as part of the FACTS II Submission Process

[top of page]

FV.FV_FACTS_FOOTNOTE_HDR does not reference any database object

FV.FV_FACTS_FOOTNOTE_HDR is referenced by following:

APPS
SYNONYM - FV_FACTS_FOOTNOTE_HDR

[top of page]

Table: FV_FACTS_FOOTNOTE_LINES

Description: Stores the footnote sequence and text for a treasury symbol

[top of page]

FV.FV_FACTS_FOOTNOTE_LINES does not reference any database object

FV.FV_FACTS_FOOTNOTE_LINES is referenced by following:

APPS
SYNONYM - FV_FACTS_FOOTNOTE_LINES

[top of page]

Table: FV_FACTS_PERIOD_BALANCES

Description: This table is used by FACTS I Interface process to store Period Ending Balances.

[top of page]

FV.FV_FACTS_PERIOD_BALANCES does not reference any database object

FV.FV_FACTS_PERIOD_BALANCES is referenced by following:

APPS
SYNONYM - FV_FACTS_PERIOD_BALANCES

[top of page]

Table: FV_FACTS_PRC_DTL

Description: Table used for Reporting Code Mapping
Primary Key: FV_FACTS_PRC_DTL_PK
  1. PRC_DETAIL_ID

[top of page]

FV.FV_FACTS_PRC_DTL does not reference any database object

FV.FV_FACTS_PRC_DTL is referenced by following:

APPS
SYNONYM - FV_FACTS_PRC_DTL

[top of page]

Table: FV_FACTS_PRC_HDR

Description: Table used for FACTS Reporting Code Mapping
Primary Key: FV_FACTS_PRC_HDR_PK
  1. PRC_HEADER_ID

[top of page]

FV.FV_FACTS_PRC_HDR does not reference any database object

FV.FV_FACTS_PRC_HDR is referenced by following:

APPS
SYNONYM - FV_FACTS_PRC_HDR

[top of page]

Table: FV_FACTS_REPORT_T2

Description: Temporary work table populated with summary data used in FACTS report generation

[top of page]

FV.FV_FACTS_REPORT_T2 does not reference any database object

FV.FV_FACTS_REPORT_T2 is referenced by following:

APPS
SYNONYM - FV_FACTS_REPORT_T2

[top of page]

Table: FV_FACTS_RT7_ACCOUNTS

Description: Holds values for the US SGL accounts
Primary Key: FV_FACTS_RT7_ACCOUNTS_PK
  1. RT7_ACCOUNT_ID

[top of page]

FV.FV_FACTS_RT7_ACCOUNTS does not reference any database object

FV.FV_FACTS_RT7_ACCOUNTS is referenced by following:

APPS
SYNONYM - FV_FACTS_RT7_ACCOUNTS

[top of page]

Table: FV_FACTS_RT7_CODES

Description: Authorization codes data
Primary Key: FV_FACTS_RT7_CODES_PK
  1. RT7_CODE_ID

[top of page]

FV.FV_FACTS_RT7_CODES does not reference any database object

FV.FV_FACTS_RT7_CODES is referenced by following:

APPS
SYNONYM - FV_FACTS_RT7_CODES

[top of page]

Table: FV_FACTS_RUN

Description: Counter information for FACTS file submission

[top of page]

FV.FV_FACTS_RUN does not reference any database object

FV.FV_FACTS_RUN is referenced by following:

APPS
SYNONYM - FV_FACTS_RUN

[top of page]

Table: FV_FACTS_SUBMISSION

Description: Stores FACTS submission information

[top of page]

FV.FV_FACTS_SUBMISSION does not reference any database object

FV.FV_FACTS_SUBMISSION is referenced by following:

APPS
SYNONYM - FV_FACTS_SUBMISSION

[top of page]

Table: FV_FACTS_TEMP

Description: FACTS II bulk file transactions data

[top of page]

FV.FV_FACTS_TEMP does not reference any database object

FV.FV_FACTS_TEMP is referenced by following:

APPS
SYNONYM - FV_FACTS_TEMP

[top of page]

Table: FV_FACTS_TRX_TEMP

Description: Temporary table that stores the FACTS transactions

[top of page]

FV.FV_FACTS_TRX_TEMP does not reference any database object

FV.FV_FACTS_TRX_TEMP is referenced by following:

APPS
SYNONYM - FV_FACTS_TRX_TEMP

[top of page]

Table: FV_FACTS_USSGL_ACCOUNTS

Description: USSGL accounts data

[top of page]

FV.FV_FACTS_USSGL_ACCOUNTS does not reference any database object

FV.FV_FACTS_USSGL_ACCOUNTS is referenced by following:

APPS
SYNONYM - FV_FACTS_USSGL_ACCOUNTS

[top of page]

Table: FV_FINANCE_CHARGE_CONTROLS_ALL

Description: Contains finance charge information
Primary Key: FV_FINANCE_CHARGE_CONTROLS_PK
  1. CHARGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_FINANCE_CHARGE_CONTROLS_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FV_FINANCE_CHARGE_CONTROLS_ALL.TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
FV_FINANCE_CHARGE_HISTORY.CHARGE_ID FV_FINANCE_CHARGE_CONTROLS_ALL
FV_FINANCE_CHRG_CUST_CLASSES.CHARGE_ID FV_FINANCE_CHARGE_CONTROLS_ALL

[top of page]

FV.FV_FINANCE_CHARGE_CONTROLS_ALL does not reference any database object

FV.FV_FINANCE_CHARGE_CONTROLS_ALL is referenced by following:

APPS
SYNONYM - FV_FINANCE_CHARGE_CONTROLS
SYNONYM - FV_FINANCE_CHARGE_CONTROLS_ALL

[top of page]

Table: FV_FINANCE_CHARGE_HISTORY

Description: Contains finance charge rate or flat fee information for each related finance charge
Primary Key: FV_FINANCE_CHARGE_HISTORY_PK
  1. CHARGE_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_FINANCE_CHARGE_HISTORY.CHARGE_ID FV_FINANCE_CHARGE_CONTROLS_ALL
FV_FINANCE_CHARGE_HISTORY.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I

[top of page]

FV.FV_FINANCE_CHARGE_HISTORY does not reference any database object

FV.FV_FINANCE_CHARGE_HISTORY is referenced by following:

APPS
SYNONYM - FV_FINANCE_CHARGE_HISTORY

[top of page]

Table: FV_FINANCE_CHRG_CUST_CLASSES

Description: Contains finance charge customer types
Primary Key: FV_FINANCE_CHRG_CUST_CLASS_PK
  1. CHARGE_CUST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_FINANCE_CHRG_CUST_CLASSES.CHARGE_ID FV_FINANCE_CHARGE_CONTROLS_ALL
FV_FINANCE_CHRG_CUST_CLASSES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I

[top of page]

FV.FV_FINANCE_CHRG_CUST_CLASSES does not reference any database object

FV.FV_FINANCE_CHRG_CUST_CLASSES is referenced by following:

APPS
SYNONYM - FV_FINANCE_CHRG_CUST_CLASSES

[top of page]

Table: FV_FINCHRG_DEBITMEMO_TEMP

Description: Stores the records that are processed in the Accrue Finance Charge process

[top of page]

FV.FV_FINCHRG_DEBITMEMO_TEMP does not reference any database object

FV.FV_FINCHRG_DEBITMEMO_TEMP is referenced by following:

APPS
SYNONYM - FV_FINCHRG_DEBITMEMO_TEMP

[top of page]

Table: FV_FUNDS_AVAIL_ACCT_RANGES

Description: The Account Ranges that are defined for each column are stored here

[top of page]

FV.FV_FUNDS_AVAIL_ACCT_RANGES does not reference any database object

FV.FV_FUNDS_AVAIL_ACCT_RANGES is referenced by following:

APPS
SYNONYM - FV_FUNDS_AVAIL_ACCT_RANGES

[top of page]

Table: FV_FUNDS_AVAIL_REP_DEF

Description: This table contains the column definitions for all the Funds Available Reports .The seed process will populate this table.

[top of page]

FV.FV_FUNDS_AVAIL_REP_DEF does not reference any database object

FV.FV_FUNDS_AVAIL_REP_DEF is referenced by following:

APPS
SYNONYM - FV_FUNDS_AVAIL_REP_DEF

[top of page]

Table: FV_FUNDS_AVAIL_TEMP

Description:

[top of page]

FV.FV_FUNDS_AVAIL_TEMP does not reference any database object

FV.FV_FUNDS_AVAIL_TEMP is referenced by following:

APPS
SYNONYM - FV_FUNDS_AVAIL_TEMP

[top of page]

Table: FV_FUND_GROUPS

Description: Distinct code for each Set of Books
Primary Key: FV_FUND_GROUPS_PK
  1. FUND_GROUP_CODE
  2. SET_OF_BOOKS_ID

[top of page]

FV.FV_FUND_GROUPS does not reference any database object

FV.FV_FUND_GROUPS is referenced by following:

APPS
SYNONYM - FV_FUND_GROUPS

[top of page]

Table: FV_FUND_PARAMETERS

Description: Contains fund parameters information
Primary Key: FV_FUND_PARAMETERS_PK
  1. FUND_PARAMETER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_FUND_PARAMETERS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I

[top of page]

FV.FV_FUND_PARAMETERS does not reference any database object

FV.FV_FUND_PARAMETERS is referenced by following:

APPS
SYNONYM - FV_FUND_PARAMETERS

[top of page]

Table: FV_FUND_PARAMETERS_HISTORY

Description: Contains fund parameters history information
Primary Key: FV_FUND_PARAMETERS_HISTORY_PK
  1. FUND_PARAMETER_ID

[top of page]

FV.FV_FUND_PARAMETERS_HISTORY does not reference any database object

FV.FV_FUND_PARAMETERS_HISTORY is referenced by following:

APPS
SYNONYM - FV_FUND_PARAMETERS_HISTORY

[top of page]

Table: FV_GOALS_224_TEMP

Description: Information for the FMS Form 224 GOALS file format
Primary Key: FV_GOALS_224_TEMP_PK
  1. GOALS_224_TEMP_ID

[top of page]

FV.FV_GOALS_224_TEMP does not reference any database object

FV.FV_GOALS_224_TEMP is referenced by following:

APPS
SYNONYM - FV_GOALS_224_TEMP

[top of page]

Table: FV_HOLIDAY_DATES

Description: Contains Holidays/Non-Working Dates information
Primary Key: FV_PK_HOLIDAY_DATES
  1. HOLIDAY_ID

[top of page]

FV.FV_HOLIDAY_DATES does not reference any database object

FV.FV_HOLIDAY_DATES is referenced by following:

APPS
SYNONYM - FV_HOLIDAY_DATES

[top of page]

Table: FV_INTERAGENCY_FUNDS_ALL

Description: Interagency information
Primary Key: FV_INTERAGENCY_FUNDS_PK
  1. INTERAGENCY_FUND_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_INTERAGENCY_FUNDS_ALL.INVOICE_ID AP_INVOICES_ALL
FV_INTERAGENCY_FUNDS_ALL.CASH_RECEIPT_ID AR_CASH_RECEIPTS_ALL
FV_INTERAGENCY_FUNDS_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FV_INTERAGENCY_FUNDS_ALL.VENDOR_ID PO_VENDORS

[top of page]

FV.FV_INTERAGENCY_FUNDS_ALL does not reference any database object

FV.FV_INTERAGENCY_FUNDS_ALL is referenced by following:

APPS
SYNONYM - FV_INTERAGENCY_FUNDS
SYNONYM - FV_INTERAGENCY_FUNDS_ALL

[top of page]

Table: FV_INTERIM_CASH_RECEIPTS_ALL

Description: Contains payment batch information
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_INTERIM_CASH_RECEIPTS_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FV_INTERIM_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID AR_RECEIPT_METHODS
FV_INTERIM_CASH_RECEIPTS_ALL.BANK_ACCOUNT_ID AP_BANK_ACCOUNTS_ALL
FV_INTERIM_CASH_RECEIPTS_ALL.CE_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS
FV_INTERIM_CASH_RECEIPTS_ALL.CE_BANK_ACCT_USE_ID CE_BANK_ACCT_USES_ALL

[top of page]

FV.FV_INTERIM_CASH_RECEIPTS_ALL does not reference any database object

FV.FV_INTERIM_CASH_RECEIPTS_ALL is referenced by following:

APPS
SYNONYM - FV_INTERIM_CASH_RECEIPTS
SYNONYM - FV_INTERIM_CASH_RECEIPTS_ALL

[top of page]

Table: FV_INVOICE_FINANCE_CHRGS_ALL

Description: Contains finance charges information associated with invoices entered in Oracle Public Sector Receivables system
Primary Key: FV_INVOICE_FINANCE_CHRGS_PK
  1. CUSTOMER_TRX_ID
  2. CUSTOMER_ID
  3. CHARGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_INVOICE_FINANCE_CHRGS_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FV_INVOICE_FINANCE_CHRGS_ALL.CUSTOMER_TRX_ID RA_CUSTOMER_TRX_ALL
FV_INVOICE_FINANCE_CHRGS_ALL.CUSTOMER_ID
FV_INVOICE_FINANCE_CHRGS_ALL.CHARGE_ID 		FV_CUST_FINANCE_CHRGS_ALL

[top of page]

FV.FV_INVOICE_FINANCE_CHRGS_ALL does not reference any database object

FV.FV_INVOICE_FINANCE_CHRGS_ALL is referenced by following:

APPS
SYNONYM - FV_INVOICE_FINANCE_CHRGS
SYNONYM - FV_INVOICE_FINANCE_CHRGS_ALL

[top of page]

Table: FV_INVOICE_RETURNS_ALL

Description: Contains returned invoice information used as part of Due Date Calculation
Primary Key: FV_INVOICE_RETURNS_ALL_PK
  1. INVOICE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_INVOICE_RETURNS_ALL.INVOICE_ID AP_INVOICES_ALL
FV_INVOICE_RETURNS_ALL.VENDOR_ID PO_VENDORS
FV_INVOICE_RETURNS_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FV_INVOICE_RETURNS_ALL.VENDOR_SITE_ID PO_VENDOR_SITES_ALL

[top of page]

FV.FV_INVOICE_RETURNS_ALL does not reference any database object

FV.FV_INVOICE_RETURNS_ALL is referenced by following:

APPS
SYNONYM - FV_INVOICE_RETURNS
SYNONYM - FV_INVOICE_RETURNS_ALL

[top of page]

Table: FV_INVOICE_RETURN_DATES_ALL

Description: Contains invoice information used as part of Due Date Calculation
Primary Key: FV_INVOICE_RETURN_DATES_PK
  1. RETURN_DATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_INVOICE_RETURN_DATES_ALL.INVOICE_ID AP_INVOICES_ALL
FV_INVOICE_RETURN_DATES_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I

[top of page]

FV.FV_INVOICE_RETURN_DATES_ALL does not reference any database object

FV.FV_INVOICE_RETURN_DATES_ALL is referenced by following:

APPS
SYNONYM - FV_INVOICE_RETURN_DATES
SYNONYM - FV_INVOICE_RETURN_DATES_ALL

[top of page]

Table: FV_INVOICE_STATUSES_ALL

Description: Invoice statuses information for use on the Report on Receivables Due From Public, or Schedule 9 report
Primary Key: SYS_C0026133
  1. CUSTOMER_TRX_ID
  2. STATUS

[top of page]

FV.FV_INVOICE_STATUSES_ALL does not reference any database object

FV.FV_INVOICE_STATUSES_ALL is referenced by following:

APPS
SYNONYM - FV_INVOICE_STATUSES
SYNONYM - FV_INVOICE_STATUSES_ALL

[top of page]

Table: FV_INVOICE_STATUSES_HIST_ALL

Description: Invoice status history information
Primary Key: FV_INVOICE_STATUSES_HIST_PK
  1. INVOICE_HISTORY_ID

[top of page]

FV.FV_INVOICE_STATUSES_HIST_ALL does not reference any database object

FV.FV_INVOICE_STATUSES_HIST_ALL is referenced by following:

APPS
SYNONYM - FV_INVOICE_STATUSES_HIST
SYNONYM - FV_INVOICE_STATUSES_HIST_ALL

[top of page]

Table: FV_INV_SELECTED_DUEDATE

Description: Stores invoice records processed through the Due Date Calculation process so records will not be reprocessed
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_INV_SELECTED_DUEDATE.INVOICE_ID AP_INVOICES_ALL
FV_INV_SELECTED_DUEDATE.VENDOR_ID PO_VENDORS
FV_INV_SELECTED_DUEDATE.TRANSACTION_ID RCV_TRANSACTIONS
FV_INV_SELECTED_DUEDATE.PO_DISTRIBUTION_ID PO_DISTRIBUTIONS_ALL

[top of page]

FV.FV_INV_SELECTED_DUEDATE does not reference any database object

FV.FV_INV_SELECTED_DUEDATE is referenced by following:

APPS
SYNONYM - FV_INV_SELECTED_DUEDATE

[top of page]

Table: FV_INV_SELECTED_DUEDATE_TEMP

Description: Temporary table that stores information about invoices selected for due date payments
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_INV_SELECTED_DUEDATE_TEMP.INVOICE_ID AP_INVOICES_ALL
FV_INV_SELECTED_DUEDATE_TEMP.VENDOR_ID PO_VENDORS

[top of page]

FV.FV_INV_SELECTED_DUEDATE_TEMP does not reference any database object

FV.FV_INV_SELECTED_DUEDATE_TEMP is referenced by following:

APPS
SYNONYM - FV_INV_SELECTED_DUEDATE_TEMP

[top of page]

Table: FV_IPAC_IMPORT

Description: Table used for IPAC disbursement import

[top of page]

FV.FV_IPAC_IMPORT does not reference any database object

FV.FV_IPAC_IMPORT is referenced by following:

APPS
SYNONYM - FV_IPAC_IMPORT

[top of page]

Table: FV_IPAC_IMPORT_ERRORS

Description: Table Used to store IPAC import errors

[top of page]

FV.FV_IPAC_IMPORT_ERRORS does not reference any database object

FV.FV_IPAC_IMPORT_ERRORS is referenced by following:

APPS
SYNONYM - FV_IPAC_IMPORT_ERRORS

[top of page]

Table: FV_IPAC_IMPORT_HISTORY

Description: Table used for IPAC disbursement import

[top of page]

FV.FV_IPAC_IMPORT_HISTORY does not reference any database object

FV.FV_IPAC_IMPORT_HISTORY is referenced by following:

APPS
SYNONYM - FV_IPAC_IMPORT_HISTORY

[top of page]

Table: FV_IPAC_RECURRING_INV

Description: Holds the recurring invoices found in the IPAC file during the Upload IPAC Disbursement proces

[top of page]

FV.FV_IPAC_RECURRING_INV does not reference any database object

FV.FV_IPAC_RECURRING_INV is referenced by following:

APPS
SYNONYM - FV_IPAC_RECURRING_INV

[top of page]

Table: FV_IPAC_TRX_ALL

Description: IPAC transactions table

[top of page]

FV.FV_IPAC_TRX_ALL does not reference any database object

FV.FV_IPAC_TRX_ALL is referenced by following:

APPS
SYNONYM - FV_IPAC_TRX
SYNONYM - FV_IPAC_TRX_ALL

[top of page]

Table: FV_LOCKBOX_IPA_TEMP

Description: FV_LOCKBOX_IPA_TEMP is used by the Lockbox Finance Charge Application process during the processing of a AutoLockbox transmission.
Primary Key: FV_LOCKBOX_IPA_TEMP_PK
  1. TEMP_ID

[top of page]

FV.FV_LOCKBOX_IPA_TEMP does not reference any database object

FV.FV_LOCKBOX_IPA_TEMP is referenced by following:

APPS
SYNONYM - FV_LOCKBOX_IPA_TEMP

[top of page]

Table: FV_OPERATING_UNITS_ALL

Description: Operating unit information
Primary Key: FV_OPERATING_UNITS_ALL_U1
  1. ORGANIZATION_ID

[top of page]

FV.FV_OPERATING_UNITS_ALL does not reference any database object

FV.FV_OPERATING_UNITS_ALL is referenced by following:

APPS
SYNONYM - FV_OPERATING_UNITS
SYNONYM - FV_OPERATING_UNITS_ALL

[top of page]

Table: FV_PAYMENT_FORMAT_TEMP

Description:

[top of page]

FV.FV_PAYMENT_FORMAT_TEMP does not reference any database object

FV.FV_PAYMENT_FORMAT_TEMP is referenced by following:

APPS
SYNONYM - FV_PAYMENT_FORMAT_TEMP

[top of page]

Table: FV_PAYMENT_TYPE_MAP_ALL

Description:

[top of page]

FV.FV_PAYMENT_TYPE_MAP_ALL does not reference any database object

FV.FV_PAYMENT_TYPE_MAP_ALL is referenced by following:

APPS
SYNONYM - FV_PAYMENT_TYPE_MAP
SYNONYM - FV_PAYMENT_TYPE_MAP_ALL

[top of page]

Table: FV_PB_SEQ_ASSIGNMENTS_ALL

Description: The FV_PB_SEQ_ASSIGNMENTS_ALL table is used to define the payment batch sequence assignments . This is the base table for the Payment Batch Sequence Assignments form .
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_PB_SEQ_ASSIGNMENTS_ALL.PAYMENT_REASON_CODE IBY_PAYMENT_REASONS_B

[top of page]

FV.FV_PB_SEQ_ASSIGNMENTS_ALL does not reference any database object

FV.FV_PB_SEQ_ASSIGNMENTS_ALL is referenced by following:

APPS
SYNONYM - FV_PB_SEQ_ASSIGNMENTS
SYNONYM - FV_PB_SEQ_ASSIGNMENTS_ALL

[top of page]

Table: FV_PROMPT_PAY_TEMP

Description: Temporary reporting table

[top of page]

FV.FV_PROMPT_PAY_TEMP does not reference any database object

FV.FV_PROMPT_PAY_TEMP is referenced by following:

APPS
SYNONYM - FV_PROMPT_PAY_TEMP

[top of page]

Table: FV_PYA_ACCOUNTS_TRANS_CODES

Description: Contains offset acounts and transaction codes for different Prior Year Adjustment event combinations

[top of page]

FV.FV_PYA_ACCOUNTS_TRANS_CODES does not reference any database object

FV.FV_PYA_ACCOUNTS_TRANS_CODES is referenced by following:

APPS
SYNONYM - FV_PYA_ACCOUNTS_TRANS_CODES

[top of page]

Table: FV_PYA_AUDITS

Description: Tracks all the original transactions that have been processed by the Transaction Pool process, along with the batch identifier, header identifier and line number information

[top of page]

FV.FV_PYA_AUDITS does not reference any database object

FV.FV_PYA_AUDITS is referenced by following:

APPS
SYNONYM - FV_PYA_AUDITS

[top of page]

Table: FV_PYA_FISCALYEAR_MAP

Description: Stores the fiscal year segment values and their respective mapped period ranges

[top of page]

FV.FV_PYA_FISCALYEAR_MAP does not reference any database object

FV.FV_PYA_FISCALYEAR_MAP is referenced by following:

APPS
SYNONYM - FV_PYA_FISCALYEAR_MAP

[top of page]

Table: FV_PYA_FISCALYEAR_SEGMENT

Description: Stores the fiscal year segment names

[top of page]

FV.FV_PYA_FISCALYEAR_SEGMENT does not reference any database object

FV.FV_PYA_FISCALYEAR_SEGMENT is referenced by following:

APPS
SYNONYM - FV_PYA_FISCALYEAR_SEGMENT

[top of page]

Table: FV_PYA_TRANSACTIONS

Description: Stores all the Prior Year Adjustment transactions with the account, the amount, PYA event, and source details

[top of page]

FV.FV_PYA_TRANSACTIONS does not reference any database object

FV.FV_PYA_TRANSACTIONS is referenced by following:

APPS
SYNONYM - FV_PYA_TRANSACTIONS

[top of page]

Table: FV_PYA_TRANSACTION_HISTORY

Description: Stores all the Prior Year Adjustment transactions processed in the PYA Journal Creation Program

[top of page]

FV.FV_PYA_TRANSACTION_HISTORY does not reference any database object

FV.FV_PYA_TRANSACTION_HISTORY is referenced by following:

APPS
SYNONYM - FV_PYA_TRANSACTION_HISTORY

[top of page]

Table: FV_RCV_TRANSACTIONS

Description: Information about prior period receipts
Primary Key: FV_RCV_TRANSACTIONS_PK
  1. FV_TRANSACTION_ID
Primary Key: SYS_C0031471
  1. FV_TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_RCV_TRANSACTIONS.TRANSACTION_ID RCV_TRANSACTIONS

[top of page]

FV.FV_RCV_TRANSACTIONS does not reference any database object

FV.FV_RCV_TRANSACTIONS is referenced by following:

APPS
SYNONYM - FV_RCV_TRANSACTIONS

[top of page]

Table: FV_RECEIVABLES_ACTIVITY_TEMP

Description: FV_RECEIVABLES_ACTIVITY_TEMP is a temporary table that is populated by the Receivables Activity Worksheet Process. This table serves as the base table for the Receivables Activity Worksheet Report.

[top of page]

FV.FV_RECEIVABLES_ACTIVITY_TEMP does not reference any database object

FV.FV_RECEIVABLES_ACTIVITY_TEMP is referenced by following:

APPS
SYNONYM - FV_RECEIVABLES_ACTIVITY_TEMP

[top of page]

Table: FV_RECEIVABLE_TYPES_ALL

Description: Types of receivables
Primary Key: FV_RECEIVABLE_TYPES_PK
  1. RECEIVABLE_TYPE_ID

[top of page]

FV.FV_RECEIVABLE_TYPES_ALL does not reference any database object

FV.FV_RECEIVABLE_TYPES_ALL is referenced by following:

APPS
SYNONYM - FV_RECEIVABLE_TYPES
SYNONYM - FV_RECEIVABLE_TYPES_ALL

[top of page]

Table: FV_REC_CUST_TRX_TYPES_ALL

Description: Transactions for a specified receivable type
Primary Key: SYS_C0026112
  1. RECEIVABLE_TYPE_ID
  2. CUST_TRX_TYPE_ID

[top of page]

FV.FV_REC_CUST_TRX_TYPES_ALL does not reference any database object

FV.FV_REC_CUST_TRX_TYPES_ALL is referenced by following:

APPS
SYNONYM - FV_REC_CUST_TRX_TYPES
SYNONYM - FV_REC_CUST_TRX_TYPES_ALL

[top of page]

Table: FV_REFUNDS_VOIDS_ALL

Description: Refund, void, and chargeback invoice information for use by the FMS Form 224 report
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_REFUNDS_VOIDS_ALL.INVOICE_ID AP_INVOICES_ALL
FV_REFUNDS_VOIDS_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FV_REFUNDS_VOIDS_ALL.CASH_RECEIPT_ID AR_CASH_RECEIPTS_ALL
FV_REFUNDS_VOIDS_ALL.VENDOR_ID PO_VENDORS
FV_REFUNDS_VOIDS_ALL.CHECK_ID AP_CHECKS_ALL

[top of page]

FV.FV_REFUNDS_VOIDS_ALL does not reference any database object

FV.FV_REFUNDS_VOIDS_ALL is referenced by following:

APPS
SYNONYM - FV_REFUNDS_VOIDS
SYNONYM - FV_REFUNDS_VOIDS_ALL

[top of page]

Table: FV_REPORT_DEFINITIONS

Description: Data elements needed for the SF 1081 Voucher and Schedule of Withdrawals and Credits document and the FMS Form 224 Statement of Transactions report
Primary Key: FV_REPORT_DEFINITIONS_PK
  1. FEDERAL_RPT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_REPORT_DEFINITIONS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I

[top of page]

FV.FV_REPORT_DEFINITIONS does not reference any database object

FV.FV_REPORT_DEFINITIONS is referenced by following:

APPS
SYNONYM - FV_REPORT_DEFINITIONS

[top of page]

Table: FV_SF1080_DETAIL_TEMP

Description: Line information for generation of the SF 1080 Report

[top of page]

FV.FV_SF1080_DETAIL_TEMP does not reference any database object

FV.FV_SF1080_DETAIL_TEMP is referenced by following:

APPS
SYNONYM - FV_SF1080_DETAIL_TEMP

[top of page]

Table: FV_SF1080_HEADER_TEMP

Description: Customer information utilized in the generation of the SF 1080 Report

[top of page]

FV.FV_SF1080_HEADER_TEMP does not reference any database object

FV.FV_SF1080_HEADER_TEMP is referenced by following:

APPS
SYNONYM - FV_SF1080_HEADER_TEMP

[top of page]

Table: FV_SF1081_TEMP

Description: Customer information utilized in the generation of SF 1081 Voucher and Schedule of Withdrawals and Credits

[top of page]

FV.FV_SF1081_TEMP does not reference any database object

FV.FV_SF1081_TEMP is referenced by following:

APPS
SYNONYM - FV_SF1081_TEMP

[top of page]

Table: FV_SF1219_AUDITS

Description: Stores transactions that are already reported in the FMS Form 1219/1220 report, when run on final mode

[top of page]

FV.FV_SF1219_AUDITS does not reference any database object

FV.FV_SF1219_AUDITS is referenced by following:

APPS
SYNONYM - FV_SF1219_AUDITS

[top of page]

Table: FV_SF1219_DEFINITIONS_ACCTS

Description: Stores the flexfield account structures that are used to restrict the transactions reported in the FMS Form 1219/1220 report

[top of page]

FV.FV_SF1219_DEFINITIONS_ACCTS does not reference any database object

FV.FV_SF1219_DEFINITIONS_ACCTS is referenced by following:

APPS
SYNONYM - FV_SF1219_DEFINITIONS_ACCTS

[top of page]

Table: FV_SF1219_MANUAL_LINES

Description: Base table for the FMS Form 1219/1220 Transaction Correction form. Holds the user-assigned report lines for manual transactions.
Primary Key: FV_SF1219_MANUAL_LINES_PK
  1. TEMP_RECORD_ID
  2. LINE_ID

[top of page]

FV.FV_SF1219_MANUAL_LINES does not reference any database object

FV.FV_SF1219_MANUAL_LINES is referenced by following:

APPS
SYNONYM - FV_SF1219_MANUAL_LINES

[top of page]

Table: FV_SF1219_ORG_TEMP

Description: Stores the calculated report lines which are to be reported on the FMS Form 1219/1220 report, along with their corresponding organization identifier

[top of page]

FV.FV_SF1219_ORG_TEMP does not reference any database object

FV.FV_SF1219_ORG_TEMP is referenced by following:

APPS
SYNONYM - FV_SF1219_ORG_TEMP

[top of page]

Table: FV_SF1219_REPORT_TEMPLATE

Description: Seed table that stores all the standard report lines that appear on the FMS Form 1219/1220 report

[top of page]

FV.FV_SF1219_REPORT_TEMPLATE does not reference any database object

FV.FV_SF1219_REPORT_TEMPLATE is referenced by following:

APPS
SYNONYM - FV_SF1219_REPORT_TEMPLATE

[top of page]

Table: FV_SF1219_TEMP

Description: Stores transactions that are processed by the FMS Form 1219/1220 process
Primary Key: FV_SF1219_TEMP_PK
  1. TEMP_RECORD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_SF1219_TEMP.BATCH_ID GL_JE_BATCHES

[top of page]

FV.FV_SF1219_TEMP does not reference any database object

FV.FV_SF1219_TEMP is referenced by following:

APPS
SYNONYM - FV_SF1219_TEMP

[top of page]

Table: FV_SF132_APP_REAPP_SCH

Description: This table contains the column definitions for all the columns in the SF132 Apportionment and Re Apportionment

[top of page]

FV.FV_SF132_APP_REAPP_SCH does not reference any database object

FV.FV_SF132_APP_REAPP_SCH is referenced by following:

APPS
SYNONYM - FV_SF132_APP_REAPP_SCH

[top of page]

Table: FV_SF133_CCIDS_GT

Description:

[top of page]

FV.FV_SF133_CCIDS_GT does not reference any database object

FV.FV_SF133_CCIDS_GT is referenced by following:

APPS
SYNONYM - FV_SF133_CCIDS_GT

[top of page]

Table: FV_SF133_DEFINITIONS_ACCTS

Description: Stores the accounts needed for the SF 133 Report on Budget Execution

[top of page]

FV.FV_SF133_DEFINITIONS_ACCTS does not reference any database object

FV.FV_SF133_DEFINITIONS_ACCTS is referenced by following:

APPS
SYNONYM - FV_SF133_DEFINITIONS_ACCTS

[top of page]

Table: FV_SF133_DEFINITIONS_COLS_TEMP

Description: Temporary table populated with summary data calculated by the SF 133 Report on Budget Execution process

[top of page]

FV.FV_SF133_DEFINITIONS_COLS_TEMP does not reference any database object

FV.FV_SF133_DEFINITIONS_COLS_TEMP is referenced by following:

APPS
SYNONYM - FV_SF133_DEFINITIONS_COLS_TEMP

[top of page]

Table: FV_SF133_DEFINITIONS_LINES

Description: Stores the data elements required for the SF 133 Report on Budget Execution

[top of page]

FV.FV_SF133_DEFINITIONS_LINES does not reference any database object

FV.FV_SF133_DEFINITIONS_LINES is referenced by following:

APPS
SYNONYM - FV_SF133_DEFINITIONS_LINES

[top of page]

Table: FV_SF133_LOAD_ACCTS

Description: Seed table used to load the USSGL account codes into the FV_SF133_DEFINTIONS_LINES table

[top of page]

FV.FV_SF133_LOAD_ACCTS does not reference any database object

FV.FV_SF133_LOAD_ACCTS is referenced by following:

APPS
SYNONYM - FV_SF133_LOAD_ACCTS

[top of page]

Table: FV_SF133_LOAD_LINES

Description: Seed table used to load the SF 133 Report on Budget Execution line number and label into the FV_SF133_DEFINITIONS_LINES table

[top of page]

FV.FV_SF133_LOAD_LINES does not reference any database object

FV.FV_SF133_LOAD_LINES is referenced by following:

APPS
SYNONYM - FV_SF133_LOAD_LINES

[top of page]

Table: FV_SF224_AUDITS

Description: Tracks records that have already been reported on the FMS Form 224 Statement of Transactions report

[top of page]

FV.FV_SF224_AUDITS does not reference any database object

FV.FV_SF224_AUDITS is referenced by following:

APPS
SYNONYM - FV_SF224_AUDITS

[top of page]

Table: FV_SF224_MAP

Description: This table stores the combination of Business Activity and GWA Reporter Category and the report ability of transaction categories for that combination.

[top of page]

FV.FV_SF224_MAP does not reference any database object

FV.FV_SF224_MAP is referenced by following:

APPS
SYNONYM - FV_SF224_MAP

[top of page]

Table: FV_SF224_RUN

Description: This table maintains the last run extract process status of the 224 process.

[top of page]

FV.FV_SF224_RUN does not reference any database object

FV.FV_SF224_RUN is referenced by following:

APPS
SYNONYM - FV_SF224_RUN

[top of page]

Table: FV_SF224_TEMP

Description: Contains those records selected for reporting in the specified period
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_SF224_TEMP.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FV_SF224_TEMP.JE_BATCH_ID GL_JE_BATCHES

[top of page]

FV.FV_SF224_TEMP does not reference any database object

FV.FV_SF224_TEMP is referenced by following:

APPS
SYNONYM - FV_SF224_TEMP

[top of page]

Table: FV_SF224_VOID_TEMP

Description: Used by FMS Form 224 process to store the voided transactions for processing

[top of page]

FV.FV_SF224_VOID_TEMP does not reference any database object

FV.FV_SF224_VOID_TEMP is referenced by following:

APPS
SYNONYM - FV_SF224_VOID_TEMP

[top of page]

Table: FV_STATUS_FUNDS_FINAL

Description: Stores all calculations done in the stored procedure for the Status of Funds report

[top of page]

FV.FV_STATUS_FUNDS_FINAL does not reference any database object

FV.FV_STATUS_FUNDS_FINAL is referenced by following:

APPS
SYNONYM - FV_STATUS_FUNDS_FINAL

[top of page]

Table: FV_STATUS_FUNDS_TEMP

Description: Stores all temporary calculations done in the stored procedure for the Status of Funds report

[top of page]

FV.FV_STATUS_FUNDS_TEMP does not reference any database object

FV.FV_STATUS_FUNDS_TEMP is referenced by following:

APPS
SYNONYM - FV_STATUS_FUNDS_TEMP

[top of page]

Table: FV_STATUS_OBLIG_TEMP

Description: Temporary report table for Status of Obligation report

[top of page]

FV.FV_STATUS_OBLIG_TEMP does not reference any database object

FV.FV_STATUS_OBLIG_TEMP is referenced by following:

APPS
SYNONYM - FV_STATUS_OBLIG_TEMP

[top of page]

Table: FV_SUMMARY_CONSOLIDATE_ALL

Description: Base table for the form Summary Schedules and Consolidated Payment File that stores the Payment Batch names with Control Number and Consolidated Schedule Number to generate Summary Schedules and Consolidate Payment File respectively.
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_SUMMARY_CONSOLIDATE_ALL.PAYMENT_INSTRUCTION_ID IBY_PAY_INSTRUCTIONS_ALL

[top of page]

FV.FV_SUMMARY_CONSOLIDATE_ALL does not reference any database object

FV.FV_SUMMARY_CONSOLIDATE_ALL is referenced by following:

APPS
SYNONYM - FV_SUMMARY_CONSOLIDATE
SYNONYM - FV_SUMMARY_CONSOLIDATE_ALL

[top of page]

Table: FV_SYSTEM_PARAMETERS

Description: Stores Federal System parameters
Primary Key: FV_SYSTEM_PARAMETERS_PK
  1. LAST_UPDATE_DATE

[top of page]

FV.FV_SYSTEM_PARAMETERS does not reference any database object

FV.FV_SYSTEM_PARAMETERS is referenced by following:

APPS
SYNONYM - FV_SYSTEM_PARAMETERS

[top of page]

Table: FV_TC_MAP_DTL_ALL

Description: Detail information of the transaction code mapping window

[top of page]

FV.FV_TC_MAP_DTL_ALL does not reference any database object

FV.FV_TC_MAP_DTL_ALL is referenced by following:

APPS
SYNONYM - FV_TC_MAP_DTL_ALL

[top of page]

Table: FV_TC_MAP_HDR_ALL

Description: Contains the header information of the transaction mapping information

[top of page]

FV.FV_TC_MAP_HDR_ALL does not reference any database object

FV.FV_TC_MAP_HDR_ALL is referenced by following:

APPS
SYNONYM - FV_TC_MAP_HDR_ALL

[top of page]

Table: FV_TC_OFFSETS

Description: Stores treasury confirmation offset information
Primary Key: FV_TC_OFFSET_CO_TR_PAY_NUM_U1
  1. CORRECTED_TREASURY_PAY_NUMBER
Primary Key: FV_TC_OFFSET_U1
  1. FV_TC_OFFSET_ID

[top of page]

FV.FV_TC_OFFSETS does not reference any database object

FV.FV_TC_OFFSETS is referenced by following:

APPS
SYNONYM - FV_TC_OFFSETS

[top of page]

Table: FV_TERMS_TYPES

Description: Payment terms information
Primary Key: FV_TERMS_TYPES_PK
  1. TERM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_TERMS_TYPES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I

[top of page]

FV.FV_TERMS_TYPES does not reference any database object

FV.FV_TERMS_TYPES is referenced by following:

APPS
SYNONYM - FV_TERMS_TYPES

[top of page]

Table: FV_THIRD_PARTY_TEMP

Description: This table is used to store information to be reported on Third Party Remittance Report

[top of page]

FV.FV_THIRD_PARTY_TEMP does not reference any database object

FV.FV_THIRD_PARTY_TEMP is referenced by following:

APPS
SYNONYM - FV_THIRD_PARTY_TEMP

[top of page]

Table: FV_TOP_EXCLUSION_CRITERIA_ALL

Description:
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_TOP_EXCLUSION_CRITERIA_ALL.PAYMENT_REASON_CODE IBY_PAYMENT_REASONS_B

[top of page]

FV.FV_TOP_EXCLUSION_CRITERIA_ALL does not reference any database object

FV.FV_TOP_EXCLUSION_CRITERIA_ALL is referenced by following:

APPS
SYNONYM - FV_TOP_EXCLUSION_CRITERIA
SYNONYM - FV_TOP_EXCLUSION_CRITERIA_ALL

[top of page]

Table: FV_TPP_ASSIGNMENTS_ALL

Description: Defines the third party assignments
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_TPP_ASSIGNMENTS_ALL.EXT_PAYEE_ID IBY_EXTERNAL_PAYEES_ALL

[top of page]

FV.FV_TPP_ASSIGNMENTS_ALL does not reference any database object

FV.FV_TPP_ASSIGNMENTS_ALL is referenced by following:

APPS
SYNONYM - FV_TPP_ASSIGNMENTS
SYNONYM - FV_TPP_ASSIGNMENTS_ALL

[top of page]

Table: FV_TPP_CHECK_DETAILS_ALL

Description: Stores information about each payment that was changed

[top of page]

FV.FV_TPP_CHECK_DETAILS_ALL does not reference any database object

FV.FV_TPP_CHECK_DETAILS_ALL is referenced by following:

APPS
SYNONYM - FV_TPP_CHECK_DETAILS
SYNONYM - FV_TPP_CHECK_DETAILS_ALL

[top of page]

Table: FV_TP_BULK_FMT_DATA

Description: Stores all the agency-related data and the total payment amount along with the total number of payment records

[top of page]

FV.FV_TP_BULK_FMT_DATA does not reference any database object

FV.FV_TP_BULK_FMT_DATA is referenced by following:

APPS
SYNONYM - FV_TP_BULK_FMT_DATA

[top of page]

Table: FV_TP_TS_AMT_DATA

Description:
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_TP_TS_AMT_DATA.PAYMENT_INSTRUCTION_ID IBY_PAY_INSTRUCTIONS_ALL

[top of page]

FV.FV_TP_TS_AMT_DATA does not reference any database object

FV.FV_TP_TS_AMT_DATA is referenced by following:

APPS
SYNONYM - FV_TP_TS_AMT_DATA

[top of page]

Table: FV_TRANSACTION_EVENTS

Description: Defines transaction events for a given activity in an application
Primary Key: FV_TRANSACTION_EVENTS_PK
  1. TRANSACTION_EVENT_ID
  2. TRANSACTION_HEADER_ID

[top of page]

FV.FV_TRANSACTION_EVENTS does not reference any database object

FV.FV_TRANSACTION_EVENTS is referenced by following:

APPS
SYNONYM - FV_TRANSACTION_EVENTS

[top of page]

Table: FV_TRANSACTION_HEADERS

Description: Stores header information for a transaction event activity, application, user, responsibility, or transaction type
Primary Key: FV_TRANSACTION_HEADERS_PK
  1. TRANSACTION_HEADER_ID

[top of page]

FV.FV_TRANSACTION_HEADERS does not reference any database object

FV.FV_TRANSACTION_HEADERS is referenced by following:

APPS
SYNONYM - FV_TRANSACTION_HEADERS

[top of page]

Table: FV_TREASURY_CHECK_RANGES

Description: Contains the check ranges defined for treasury confirmation payment batch

[top of page]

FV.FV_TREASURY_CHECK_RANGES does not reference any database object

FV.FV_TREASURY_CHECK_RANGES is referenced by following:

APPS
SYNONYM - FV_TREASURY_CHECK_RANGES

[top of page]

Table: FV_TREASURY_CONFIRMATIONS_ALL

Description: Contains information about the paid schedule numbers, Treasury check number ranges, and payment schedules sent to the U.S. Treasury; stores the disbursement in transit account number of the fund balance with the Treasury account number aft
Primary Key: FV_TREASURY_CONFIRMATION_PK
  1. TREASURY_CONFIRMATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_TREASURY_CONFIRMATIONS_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FV_TREASURY_CONFIRMATIONS_ALL.INVOICE_PAYMENT_ID AP_INVOICE_PAYMENTS_ALL

[top of page]

FV.FV_TREASURY_CONFIRMATIONS_ALL does not reference any database object

FV.FV_TREASURY_CONFIRMATIONS_ALL is referenced by following:

APPS
SYNONYM - FV_TREASURY_CONFIRMATIONS
SYNONYM - FV_TREASURY_CONFIRMATIONS_ALL

[top of page]

Table: FV_TREASURY_SYMBOLS

Description: New base table for the Define Appropriation Parameters form
Primary Key: FV_TREASURY_SYMBOL_TSSOB_UNQ
  1. TREASURY_SYMBOL
  2. SET_OF_BOOKS_ID
Primary Key: FV_TREASURY_SYMBOL_TS_UNQ
  1. TREASURY_SYMBOL

[top of page]

FV.FV_TREASURY_SYMBOLS does not reference any database object

FV.FV_TREASURY_SYMBOLS is referenced by following:

APPS
SYNONYM - FV_TREASURY_SYMBOLS

[top of page]

Table: FV_TREASURY_SYMBOLS_HISTORY

Description: New base table for the Purge Treasury Symbols process
Primary Key: FV_TREASURY_SYM_HIST_TSSOB_UNQ
  1. TREASURY_SYMBOL
  2. SET_OF_BOOKS_ID
Primary Key: FV_TREASURY_SYM_HIST_TS_UNQ
  1. TREASURY_SYMBOL

[top of page]

FV.FV_TREASURY_SYMBOLS_HISTORY does not reference any database object

FV.FV_TREASURY_SYMBOLS_HISTORY is referenced by following:

APPS
SYNONYM - FV_TREASURY_SYMBOLS_HISTORY

[top of page]

Table: FV_VALUE_OF_FUND_PERIODS

Description: Current value of funds rates information
Primary Key: FV_VALUE_OF_FUND_PERIODS_PK
  1. VALUE_OF_FUND_PERIODS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_VALUE_OF_FUND_PERIODS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I

[top of page]

FV.FV_VALUE_OF_FUND_PERIODS does not reference any database object

FV.FV_VALUE_OF_FUND_PERIODS is referenced by following:

APPS
SYNONYM - FV_VALUE_OF_FUND_PERIODS

[top of page]

Table: FV_VOIDED_CHECKS

Description: Stores checks voided in Payables; used by the DIT Voided Check process
Primary Key: FV_VOIDED_CHECKS_PK
  1. VOID_ID
Primary Key: FV_VOIDED_CHECKS_U1
  1. CHECK_ID

[top of page]

FV.FV_VOIDED_CHECKS does not reference any database object

FV.FV_VOIDED_CHECKS is referenced by following:

APPS
SYNONYM - FV_VOIDED_CHECKS

[top of page]

Table: FV_YE_CLOSED_TREASURY_SYMBOLS

Description: Populated by the Year End process when closing a Treasury Symbol in Final mode

[top of page]

FV.FV_YE_CLOSED_TREASURY_SYMBOLS does not reference any database object

FV.FV_YE_CLOSED_TREASURY_SYMBOLS is referenced by following:

APPS
SYNONYM - FV_YE_CLOSED_TREASURY_SYMBOLS

[top of page]

Table: FV_YE_GROUPS

Description: Year End group definitions
Primary Key: FV_YE_GROUPS_U1
  1. GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FV_YE_GROUP_SEQUENCES.GROUP_ID FV_YE_GROUPS

[top of page]

FV.FV_YE_GROUPS does not reference any database object

FV.FV_YE_GROUPS is referenced by following:

APPS
SYNONYM - FV_YE_GROUPS

[top of page]

Table: FV_YE_GROUP_SEQUENCES

Description: Sequence information for each group
Primary Key: FV_YE_GROUP_SEQUENCES_U1
  1. SEQUENCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_YE_GROUP_SEQUENCES.GROUP_ID FV_YE_GROUPS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FV_YE_SEQUENCE_ACCOUNTS.SEQUENCE_ID FV_YE_GROUP_SEQUENCES

[top of page]

FV.FV_YE_GROUP_SEQUENCES does not reference any database object

FV.FV_YE_GROUP_SEQUENCES is referenced by following:

APPS
SYNONYM - FV_YE_GROUP_SEQUENCES

[top of page]

Table: FV_YE_SEQUENCE_ACCOUNTS

Description: Detail table of FV_YE_GROUP_SEQUENCES
Primary Key: FV_YE_SEQUENCE_ACCOUNTS_U1
  1. SEQUENCE_ACCT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FV_YE_SEQUENCE_ACCOUNTS.SEQUENCE_ID FV_YE_GROUP_SEQUENCES

[top of page]

FV.FV_YE_SEQUENCE_ACCOUNTS does not reference any database object

FV.FV_YE_SEQUENCE_ACCOUNTS is referenced by following:

APPS
SYNONYM - FV_YE_SEQUENCE_ACCOUNTS

[top of page]

Table: FV_YE_SEQ_BAL_TEMP

Description: Temporary table populated during the Year End Closing process

[top of page]

FV.FV_YE_SEQ_BAL_TEMP does not reference any database object

FV.FV_YE_SEQ_BAL_TEMP is referenced by following:

APPS
SYNONYM - FV_YE_SEQ_BAL_TEMP

[top of page]

View: FV_1099T_V

[top of page]

APPS.FV_1099T_V references the following:

APPS
SYNONYM - FV_1099C

APPS.FV_1099T_V is not referenced by any database object

[top of page]

View: FV_AGENCY_LOCATION_CODES_V

[top of page]

APPS.FV_AGENCY_LOCATION_CODES_V references the following:

APPS
SYNONYM - CE_BANK_ACCOUNTS
SYNONYM - CE_BANK_ACCT_USES_ALL
SYNONYM - FV_OPERATING_UNITS_ALL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.FV_AGENCY_LOCATION_CODES_V is not referenced by any database object

[top of page]

View: FV_BE_BA_FD_DTL_V

[top of page]

APPS.FV_BE_BA_FD_DTL_V references the following:

APPS
SYNONYM - FV_BE_ACCOUNT_PAIRS
SYNONYM - FV_BE_TRANSACTION_TYPES
SYNONYM - FV_BE_TRX_DTLS
SYNONYM - FV_BE_TRX_HDRS
SYNONYM - FV_BE_TRX_SUB_TYPES
PACKAGE - FV_BE_XLA_PKG
SYNONYM - GL_LEDGERS
SYNONYM - XLA_EVENTS_GT
APPS.FV_BE_BA_FD_DTL_V is referenced by following:

APPS
PACKAGE BODY - XLA_08901_AAD_S_000002_BC_PKG

[top of page]

View: FV_BE_BA_FD_HDR_V

[top of page]

APPS.FV_BE_BA_FD_HDR_V references the following:

APPS
SYNONYM - FV_BE_TRX_DTLS
SYNONYM - FV_BE_TRX_HDRS
PACKAGE - FV_BE_XLA_PKG
SYNONYM - FV_FUND_PARAMETERS
SYNONYM - FV_TREASURY_SYMBOLS
SYNONYM - GL_LEDGERS
SYNONYM - XLA_EVENTS_GT
APPS.FV_BE_BA_FD_HDR_V is referenced by following:

APPS
PACKAGE BODY - XLA_08901_AAD_S_000002_BC_PKG
PACKAGE BODY - XLA_08901_AAD_S_000002_PKG

[top of page]

View: FV_BE_GL_V

[top of page]

APPS.FV_BE_GL_V references the following:

APPS
SYNONYM - FV_BE_TRANSACTION_TYPES
SYNONYM - FV_BE_TRX_DTLS
SYNONYM - FV_BE_TRX_HDRS
SYNONYM - FV_BUDGET_LEVELS
SYNONYM - FV_TREASURY_SYMBOLS
SYNONYM - GL_JE_HEADERS
SYNONYM - GL_JE_LINES
APPS.FV_BE_GL_V is referenced by following:

APPS
VIEW - XLA_FV_BE_GL_V

[top of page]

View: FV_BE_RPR_DTL_V

[top of page]

APPS.FV_BE_RPR_DTL_V references the following:

APPS
PACKAGE - FND_FLEX_EXT
SYNONYM - FV_BE_ACCOUNT_PAIRS
SYNONYM - FV_BE_RPR_TRANSACTIONS
SYNONYM - FV_BE_TRANSACTION_TYPES
SYNONYM - FV_BE_TRX_SUB_TYPES
PACKAGE - FV_BE_XLA_PKG
SYNONYM - GL_LEDGERS
SYNONYM - XLA_EVENTS_GT
APPS.FV_BE_RPR_DTL_V is referenced by following:

APPS
PACKAGE BODY - XLA_08901_AAD_S_000002_BC_PKG

[top of page]

View: FV_BE_RPR_HDR_V

[top of page]

APPS.FV_BE_RPR_HDR_V references the following:

APPS
SYNONYM - FV_BE_RPR_TRANSACTIONS
SYNONYM - GL_LEDGERS
SYNONYM - XLA_EVENTS_GT
APPS.FV_BE_RPR_HDR_V is referenced by following:

APPS
PACKAGE BODY - XLA_08901_AAD_S_000002_BC_PKG
PACKAGE BODY - XLA_08901_AAD_S_000002_PKG

[top of page]

View: FV_BE_RPR_XLA_V

[top of page]

APPS.FV_BE_RPR_XLA_V references the following:

APPS
SYNONYM - FV_BE_RPR_TRANSACTIONS
SYNONYM - FV_BUDGET_LEVELS

APPS.FV_BE_RPR_XLA_V is not referenced by any database object

[top of page]

View: FV_BE_XLA_V

[top of page]

APPS.FV_BE_XLA_V references the following:

APPS
SYNONYM - FV_BE_TRX_HDRS
SYNONYM - FV_BUDGET_LEVELS
SYNONYM - FV_TREASURY_SYMBOLS

APPS.FV_BE_XLA_V is not referenced by any database object

[top of page]

View: FV_BUDGETS_WITH_DATES_V

[top of page]

APPS.FV_BUDGETS_WITH_DATES_V references the following:

APPS
SYNONYM - GL_BUDGETS
SYNONYM - GL_BUDGET_VERSIONS
SYNONYM - GL_PERIOD_STATUSES

APPS.FV_BUDGETS_WITH_DATES_V is not referenced by any database object

[top of page]

View: FV_BUDGET_DISTRIBUTION_HDR_V

[top of page]

APPS.FV_BUDGET_DISTRIBUTION_HDR_V references the following:

APPS
SYNONYM - FV_BUDGET_DISTRIBUTION_HDR
SYNONYM - FV_TREASURY_SYMBOLS

APPS.FV_BUDGET_DISTRIBUTION_HDR_V is not referenced by any database object

[top of page]

View: FV_FACTS1_PERIOD_BALANCES_V

[top of page]

APPS.FV_FACTS1_PERIOD_BALANCES_V references the following:

APPS
SYNONYM - FV_FACTS1_DIFF_BALANCES
SYNONYM - FV_FACTS1_LINE_BALANCES
SYNONYM - FV_FACTS1_PERIOD_ATTRIBUTES
SYNONYM - FV_FACTS_ENDING_BALANCES
APPS.FV_FACTS1_PERIOD_BALANCES_V is referenced by following:

APPS
PACKAGE BODY - FV_FACTS1_PKG
PACKAGE BODY - FV_YE_CLOSE

[top of page]

View: FV_FACTS1_TB_V

[top of page]

APPS.FV_FACTS1_TB_V references the following:

APPS
SYNONYM - FND_FLEX_VALUES
SYNONYM - FND_FLEX_VALUES_TL
SYNONYM - FND_ID_FLEX_SEGMENTS
PACKAGE - FND_PROFILE
SYNONYM - FND_SEGMENT_ATTRIBUTE_VALUES
SYNONYM - FV_FACTS_REPORT_T2
SYNONYM - FV_FUND_PARAMETERS
SYNONYM - FV_TREASURY_SYMBOLS
SYNONYM - GL_ACCESS_SET_ASSIGNMENTS
SYNONYM - GL_LEDGERS

APPS.FV_FACTS1_TB_V is not referenced by any database object

[top of page]

View: FV_FACTS_CUSTOMERS_V

[top of page]

APPS.FV_FACTS_CUSTOMERS_V references the following:

APPS
SYNONYM - FV_SYSTEM_PARAMETERS
SYNONYM - HZ_CUST_ACCOUNTS
APPS.FV_FACTS_CUSTOMERS_V is referenced by following:

APPS
PACKAGE BODY - FV_FACTS_TRX_REGISTER
PACKAGE BODY - FV_IPAC

[top of page]

View: FV_FACTS_PERIOD_BALANCES_TB_V

[top of page]

APPS.FV_FACTS_PERIOD_BALANCES_TB_V references the following:

APPS
SYNONYM - FV_FACTS1_DIFF_BALANCES
SYNONYM - FV_FACTS1_LINE_BALANCES
SYNONYM - FV_FACTS1_PERIOD_ATTRIBUTES
SYNONYM - FV_FACTS_ENDING_BALANCES

APPS.FV_FACTS_PERIOD_BALANCES_TB_V is not referenced by any database object

[top of page]

View: FV_FACTS_TB_V

[top of page]

APPS.FV_FACTS_TB_V references the following:

APPS
SYNONYM - FND_FLEX_VALUES
SYNONYM - FND_FLEX_VALUES_TL
SYNONYM - FND_ID_FLEX_SEGMENTS
PACKAGE - FND_PROFILE
SYNONYM - FND_SEGMENT_ATTRIBUTE_VALUES
SYNONYM - FV_FACTS_TEMP
SYNONYM - FV_TREASURY_SYMBOLS
TABLE - GL_ACCESS_SET_LEDGERS
SYNONYM - GL_LEDGERS

APPS.FV_FACTS_TB_V is not referenced by any database object

[top of page]

View: FV_FACTS_TRX_V

[top of page]

APPS.FV_FACTS_TRX_V references the following:

APPS
SYNONYM - FND_FLEX_VALUES
SYNONYM - FND_FLEX_VALUES_TL
SYNONYM - FND_ID_FLEX_SEGMENTS
PACKAGE - FND_PROFILE
SYNONYM - FND_SEGMENT_ATTRIBUTE_VALUES
SYNONYM - FV_FACTS_TRX_TEMP
SYNONYM - FV_TREASURY_SYMBOLS
TABLE - GL_ACCESS_SET_LEDGERS
SYNONYM - GL_CODE_COMBINATIONS
SYNONYM - GL_LEDGERS

APPS.FV_FACTS_TRX_V is not referenced by any database object

[top of page]

View: FV_FACTS_VENDORS_V

[top of page]

APPS.FV_FACTS_VENDORS_V references the following:

APPS
SYNONYM - FV_SYSTEM_PARAMETERS
VIEW - PO_VENDORS
APPS.FV_FACTS_VENDORS_V is referenced by following:

APPS
PACKAGE BODY - FV_FACTS_TRX_REGISTER

[top of page]

View: FV_FUND_PARAMETERS_V

[top of page]

APPS.FV_FUND_PARAMETERS_V references the following:

APPS
SYNONYM - FV_FUND_PARAMETERS

APPS.FV_FUND_PARAMETERS_V is not referenced by any database object

[top of page]

View: FV_INVOICE_DTL_V

[top of page]

APPS.FV_INVOICE_DTL_V references the following:

APPS
SYNONYM - AP_INVOICES_ALL
PACKAGE - AP_INVOICES_PKG
PACKAGE - AP_INVOICES_UTILITY_PKG
SYNONYM - AP_INVOICE_DISTRIBUTIONS_ALL
SYNONYM - AP_INVOICE_LINES_ALL

APPS.FV_INVOICE_DTL_V is not referenced by any database object

[top of page]

View: FV_INVOICE_MASTER_V

[top of page]

APPS.FV_INVOICE_MASTER_V references the following:

APPS
SYNONYM - AP_INVOICES
PACKAGE - AP_INVOICES_PKG
PACKAGE - AP_INVOICES_UTILITY_PKG

APPS.FV_INVOICE_MASTER_V is not referenced by any database object

[top of page]

View: FV_INV_HISTSTAT_V

[top of page]

APPS.FV_INV_HISTSTAT_V references the following:

APPS
SYNONYM - FV_INVOICE_STATUSES
SYNONYM - FV_INVOICE_STATUSES_HIST

APPS.FV_INV_HISTSTAT_V is not referenced by any database object

[top of page]

View: FV_INV_STATCUST_V

[top of page]

APPS.FV_INV_STATCUST_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FV_INV_STATUSES_V
VIEW - FV_LOOKUP_CODES
SYNONYM - FV_RECEIVABLE_TYPES

APPS.FV_INV_STATCUST_V is not referenced by any database object

[top of page]

View: FV_INV_STATUSES_V

[top of page]

APPS.FV_INV_STATUSES_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
PACKAGE - FND_GLOBAL
SYNONYM - FV_FINANCE_CHARGE_CONTROLS
VIEW - FV_LOOKUP_CODES
SYNONYM - FV_RECEIVABLE_TYPES
SYNONYM - FV_REC_CUST_TRX_TYPES_ALL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - RA_CUSTOMER_TRX_ALL
APPS.FV_INV_STATUSES_V is referenced by following:

APPS
VIEW - FV_INV_STATCUST_V

[top of page]

View: FV_LOOKUP_CODES

[top of page]

APPS.FV_LOOKUP_CODES references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
APPS.FV_LOOKUP_CODES is referenced by following:

APPS
PACKAGE BODY - FV_BE_INT_PKG
PACKAGE BODY - FV_BE_PKG4
PACKAGE BODY - FV_GOALS_224
VIEW - FV_INV_STATCUST_V
VIEW - FV_INV_STATUSES_V
VIEW - FV_PYA_GL_V
VIEW - FV_SF224_BUSINESS_ACTIVITY_V
VIEW - FV_SF224_GWA_REPORT_CATEGORY_V
PACKAGE BODY - FV_WF_BE_APPROVAL

[top of page]

View: FV_LOOKUP_TYPES

[top of page]

APPS.FV_LOOKUP_TYPES references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_TYPES_VL

APPS.FV_LOOKUP_TYPES is not referenced by any database object

[top of page]

View: FV_PAYABLE_REFUNDS_V

[top of page]

APPS.FV_PAYABLE_REFUNDS_V references the following:

APPS
SYNONYM - AP_CHECKS_ALL
SYNONYM - AP_INVOICES_ALL
SYNONYM - AP_INVOICE_DISTRIBUTIONS_ALL
SYNONYM - AP_INVOICE_PAYMENTS_ALL
SYNONYM - GL_IMPORT_REFERENCES
SYNONYM - GL_JE_HEADERS
SYNONYM - GL_JE_LINES
VIEW - PO_VENDORS
SYNONYM - XLA_AE_LINES
SYNONYM - XLA_DISTRIBUTION_LINKS

APPS.FV_PAYABLE_REFUNDS_V is not referenced by any database object

[top of page]

View: FV_PAYMENT_MASTER_V

[top of page]

APPS.FV_PAYMENT_MASTER_V references the following:

APPS
SYNONYM - AP_CHECKS

APPS.FV_PAYMENT_MASTER_V is not referenced by any database object

[top of page]

View: FV_PO_MASTER_V

[top of page]

APPS.FV_PO_MASTER_V references the following:

APPS
SYNONYM - PO_HEADERS
PACKAGE - PO_HEADERS_SV3
SYNONYM - PO_LINES
SYNONYM - PO_LINE_LOCATIONS
SYNONYM - PO_RELEASES

APPS.FV_PO_MASTER_V is not referenced by any database object

[top of page]

View: FV_PYA_GL_V

[top of page]

APPS.FV_PYA_GL_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FV_FUND_PARAMETERS
VIEW - FV_LOOKUP_CODES
SYNONYM - FV_PYA_TRANSACTION_HISTORY
SYNONYM - FV_TREASURY_SYMBOLS
SYNONYM - GL_JE_BATCHES
SYNONYM - GL_JE_HEADERS
SYNONYM - GL_JE_LINES
APPS.FV_PYA_GL_V is referenced by following:

APPS
VIEW - XLA_FV_PYA_GL_V

[top of page]

View: FV_RECEIPT_MASTER_V

[top of page]

APPS.FV_RECEIPT_MASTER_V references the following:

APPS
SYNONYM - PO_HEADERS
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_TRANSACTIONS
APPS.FV_RECEIPT_MASTER_V is referenced by following:

APPS
PACKAGE BODY - FV_CROSS_DOC_REF

[top of page]

View: FV_REQUISITION_MASTER_V

[top of page]

APPS.FV_REQUISITION_MASTER_V references the following:

APPS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_REQUISITION_HEADERS
SYNONYM - PO_REQUISITION_LINES_ALL

APPS.FV_REQUISITION_MASTER_V is not referenced by any database object

[top of page]

View: FV_SYSTEM_PARAMETERS_V

[top of page]

APPS.FV_SYSTEM_PARAMETERS_V references the following:

APPS
SYNONYM - FV_OPERATING_UNITS
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
VIEW - XLE_FIRSTPARTY_INFORMATION_V
APPS.FV_SYSTEM_PARAMETERS_V is referenced by following:

APPS
PACKAGE BODY - FV_SF224_TRANSACTIONS
PACKAGE BODY - IBY_PAYMENT_FORMAT_VAL_PVT

[top of page]

View: FV_TBAL_BY_TS_V

[top of page]

APPS.FV_TBAL_BY_TS_V references the following:

APPS
SYNONYM - FND_FLEX_VALUES
SYNONYM - FND_FLEX_VALUES_TL
SYNONYM - FND_ID_FLEX_SEGMENTS
PACKAGE - FND_PROFILE
SYNONYM - FND_SEGMENT_ATTRIBUTE_VALUES
SYNONYM - FV_FACTS_TEMP
SYNONYM - FV_TREASURY_SYMBOLS
TABLE - GL_ACCESS_SET_LEDGERS
SYNONYM - GL_LEDGERS

APPS.FV_TBAL_BY_TS_V is not referenced by any database object

[top of page]

View: FV_TC_GL_V

[top of page]

APPS.FV_TC_GL_V references the following:

APPS
SYNONYM - AP_CHECKS_ALL
SYNONYM - FV_TREASURY_CONFIRMATIONS_ALL
SYNONYM - GL_JE_HEADERS
SYNONYM - GL_JE_LINES
APPS.FV_TC_GL_V is referenced by following:

APPS
VIEW - XLA_FV_TC_GL_V

[top of page]

View: FV_TPP_ASSIGNMENTS_V

[top of page]

APPS.FV_TPP_ASSIGNMENTS_V references the following:

APPS
SYNONYM - AP_SUPPLIERS
SYNONYM - AP_SUPPLIER_SITES_ALL
PACKAGE - FND_PROFILE
PACKAGE - FV_CCR_GRP
PACKAGE - FV_INSTALL
SYNONYM - FV_TPP_ASSIGNMENTS_ALL
SYNONYM - IBY_EXTERNAL_PAYEES_ALL
APPS.FV_TPP_ASSIGNMENTS_V is referenced by following:

APPS
PACKAGE BODY - AP_AUTOSELECT_PKG
VIEW - AP_DOCUMENTS_PAYABLE

[top of page]

View: FV_TREAS_CONFIRM_CHECKS_V

[top of page]

APPS.FV_TREAS_CONFIRM_CHECKS_V references the following:

APPS
SYNONYM - AP_CHECKS_ALL
SYNONYM - IBY_PAYMENTS_ALL
APPS.FV_TREAS_CONFIRM_CHECKS_V is referenced by following:

APPS
VIEW - FV_TREASURY_EXTRACT_DETAILS_V

[top of page]

View: FV_XLA_AP_REF_V

[top of page]

APPS.FV_XLA_AP_REF_V references the following:

APPS
TABLE - FV_EXTRACT_DETAIL_GT
APPS.FV_XLA_AP_REF_V is referenced by following:

APPS
PACKAGE BODY - XLA_00200_AAD_S_000012_BC_PKG
PACKAGE BODY - XLA_00200_AAD_S_000012_PKG

[top of page]

View: FV_XLA_AR_REF_V

[top of page]

APPS.FV_XLA_AR_REF_V references the following:

APPS
TABLE - FV_EXTRACT_DETAIL_GT
APPS.FV_XLA_AR_REF_V is referenced by following:

APPS
PACKAGE BODY - XLA_00222_AAD_S_000005_PKG
PACKAGE BODY - XLA_00222_AAD_S_000006_PKG
PACKAGE BODY - XLA_00222_AAD_S_000009_PKG

[top of page]

View: FV_XLA_CST_REF_V

[top of page]

APPS.FV_XLA_CST_REF_V references the following:

APPS
TABLE - FV_EXTRACT_DETAIL_GT
APPS.FV_XLA_CST_REF_V is referenced by following:

APPS
PACKAGE BODY - XLA_00707_AAD_S_000007_BC_PKG

[top of page]

View: FV_XLA_PO_REF_V

[top of page]

APPS.FV_XLA_PO_REF_V references the following:

APPS
TABLE - FV_EXTRACT_DETAIL_GT
APPS.FV_XLA_PO_REF_V is referenced by following:

APPS
PACKAGE BODY - XLA_00201_AAD_S_000004_BC_PKG

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract