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
- SHIP_TO_CUSTOMER_ID / BILL_TO_CUSTOMER_ID — customer identifiers for the ship-to and bill-to parties on the transaction header.
- TRX_HEADER_ID / TRX_LINE_ID — the AR customer transaction header and line identifiers, the primary linkage keys back to receivables.
- TRX_CHARGE_LINE_ID / TRX_LINK_TO_CUST_TRX_LINE_ID — returned as
TO_NUMBER(NULL), reserved placeholders in the target interface structure. - TRX_DATE / GL_DATE — transaction date (falling back to the header date via NVL) and the general ledger accounting date.
- TAX_CODE — the tax code from the tax lookup; TAX_RATE and TAX_AMOUNT are returned as NULL, indicating the tax engine computes them downstream.
- EXTENDED_AMOUNT —
NVL(GROSS_EXTENDED_AMOUNT, EXTENDED_AMOUNT), the tax base amount. - TAXED_QUANTITY — QUANTITY_CREDITED for credit memos, otherwise QUANTITY_INVOICED.
- EXCHANGE_RATE, SET_OF_BOOKS_ID, CURRENCY_CODE — currency conversion and ledger context, with MINIMUM_ACCOUNTABLE_UNIT and PRECISION from the currency definition.
- TAX_EXEMPT_FLAG / TAX_EXEMPT_NUMBER / TAX_EXEMPT_REASON_CODE — exemption data carried from the line.
- LOCATION_QUALIFIER — hard-coded 'ALL'; TAXABLE_FLAG — hard-coded 'Y'.
- ATTRIBUTE1–ATTRIBUTE5 — mapped from header and line global attributes, with ATTRIBUTE4 fixed to 'AR'.
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.
-
View: TAX_LINES_CREATE_VBR 12.1.1
N/A
Not implemented in this database·Explore JL module →
-
View: TAX_LINES_CREATE_VBR 12.2.2
N/A
Not implemented in this database·Explore JL module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
PACKAGE BODY: APPS.JL_ZZ_TAX 12.1.1
-
PACKAGE BODY: APPS.JL_ZZ_TAX 12.2.2