Results for “branch_end_date”

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

Overview

The CE_INTERNAL_BANK_ACCTS_GT_V view is a Cash Management (CE) reporting object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a global temporary (GT) view that consolidates internal bank account master data with their associated bank branch attributes and a classification lookup value. The view exposes a convenience column BANK_ACCOUNT_NUM_NAME, which concatenates the bank account number and the bank account name into a single, human-readable string. This is directly relevant to the search term bank_account_num_name, as the view is the documented source for that derived column in Oracle EBS metadata (ETRM 12.2.2).

Because it filters to internal accounts only (via the ACCOUNT_CLASSIFICATION / INTERNAL lookup), the view presents the subset of bank accounts used by the enterprise for its own disbursements, receipts and reconciliation, rather than external customer or supplier accounts. Its primary role is to support reporting, list-of-values, and integration queries that require a display-ready bank account identifier along with bank, branch, currency and account status.

Underlying Base Objects

The view is defined over three referenced base objects, all views in the same 12.2.2 metadata:

• CE_BANK_ACCTS_GT_V — the primary source, aliased BA. Supplies the bank account attributes: BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM, CURRENCY_CODE, MULTI_CURRENCY_ALLOWED_FLAG, ASSET_CODE_COMBINATION_ID, BANK_BRANCH_ID, END_DATE and CHECK_DIGITS.
• CE_BANK_BRANCHES_V — aliased BB. Joined on BA.BANK_BRANCH_ID = BB.BRANCH_PARTY_ID, supplying BANK_NAME, BANK_BRANCH_NAME and END_DATE (branch end date).
• CE_LOOKUPS — aliased CL. Filtered to LOOKUP_TYPE = 'ACCOUNT_CLASSIFICATION' and LOOKUP_CODE = 'INTERNAL', supplying the meaning used for account classification and ensuring only internal accounts are returned.

Key Columns

• BANK_ACCOUNT_ID — unique identifier for the internal bank account; the primary key for joins to payments, receipts and reconciliation data.
• BANK_ACCOUNT_NUM / BANK_ACCOUNT_NAME — the numeric account number and its descriptive name.
• BANK_ACCOUNT_NUM_NAME — the concatenation BANK_ACCOUNT_NUM || ', ' || BANK_ACCOUNT_NAME, the derived display value referenced by the term bank_account_num_name.
• CURRENCY_CODE / MULTI_CURRENCY_FLAG — the account currency and whether multiple currencies are permitted.
• BANK_NAME, BANK_BRANCH_NAME, BANK_BRANCH_ID — bank and branch identification.
• ASSET_CODE_COMBINATION_ID — the cash account accounting flexfield combination.
• INACTIVE_DATE (represented in view text as the account END_DATE), BRANCH_END_DATE and CHECK_DIGITS — status and control attributes.
• ACCOUNT_TYPE — the lookup meaning for the internal account classification.

Common Use Cases and Queries

Typical scenarios include bank account list-of-values, payment/receipt reporting by bank account, and data extracts for treasury reconciliation. The derived BANK_ACCOUNT_NUM_NAME column is frequently selected to present accounts in a compact, readable format.

Sample query listing active internal bank accounts:

• SELECT bank_account_id, bank_account_num_name, bank_name, bank_branch_name, currency_code
• FROM ce_internal_bank_accts_gt_v
• WHERE (inactive_date IS NULL OR inactive_date > SYSDATE)
• ORDER BY bank_account_num_name;

Because the referenced objects are global temporary views, the view should be used within a session that has populated the underlying temporary data. Queries joining BANK_ACCOUNT_ID to payment or reconciliation tables provide the standard linkage between this display view and transactional Cash Management data.