Search Results ctrl_total_line_tx_amt

Overview

The ZX_DETAIL_TAX_LINES_QUOTE_V view is an APPS-owned database object within the Oracle E-Business Suite E‑Tax (E‑Business Tax / ETRM) schema, catalogued under the FND – Application Object Library product. It presents detailed, denormalized tax line information originating from the tax determination and calculation engine, with particular relevance to quoting and order-capture flows. The view consolidates tax line attributes such as regime, tax, status, rate, taxable base, and tax amounts together with transaction context, party/establishment details, currency conversion attributes, and document reference information.

Users frequently reach this object when investigating the tax_applicability_result_id search term, which relates to the internal identifier returned by the tax applicability (determination) process. Although the view text excerpt does not explicitly list that column name among the projected attributes, the detailed tax-line projection of the view — including TAX_REGIME_ID, TAX_ID, TAX_STATUS_ID, TAX_RATE_ID — is the natural target for tracing the outcome of an applicability result. The view is intended for reporting, integration, and troubleshooting of tax documentation lines rather than for transactional insert/update operations.

Underlying Base Objects

The documented base objects referenced by this view are:

• ZX_DETAIL_TAX_LINES_GT (SYNONYM) — a global temporary table that holds detailed tax line rows during tax engine processing.
• ZX_LINES (SYNONYM) — the central ETRM table storing calculated tax lines for transactions.
• ZX_LINES_DET_FACTORS (SYNONYM) — the detailed tax determination factor table that records the inputs and factors used when the tax engine determined applicability and rates.

The view therefore sits above the core tax line storage (ZX_LINES) and the supporting determination factor data (ZX_LINES_DET_FACTORS), and overlays the temporary/detail collection (ZX_DETAIL_TAX_LINES_GT) that carries line-level detail during processing. This architecture allows the view to return a fully enriched picture of how a given tax line was derived and priced. The synonym chain resolves to the APPS schema objects in both EBS 12.1.1 and 12.2.2.

Key Columns

• TAX_LINE_ID / TRX_ID / TRX_LINE_ID — primary keys linking the tax line to its transaction and transaction line.
• TAX_REGIME_ID, TAX_REGIME_CODE, TAX_ID, TAX — the tax regime and tax being applied.
• TAX_STATUS_ID, TAX_STATUS_CODE — the tax status result, a common trace point for applicability outcomes.
• TAX_RATE_ID, TAX_RATE_CODE, TAX_RATE — the rate and rate identifier used in the calculation.
• TAX_EVENT_CLASS_CODE, TAX_EVENT_TYPE_CODE, DOC_EVENT_STATUS — the tax events driving determination.
• LEDGER_ID, LEGAL_ENTITY_ID, ESTABLISHMENT_ID — accounting and legal context, with related tax registration numbers.
• TRX_CURRENCY_CODE, CURRENCY_CONVERSION_RATE/TYPE/DATE and the TAX_CURRENCY equivalents — currency and conversion context.
• UNROUNDED_TAXABLE_AMT, UNROUNDED_TAX_AMT, LINE_AMT, UNIT_PRICE — amounts before rounding and at line level.
• RELATED_DOC_*, REF_DOC_*, APPLIED_FROM_*, ADJUSTED_DOC_* — document references supporting cross-document tax adjustment and offsetting.

Common Use Cases and Queries

The view is typically used to reconcile tax lines generated for transactions, to inspect which regime/tax/status/rate combination was applied, and to support tax reporting and downstream integration. A representative query joining determination results is shown below.

A typical select retrieves tax line details for a transaction:

• Query: SELECT tax_line_id, trx_id, trx_line_id, tax_regime_code, tax, tax_status_code, tax_rate_code, tax_rate, unrounded_tax_amt FROM zx_detail_tax_lines_quote_v WHERE trx_id = :trx_id;
• Applicability tracing: join to ZX_LINES_DET_FACTORS on tax_line_id to correlate the applicable status and rate with the recorded determination factors.
• Currency review: filter on TAX_CURRENCY_CODE or CURRENCY_CONVERSION_TYPE to validate exchange treatment.

Because the view is read-only and assembled from the core ETRM tax line and factor objects, it is safe for ad hoc SQL, concurrent reporting, and integration extraction in both 12.1.1 and 12.2.2 environments.