Search Results tax_exempt_flag

Overview

The OKL_EXT_SELL_INVS_V view is a reporting and integration object within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, available in both release 12.1.1 and 12.2.2. It is owned by the APPS schema and is documented as an "External Transactions Header for Billing records." The view exposes the header-level detail of externally sourced selling invoices that originate outside the standard Oracle Receivables invoicing flow and are later interfaced into the lease management billing process. Because external transactions may be generated by third-party systems, partner applications, or consolidation processes, this view provides a normalized, query-friendly projection of the underlying transaction header tables.

The view is defined as a join between the base transaction table OKL_EXT_SELL_INVS_B and its translation table OKL_EXT_SELL_INVS_TL, allowing descriptive and message attributes held in the language-specific table to be presented alongside the core transactional data. It is primarily consumed for reporting, reconciliation, and downstream integration, particularly where invoice headers, currency attributes, and Receivables linkage must be examined across an external selling arrangement.

Underlying Base Objects

The view is constructed over two documented base objects, both referenced as synonyms in the APPS schema:

• OKL_EXT_SELL_INVS_B — the base (B) table holding the transactional header columns, including identifiers, dates, currency details, and descriptive flexfield attributes.
• OKL_EXT_SELL_INVS_TL — the translation (TL) table holding language-dependent descriptive columns such as description, invoice message, and the external transaction formatting attributes.

The join is performed on the shared ID column, with the view also exposing the ROWID of the base table as ROW_ID. This structure follows the standard Oracle EBS pattern of separating language-independent and language-dependent content.

Key Columns

Significant columns exposed by the view include the following:

• ID / ROW_ID / OBJECT_VERSION_NUMBER — the primary identifier, physical row reference, and optimistic locking version of the transaction header.
• TRX_NUMBER, TRX_DATE, TRX_STATUS_CODE — the external transaction's number, date, and processing status.
• CUSTOMER_ID, CUSTOMER_ADDRESS_ID, CUSTOMER_BANK_ACCOUNT_ID — the billed customer, address, and the customer bank account associated with the transaction. The user search term "customer_bank_account_id" maps directly to this column, which identifies the customer bank account used for the external selling invoice, supporting direct debit and remittance processing.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE — currency and conversion details applicable to the transaction.
• RECEIVABLES_INVOICE_ID, CUST_TRX_TYPE_ID, SET_OF_BOOKS_ID, ORG_ID — linkage to Oracle Receivables and the accounting/operating context.
• RECEIPT_METHOD_ID, TERM_ID, REFERENCE_LINE_ID — payment method, payment terms, and reference line information.
• INVOICE_MESSAGE, DESCRIPTION, XTRX_FORMAT_TYPE, XTRX_PRIVATE_LABEL, XTRX_CONS_INVOICE_NUMBER — description and external transaction formatting attributes sourced from the TL table.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield columns available for extensibility.

Common Use Cases and Queries

Typical use cases include reconciliation of external selling invoices against Receivables, reporting on billing status by customer and currency, and integration extracts that require customer bank account data for payment processing.

A representative query to locate transactions by customer bank account is:

• SELECT trx_number, trx_date, customer_id, customer_bank_account_id, currency_code, receivables_invoice_id FROM okl_ext_sell_invs_v WHERE customer_bank_account_id = :p_bank_account_id;
• SELECT trx_number, trx_date, customer_id, trx_status_code FROM okl_ext_sell_invs_v WHERE org_id = :p_org_id AND trx_date BETWEEN :p_from AND :p_to;
• SELECT v.trx_number, v.currency_code, v.currency_conversion_rate, v.receivables_invoice_id FROM okl_ext_sell_invs_v v WHERE v.set_of_books_id = :p_sob AND v.trx_status_code = 'PROCESSED';

Because the view joins header and translation data, filters on language-dependent columns should account for the multilingual context of the TL table.