Search Results note_receivable_issuer_name

Overview

ARBV_CASH_RECEIPTS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data AR.ARBV_CASH_RECEIPTS. Its status is VALID across Oracle EBS 12.1.1 and 12.2.2. The view presents information about receipts remitted by customers as payment for goods or services, exposing receipt header attributes in a denormalized, report-friendly form. Because it is a BIS view rather than a transactional table, it is intended primarily for operational reporting, ad hoc enquiry, and downstream integration where a stable, human-readable projection of the Accounts Receivable receipt header is required without joining the full normalized model. The leading "B" in the object prefix identifies it as a business intelligence view in the EBS naming convention, distinguishing it from the underlying transactional entity.

Underlying Base Objects

The documented view metadata for 12.2.2 records a single referenced base object: the synonym AR_CASH_RECEIPTS, which resolves to the AR.AR_CASH_RECEIPTS transactional table in the Accounts Receivable schema. AR_CASH_RECEIPTS is the master receipt header table in Oracle Receivables; it stores one row per cash receipt, including receipt number, amount, date, currency, exchange rate information, deposit details, remittance bank account, and reversal attributes. ARBV_CASH_RECEIPTS is therefore a direct projection over that header table, with no documented dependency on receipt application, distribution, or accounting line tables. This structure means the view returns header-level receipt information only; applied amounts, unapplied balances, and accounting entries must be obtained from their respective detail objects such as AR_RECEIVABLE_APPLICATIONS_ALL and AR_CASH_RECEIPT_HISTORY. The synonym inheritance ensures the view remains consistent with the base table's column definitions, including length and mandatory constraints as published in the ETRM metadata.

Key Columns

The view exposes core receipt identifiers and financial attributes:

CASH_RECEIPT_ID (NUMBER, 15) — primary identifier of the receipt header.
RECEIPT_NUMBER (VARCHAR2, 30) — the user-visible receipt number.
RECEIPT_AMOUNT and RECEIPT_DATE — the receipt value and the date it was entered or issued.
DOCUMENT_SEQUENCE_NUMBER — the sequence assigned to the receipt document.
CURRENCY_EXCHANGE_RATE, CURRENCY_EXCHANGE_RATE_TYPE, CURRENCY_EXCHANGE_RATE_DATE — foreign currency conversion attributes.
CURRENCY_CODE, ORG_ID, SET_OF_BOOKS_ID — the receipt currency, operating unit, and ledger context.
DEPOSIT_DATE, ANTICIPATED_CLEARING_DATE — treasury and cash management timing attributes.
_LA:RECEIPT_STATUS and RECEIPT_STATUS_CODE — the receipt status, the _LA prefix indicating a lookup-coded display column resolved through the applications lookup mechanism.
REVERSAL_DATE, REVERSAL_COMMENTS, _LA:REVERSAL_REASON, _LA:REVERSAL_CATEGORY — reversal tracking attributes.
CUSTOMER_RECEIPT_REFERENCE — the customer's own reference for the payment.
NOTE_RECEIVABLE_ISSUER_NAME and NOTE_RECEIVABLE_ISSUE_DATE — the issuer name and issue date for receipts settled by note receivable, which is the column the user searched for.
REMITTANCE_BANK_ACCOUNT_ID, CUSTOMER_BANK_ACCOUNT_ID, ISSUER_BANK_BRANCH_ID — banking relationships tied to the receipt.
LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — audit columns.

Common Use Cases and Queries

Typical applications include cash position reporting, note receivable maturity tracking, reversal analysis, and reconciliation feeds into general ledger or treasury systems. A standard enquiry retrieves note receivable receipts with their issue dates:

SELECT CASH_RECEIPT_ID, RECEIPT_NUMBER, RECEIPT_AMOUNT, RECEIPT_DATE, CURRENCY_CODE, NOTE_RECEIVABLE_ISSUER_NAME, NOTE_RECEIVABLE_ISSUE_DATE FROM APPS.ARBV_CASH_RECEIPTS WHERE NOTE_RECEIVABLE_ISSUE_DATE IS NOT NULL AND RECEIPT_STATUS_CODE = 'APP' ORDER BY NOTE_RECEIVABLE_ISSUE_DATE;

The view can also be used for reversal monitoring (filtering on REVERSAL_DATE) and for period cash summaries grouped by org_id, currency_code, and receipt_date. When more granular application, distribution, or accounting detail is needed, ARBV_CASH_RECEIPTS should be joined to the corresponding detail objects on CASH_RECEIPT_ID, since the view itself provides header-level information only.

VIEW: APPS.ARBV_CASH_RECEIPTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARBV_CASH_RECEIPTS, object_name:ARBV_CASH_RECEIPTS, status:VALID,
VIEW: APPS.ARBV_CASH_RECEIPTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARBV_CASH_RECEIPTS, object_name:ARBV_CASH_RECEIPTS, status:VALID,
VIEW: APPS.ARFV_CASH_RECEIPTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_CASH_RECEIPTS, object_name:ARFV_CASH_RECEIPTS, status:VALID,
VIEW: APPS.ARFV_CASH_RECEIPTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_CASH_RECEIPTS, object_name:ARFV_CASH_RECEIPTS, status:VALID,
View: ARBV_CASH_RECEIPTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARBV_CASH_RECEIPTS, object_name:ARBV_CASH_RECEIPTS, status:VALID, product: AR - Receivables , description: This shows information about receipts remitted by the customer as payment for goods or services. , implementation_dba_data: APPS.ARBV_CASH_RECEIPTS ,
View: ARBV_CASH_RECEIPTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARBV_CASH_RECEIPTS, object_name:ARBV_CASH_RECEIPTS, status:VALID, product: AR - Receivables , description: This shows information about receipts remitted by the customer as payment for goods or services. , implementation_dba_data: APPS.ARBV_CASH_RECEIPTS ,
View: ARFV_CASH_RECEIPTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_CASH_RECEIPTS, object_name:ARFV_CASH_RECEIPTS, status:VALID, product: AR - Receivables , description: This shows information about payments remitted by the customer as payment for goods or services. , implementation_dba_data: APPS.ARFV_CASH_RECEIPTS ,
View: ARFV_CASH_RECEIPTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_CASH_RECEIPTS, object_name:ARFV_CASH_RECEIPTS, status:VALID, product: AR - Receivables , description: This shows information about payments remitted by the customer as payment for goods or services. , implementation_dba_data: APPS.ARFV_CASH_RECEIPTS ,
eTRM - AR Tables and Views 12.1.1
description: Territory information ,
eTRM - AR Tables and Views 12.2.2
description: Territory information ,