Search Results order_ext_id




Overview
Explore in AI Chat

Overview

APPS.ARBR_DOCS_RECEIVABLES_V is a multi-org view in the Oracle E-Business Suite Receivables (AR) module, registered under FND Design Data AR.ARBR_DOCS_RECEIVABLES_V. It presents a consolidated, external-facing projection of receivables-related "documents" — combining transaction header data, settlement information, and payment instrument extension attributes. The view is documented as a multi-org view, meaning it automatically restricts returned rows to the operating unit (ORG_ID) of the current session, ignoring data belonging to other operating units. Its name and BR-prefixed columns (BR_DRAWEE_ISSUED_FLAG, BR_SIGNED_FLAG) indicate the view was originally introduced to support Brazil localization receivables documentation, where fiscal documents, drawee issuance, and signed-document status are tracked alongside standard AR transactions.

The view carries the ETRM status VALID in both 12.1.1 and 12.2.2 and exposes a broad, denormalized column set spanning document headers, tax amounts, freight and duty charges, address references, collector assignment, and fifteen descriptive flexfield (DFF) attribute columns.

Underlying Base Objects

The documented base objects for this view are:

The presence of IBY (Payments) objects explains the settlement-oriented columns such as SETTLEMENT_AMOUNT, DISCOUNT_AMOUNT, and PAYMENT_TRXN_EXTENSION_ID, which tie the receivables document to its associated payment transaction extension.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling receivables documents to external orders, extracting fiscal document and tax detail for Brazil localization reporting, and joining receivables documents to payment transaction extensions. Because the view is a multi-org view, queries should be run from an environment where the FND_GLOBAL ORG_ID is set to the intended operating unit; no ORG_ID predicate needs to be added explicitly.

To locate receivables documents by external order identifier:

  • SELECT ORDER_EXT_ID, DOC_UNIQUE_REF, DOCUMENT_DATE, DOCUMENT_TYPE, DOCUMENT_CURRENCY_CODE, DOCUMENT_AMOUNT FROM APPS.ARBR_DOCS_RECEIVABLES_V WHERE ORDER_EXT_ID = :p_order_ext_id;

To review tax and settlement components for a document reference:

  • SELECT DOC_UNIQUE_REF, VAT_REF_NUMBER, LOCAL_TAX_AMOUNT, NATIONAL_TAX_AMOUNT, VAT_TAX_AMOUNT, SETTLEMENT_AMOUNT, DISCOUNT_AMOUNT FROM APPS.ARBR_DOCS_RECEIVABLES_V WHERE CALLING_APP_DOC_REF_NUMBER = :p_ref_number;

To trace a document to its payment transaction extension and legal entity:

  • SELECT DOC_UNIQUE_REF, PAYMENT_TRXN_EXTENSION_ID, LEGAL_ENTITY_ID, DOCUMENT_DISPUTED_FLAG, BR_SIGNED_FLAG FROM APPS.ARBR_DOCS_RECEIVABLES_V WHERE PAYMENT_TRXN_EXTENSION_ID IS NOT NULL;