Search Results trx_line_dist_id




Overview
Explore in AI Chat

Overview

APPS.AP_ZX_DEF_TAX_EXTRACT_V is a public synonym view in the Oracle E-Business Suite Payables (AP) schema that exposes deferred tax extraction data for use by the E-Business Tax (ZX) engine. It is a thin projection layer defined over the underlying view ZX_AP_DEF_TAX_EXTRACT_V, renaming each column with an "AID_" prefix so that the columns are uniquely identified within the Oracle E-Business Tax extraction interfaces. The view is part of the ZX extraction architecture that feeds tax distribution and settlement processing, and it is typically consumed by Payables tax extraction programs, reporting queries, and EBS Tax integrations rather than by end users directly.

The view is documented in ETRM 12.2.2 and is also present in 12.1.1. Because it is a pass-through view, it inherits all row-level security and data derivation logic from its base view, including the filters and joins applied within ZX_AP_DEF_TAX_EXTRACT_V.

Underlying Base Objects

The documented base object is a single view: ZX_AP_DEF_TAX_EXTRACT_V (VIEW), owned by the ZX/APPS layer. AP_ZX_DEF_TAX_EXTRACT_V performs no joins or filters; its SELECT list simply re-aliases every column from the base view. The purpose of the alias prefix is to distinguish physical extraction columns (which may surface under generic names such as TAX_LINE_ID or TRX_LINE_DIST_ID) from the identifiers used by the extraction consumer, avoiding collisions when multiple source views are combined.

The underlying ZX_AP_DEF_TAX_EXTRACT_V is the operative object that derives deferred tax extraction rows for Payables transactions, including recoverable and non-recoverable tax distribution identifiers and the associated account and ledger context. Any change to the base view's definition propagates immediately to this wrapper view.

Key Columns

Common Use Cases and Queries

A frequent scenario is locating deferred tax extraction rows for a specific AP invoice distribution, which is accomplished by joining on TRX_LINE_DIST_ID (exposed as AID_TRX_LINE_DIST_ID).

SELECT aid_trx_line_dist_id,
       aid_tax_line_id,
       aid_summary_tax_line_id,
       aid_recoverable_flag,
       aid_def_rec_settle_option_code,
       aid_tax_account_ccid,
       aid_org_id,
       aid_ledger_id
FROM   apps.ap_zx_def_tax_extract_v
WHERE  aid_trx_line_dist_id = :trx_line_dist_id;

Another common pattern is reconciling recoverable versus non-recoverable deferred tax amounts by operating unit and ledger:

SELECT aid_org_id,
       aid_ledger_id,
       aid_recoverable_flag,
       COUNT(*) row_count
FROM   apps.ap_zx_def_tax_extract_v
GROUP  BY aid_org_id, aid_ledger_id, aid_recoverable_flag;

Because the view is a direct projection of ZX_AP_DEF_TAX_EXTRACT_V, queries against it can also be issued against the base view if the caller expects unprefixed column names. The wrapper view is preferred in extraction and integration code where column naming collisions are possible. Appropriate grants and synonyms must exist for the calling schema, as access is controlled at the APPS layer.