Results for “tax_lines_create_vbr”

6 results




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

Overview

TAX_LINES_CREATE_VBR is a database view belonging to the JL (Latin America Localizations) product family in Oracle E-Business Suite. Its name indicates its function: it supplies the row-by-row structure required by the tax engine to create tax lines for a Value-Based Reporting (VBR) transaction stream. In EBS releases 12.1.1 and 12.2.2 the view acts as an intermediate projection layer, presenting Accounts Receivable transaction data — header, line, currency, and tax code attributes — in the fixed column layout expected by the tax line creation program (the EBTax/VBR interface). It is a read-only, query-only object: no DML is performed against it, and the ETRM record states it is "Not implemented in this database," meaning the view may not be deployed or compiled in every environment or patch level. Where present, it serves reporting and integration consumers that need a single flattened source of AR invoice lines flagged for tax determination.

Underlying Base Objects

The documented ETRM metadata lists no explicitly named base tables under "Referenced base objects." The view text, however, reveals the join structure through its aliases: H denotes the AR transaction header (RA_CUSTOMER_TRX_ALL), L the transaction line (RA_CUSTOMER_TRX_LINES_ALL), R a transactional reference used for NVL(R.TRX_DATE, H.TRX_DATE), D a GL date source, V the tax code/type lookup, C the currency definition (FND_CURRENCIES), and T the transaction type (RA_CUST_TRX_TYPES_ALL) used to distinguish credit memos. Because these cannot be verified from the metadata alone, they should be confirmed against the deployed view definition for the specific 12.1.1 or 12.2.2 instance. All columns are drawn through these joins without aggregation, so the view is a one-row-per-invoice-line projection.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling the tax line creation stream, auditing the tax base for Latin American localized transactions, and populating custom reports or extracts before tax is calculated.

  • Listing candidate tax lines for a given invoice:
    SELECT TRX_HEADER_ID, TRX_LINE_ID, TAX_CODE, EXTENDED_AMOUNT, TAXED_QUANTITY
    FROM TAX_LINES_CREATE_VBR WHERE TRX_HEADER_ID = :header_id;
  • Reviewing exemption usage by line:
    SELECT TRX_LINE_ID, TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE
    FROM TAX_LINES_CREATE_VBR WHERE TAX_EXEMPT_FLAG = 'Y';
  • Summarizing tax base by currency and ledger:
    SELECT SET_OF_BOOKS_ID, CURRENCY_CODE, SUM(EXTENDED_AMOUNT)
    FROM TAX_LINES_CREATE_VBR GROUP BY SET_OF_BOOKS_ID, CURRENCY_CODE;

Before relying on this view, confirm it exists and is valid in the target environment, since the ETRM entry records it as not implemented in the source database.