Results for “applied_to_trx_line_id”

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

Overview

ZX_TRANSACTION_LINES_V is an APPS-owned database view in Oracle E-Business Suite that exposes transaction line records used by the E-Business Tax (E-Business Tax / ZX) engine, commonly referred to as ETRM (E-Business Tax Repository Management). Although the view is registered under the FND – Application Object Library product grouping in the object metadata, its naming and column set place it squarely within the tax determination and tax line storage domain. The view presents one row per tax-relevant transaction line, enriched with descriptive attributes such as organization name, product classification, and party site references, so that reporting and integration consumers can query meaningful business data without joining the underlying normalized base tables directly.

The view is valid and available in both EBS 12.1.1 and 12.2.2. It serves as a read-oriented presentation layer over the ZX_TRANSACTION_LINES synonym, providing a stable and denormalized interface for downstream reports, extracts, and integrations that need transaction line detail for tax calculation, tax reporting, and reconciliation purposes.

Underlying Base Objects

The documented base objects referenced by ZX_TRANSACTION_LINES_V are:

• ZX_TRANSACTION_LINES (SYNONYM) — the primary source of transaction line data; the view selects its core columns from this object (aliased TRL in the view text).
• ORG_ORGANIZATION_DEFINITIONS (VIEW) — supplies the organization name exposed as PRODUCT_ORG_DESC, joined on the product organization identifier.
• ZX_PRODUCT_TYPES_V (VIEW) — supplies the product classification name used to derive PRODUCT_TYPE_DESC, except when the product type is 'MEMOS'.
• FND_GLOBAL (PACKAGE) — used for session context such as the current application and user environment.
• HR_GENERAL and HR_SECURITY (PACKAGES) — used for organization and security context resolution, ensuring only authorized organization data is exposed.

The view therefore acts as a consolidated access point, combining transactional tax line records with organizational and product descriptive metadata.

Key Columns

• TRX_LINE_ID / TRX_ID / TRX_LINE_NUMBER — identity and ordering keys for the transaction line and its parent transaction.
• APPLICATION_ID / ENTITY_CODE / EVENT_CLASS_CODE — contextual keys identifying the source application and transaction event class.
• TRX_LEVEL_TYPE / TRX_LINE_TYPE — classification of the line within the transaction hierarchy.
• LINE_AMT / TRX_LINE_QUANTITY / UNIT_PRICE — financial and quantity measures used in tax calculation.
• LINE_AMT_INCLUDES_TAX_FLAG — indicates whether the line amount already includes tax.
• PRODUCT_ID / PRODUCT_CODE / PRODUCT_CATEGORY / PRODUCT_TYPE_DESC — product identification and descriptive classification.
• PRODUCT_ORG_ID / PRODUCT_ORG_DESC — the inventory organization and its name.
• MERCHANT_PARTY_ID — the merchant party associated with the line.
• ACCOUNT_CCID / ACCOUNT_STRING — the accounting flexfield reference for the line.
• Party site columns (BILL_TO, BILL_FROM, SHIP_TO, SHIP_FROM) — party and site identifiers and related location IDs used for tax jurisdiction determination.
• TAX_REGIME_ID / TAX_REGIME_CODE / TAX_ID / TAX / TAX_STATUS_ID — tax regime, tax, and status references applied to the line.
• ROW_ID — the underlying ROWID of the base transaction line row.

Common Use Cases and Queries

Typical scenarios include tax reporting and reconciliation, integration extracts to external tax systems, and analytical reporting on transaction lines by organization or product type.

• Retrieving transaction line detail for a given transaction:

SELECT trx_line_id, trx_id, trx_line_number, line_amt, tax
FROM   apps.zx_transaction_lines_v
WHERE  trx_id = :p_trx_id;

• Summarizing line amounts by product organization:

SELECT product_org_desc, COUNT(*) line_count, SUM(line_amt) total_amt
FROM   apps.zx_transaction_lines_v
GROUP  BY product_org_desc;

• Filtering lines by product type or tax regime for reporting extracts:

SELECT trx_line_id, product_type_desc, tax_regime_code, tax
FROM   apps.zx_transaction_lines_v
WHERE  tax_regime_code = :p_regime
AND    product_type_desc IS NOT NULL;

Because the view enforces organization security through HR_SECURITY and related packages, query results are automatically restricted to the organizations accessible to the current session, making it suitable for production reporting without additional security predicates.