Results for “trx_line_type_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FV_BE_GL_V is an APPS-owned database view within the Federal Financials (FV) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It provides a consolidated reporting and integration surface that joins Budget Execution (BE) transaction detail and header information to the General Ledger journal entries those transactions generate. The "GL" in the name reflects its core purpose: exposing the accounting impact of budgetary transactions alongside the descriptive attributes of the originating chargeback or receipt transaction.
The view is particularly relevant to users searching for the accounting_complete attribute. In FV_BE_GL_V, this column is derived via SUBSTR(FTS.TREASURY_SYMBOL, 1, 30), meaning the value surfaced as ACCOUNTING_COMPLETE is drawn from the treasury symbol associated with the transaction header rather than from a dedicated completion flag. This aliasing is significant for reporting: consumers referencing ACCOUNTING_COMPLETE are in effect reading the treasury symbol, truncated to thirty characters.
Because the view links budgetary execution data to GL_JE_LINES and GL_JE_HEADERS, it supports reconciliation between budget execution activity and posted journal activity, and it carries an explicit APPLICATION_ID constant of 8901 to identify the owning application context.
Underlying Base Objects
FV_BE_GL_V is defined over seven referenced base objects, all exposed through APPS synonyms:
- FV_BE_TRX_DTLS — budgetary transaction detail lines (FBD), supplying transaction identifiers, source, revision, and increase/decrease flag.
- FV_BE_TRX_HDRS — budgetary transaction headers (FBH), supplying document number, transaction date, treasury symbol reference, and document ID.
- FV_BE_TRANSACTION_TYPES — transaction type definitions (FBTT), supplying the appropriation transaction type name.
- FV_BUDGET_LEVELS — budget level definitions (FBL), supplying the applied-to transaction header currency description.
- FV_TREASURY_SYMBOLS — treasury symbol master (FTS), the source of the ACCOUNTING_COMPLETE value.
- GL_JE_LINES — journal entry lines (JEL), supplying accounted and entered debit/credit amounts.
- GL_JE_HEADERS — journal entry headers (JEH), supplying currency code and the header-to-line join.
Joins are keyed on DOC_ID, BUDGET_LEVEL_ID, SET_OF_BOOKS_ID, TRANSACTION_TYPE_ID, and TREASURY_SYMBOL_ID, while the GL linkage uses TO_CHAR(FBD.TRANSACTION_ID) = JEL.REFERENCE_1 combined with JEH.JE_SOURCE = 'BUDGETARY TRANSACTION' and matching ledger and header identifiers.
Key Columns
- ACCOUNTING_COMPLETE — derived from the treasury symbol (first 30 characters); central to completion-oriented reporting.
- CHARGEBACK_NUMBER — the document number from the transaction header.
- TRX_DATE — the header transaction date.
- ACCOUNTED_DR / ACCOUNTED_CR — accounted debit and credit amounts from GL journal lines.
- ENTERED_DR / ENTERED_CR — entered debit and credit amounts from GL journal lines.
- TRX_LINE_TYPE_NAME — appropriation transaction type name.
- SET_OF_BOOKS_ID, JE_HEADER_ID, JE_LINE_NUM, CODE_COMBINATION_ID — GL accounting identifiers.
- CURRENCY_CODE — journal currency from GL_JE_HEADERS.
- APPLICATION_ID — constant 8901 identifying the application context.
Common Use Cases and Queries
Typical uses include reconciling budgetary transactions to their GL postings, auditing accounting completion by treasury symbol, and extracting debit/credit balances by set of books. A representative query:
SELECT chargeback_number, trx_date, accounting_complete, accounted_dr, accounted_cre FROM fv_be_gl_v WHERE set_of_books_id = :ledger_id AND trx_date BETWEEN :start_date AND :end_date;- Filtering on
accounting_completeto group activity by treasury symbol. - Summing
accounted_drandaccounted_cragainstje_header_idto verify journal balance.
-
View: FV_BE_GL_V 12.1.1
APPS.FV_BE_GL_V·↳ FV_BE_TRANSACTION_TYPES·↳ FV_BE_TRX_DTLS·↳ FV_BE_TRX_HDRS·Explore FV module →
-
View: FV_BE_GL_V 12.2.2
APPS.FV_BE_GL_V·↳ FV_BE_TRANSACTION_TYPES·↳ FV_BE_TRX_DTLS·↳ FV_BE_TRX_HDRS·Explore FV module →
-
View: LNS_AEL_GL_V 12.1.1
This view contains accounting GL info about loans invoices
APPS.LNS_AEL_GL_V·↳ GL_IMPORT_REFERENCES·↳ GL_JE_HEADERS·↳ GL_JE_LINES·Explore LNS module →
-
View: LNS_AEL_GL_V 12.2.2
This view contains accounting GL info about loans invoices
APPS.LNS_AEL_GL_V·↳ GL_IMPORT_REFERENCES·↳ GL_JE_HEADERS·↳ GL_JE_LINES·Explore LNS module →
-
View: PN_AEL_BILL_GL_V 12.2.2
APPS.PN_AEL_BILL_GL_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ GL_DAILY_CONVERSION_TYPES·Explore PN module →
-
View: AP_ENC_GL_INV_V 12.2.2
APPS.AP_ENC_GL_INV_V·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_LOOKUP_CODES·Explore FND module →
-
View: XLA_AR_REC_AEL_GL_V 12.2.2
APPS.XLA_AR_REC_AEL_GL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_GL_REC_ALL_V·↳ FND_ACCESS_CONTROL_UTIL·Explore XLA module →
-
View: PN_AEL_BILL_GL_V 12.1.1
APPS.PN_AEL_BILL_GL_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ GL_DAILY_CONVERSION_TYPES·Explore PN module →
-
View: LNS_SL_GL_V2 12.1.1
This view is for internal use only.
APPS.LNS_SL_GL_V2·↳ FND_FLEX_EXT·↳ GL_CODE_COMBINATIONS·↳ GL_IMPORT_REFERENCES·Explore LNS module →
-
View: LNS_SL_GL_V2 12.2.2
This view is for internal use only.
APPS.LNS_SL_GL_V2·↳ FND_FLEX_EXT·↳ GL_CODE_COMBINATIONS·↳ GL_IMPORT_REFERENCES·Explore LNS module →
-
View: XLA_AR_INV_AEL_SL_V 12.2.2
APPS.XLA_AR_INV_AEL_SL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_SL_INV_V·Explore XLA module →
-
View: XLA_AP_ENC_GL_PAY_V 12.2.2
APPS.XLA_AP_ENC_GL_PAY_V·↳ AP_ENC_GL_PAY_V·↳ FND_ACCESS_CONTROL_UTIL·↳ FND_GLOBAL·Explore FND module →
-
View: XLA_AR_INV_AEL_GL_V 12.1.1
APPS.XLA_AR_INV_AEL_GL_V·↳ AR_AEL_GL_INV_V·Explore XLA module →
-
View: AP_ENC_GL_INV_V 12.2.2
APPS.AP_ENC_GL_INV_V·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_LOOKUP_CODES·Explore AP module →
-
View: XLA_OKL_AEL_GL_CTR_V 12.1.1
APPS.XLA_OKL_AEL_GL_CTR_V·↳ ARP_ADDR_LABEL_PKG·↳ FND_GLOBAL·↳ OKC_UTIL·Explore XLA module →
-
View: XLA_OKL_AEL_GL_AST_V 12.2.2
APPS.XLA_OKL_AEL_GL_AST_V·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AEL_GL_AST_V·Explore XLA module →
-
View: XLA_FV_BE_GL_V 12.2.2
-
View: XLA_OKL_AEL_GL_CTR_V 12.2.2
APPS.XLA_OKL_AEL_GL_CTR_V·↳ ARP_ADDR_LABEL_PKG·↳ OKC_UTIL·↳ OKL_ACCOUNTING_UTIL·Explore XLA module →
-
View: XLA_FV_BE_GL_V 12.1.1
-
View: AP_ENC_GL_INV_V 12.1.1
APPS.AP_ENC_GL_INV_V·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_LOOKUP_CODES·Explore AP module →
-
View: XLA_PA_EI_AEL_GL_V 12.1.1
APPS.XLA_PA_EI_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_DR_AEL_SL_V 12.2.2
APPS.XLA_PA_DR_AEL_SL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_EI_AEL_SL_MRC_V 12.2.2
APPS.XLA_PA_EI_AEL_SL_MRC_V·↳ MO_GLOBAL·↳ PA_AEL_SL_EI_MRC_V·↳ PA_SECURITY·Explore XLA module →
-
View: XLA_PA_DR_AEL_GL_V 12.2.2
APPS.XLA_PA_DR_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_EI_AEL_GL_V 12.2.2
APPS.XLA_PA_EI_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_DR_AEL_GL_V 12.1.1
APPS.XLA_PA_DR_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_WIP_AEL_SL_PAC_V 12.1.1
APPS.XLA_WIP_AEL_SL_PAC_V·↳ CST_PAC_AEL_SL_WIP_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_AR_ADJ_AEL_GL_V 12.1.1
APPS.XLA_AR_ADJ_AEL_GL_V·↳ AR_AEL_GL_ADJ_V·Explore XLA module →
-
View: XLA_FA_AEL_GL_V 12.2.2
-
APPS.XLA_PSA_REQ_ENC_BC_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_OKL_AEL_GL_TRX_V 12.2.2
APPS.XLA_OKL_AEL_GL_TRX_V·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AEL_GL_TRX_V·Explore XLA module →
-
APPS.JAI_PO_OSP_DISP_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSP_DISP_AEL_V·Explore JA module →
-
View: JAI_AP_STDIST_AEL_SL_V 12.2.2
APPS.JAI_AP_STDIST_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_AP_STDIST_AEL_V·Explore JA module →
-
APPS.JAI_PO_REC_MTL_AEL_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ JAI_PO_REC_MTL_AEL_V·Explore JA module →
-
View: JAI_PO_OSPM_AEL_GL_V 12.2.2
APPS.JAI_PO_OSPM_AEL_GL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSPM_AEL_V·Explore JA module →
-
View: JAI_AP_MANUAL_AEL_GL_V 12.2.2
APPS.JAI_AP_MANUAL_AEL_GL_V·↳ FND_GLOBAL·↳ JAI_AP_MANUAL_AEL_V·Explore JA module →
-
View: JAI_INV_RG23_AEL_GL_V 12.2.2
APPS.JAI_INV_RG23_AEL_GL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_INV_RG23_AEL_V·Explore JA module →
-
View: XLA_FV_PYA_GL_V 12.2.2
APPS.XLA_FV_PYA_GL_V·↳ FND_GLOBAL·↳ FV_PYA_GL_V·Explore XLA module →
-
APPS.JAI_PO_REC_CENVAT_AEL_SL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ JAI_PO_REC_CENVAT_AEL_V·Explore JA module →
-
View: XLA_FV_TC_GL_V 12.1.1
-
View: XLA_REQ_ENC_AEL_GL_V 12.1.1
APPS.XLA_REQ_ENC_AEL_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_FV_PYA_GL_V 12.1.1
APPS.XLA_FV_PYA_GL_V·↳ FND_GLOBAL·↳ FV_PYA_GL_V·Explore XLA module →
-
View: AR_AEL_GL_REC_ALL_V 12.2.2
APPS.AR_AEL_GL_REC_ALL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_GL_CB_REC_V·↳ AR_AEL_GL_REC_V·Explore AR module →
-
View: AR_AEL_GL_REC_ALL_V 12.1.1
APPS.AR_AEL_GL_REC_ALL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_GL_CB_REC_V·↳ AR_AEL_GL_REC_V·Explore AR module →
-
View: AR_AEL_SL_INV_V 12.1.1
APPS.AR_AEL_SL_INV_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_DISTRIBUTIONS_ALL·↳ AR_LOOKUPS·Explore AR module →
-
View: AR_AEL_SL_INV_V 12.2.2
APPS.AR_AEL_SL_INV_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_DISTRIBUTIONS_ALL·↳ AR_LOOKUPS·Explore AR module →
-
View: AR_AEL_SL_INV_MRC_V 12.1.1
APPS.AR_AEL_SL_INV_MRC_V·↳ AR_DISTRIBUTIONS_ALL_MRC_V·↳ AR_LOOKUPS·↳ AR_RECEIVABLE_APPS_ALL_MRC_V·Explore AR module →
-
View: OKL_AEL_GL_CTR_V 12.2.2
This view contains all the contract related transactions which have been transferred to GL. This view is used to enable OKL GL Drilldown functionality. This view displays the Lease transactions which fall under Booking, Rebook, Renewal, Rel
APPS.OKL_AEL_GL_CTR_V·↳ ARP_ADDR_LABEL_PKG·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore OKL module →
-
View: XLA_AR_REC_AEL_GL_V 12.1.1
APPS.XLA_AR_REC_AEL_GL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_GL_REC_ALL_V·↳ FND_ACCESS_CONTROL_UTIL·Explore XLA module →
-
View: PN_AEL_PAY_GL_V 12.1.1
APPS.PN_AEL_PAY_GL_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ GL_DAILY_CONVERSION_TYPES·Explore PN module →