Results for “gl_company_code”

36 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XTR_A_BANK_ACCOUNTS_V is an APPS-owned database view within the Oracle E-Business Suite Treasury (XTR) module. It presents a consolidated, query-ready projection of company bank account master data, combining bank, party, portfolio, settlement, and interest configuration attributes in a single relational structure. The view is commonly referenced by Treasury reporting, bank account inquiry forms, cash management dashboards, and downstream integrations requiring account-level attributes without joining the underlying bank and account tables directly.

Because the view carries a status of VALID in both Oracle EBS 12.1.1 and 12.2.2, it remains a stable interface point for custom reports, concurrent programs, and outbound interfaces. The user search term interest_calculation_basis maps directly to a column exposed by this view, making it a primary source for interest accrual, netting, and cash positioning calculations in Treasury.

Underlying Base Objects

The documented view text selects all columns from a single base object:

  • XTR_A_BANK_ACCOUNTS — the underlying Treasury bank account table (referenced in APPS via a synonym). No joins to external tables appear in the documented view definition.

In practice, XTR_A_BANK_ACCOUNTS stores account-level attributes such as account number, currency, GL code combination, party references, and interest configuration. Because the view performs a straight SELECT ... FROM XTR_A_BANK_ACCOUNTS without filtering or aggregation, it behaves as a wide projection layer over the base table, preserving row cardinality and column semantics. Any DML against the base table is immediately visible through the view.

Key Columns

Common Use Cases and Queries

Treasury analysts and developers use this view for bank account inquiry, interest configuration reporting, and cash positioning extracts. Typical queries filter on currency or portfolio and retrieve interest attributes for accrual validation.

  • Retrieving all accounts and their interest calculation basis:
    SELECT account_number, currency, interest_calculation_basis, interest_rate
    FROM   apps.xtr_a_bank_accounts_v
    WHERE  authorised = 'Y';
  • Identifying accounts by portfolio or company for cash positioning:
    SELECT account_number, bank_name, portfolio_code, projected_balance
    FROM   apps.xtr_a_bank_accounts_v
    WHERE  gl_company_code = :company
    AND    currency = :currency;
  • Auditing interest configuration changes:
    SELECT account_number, interest_calculation_basis, year_calc_type,
           updated_by, updated_on, audit_date_stored
    FROM   apps.xtr_a_bank_accounts_v
    WHERE  audit_indicator = 'Y';

Because the view is a thin projection, standard EBS extensibility approaches (custom BI Publisher reports, OAF-based inquiries, or integration extracts) can consume it directly, subject to the standard APPS schema privileges and Treasury security policies.