Search Results recoverable_flag

Overview

The ZX_AP_DEF_TAX_EXTRACT_V view is a reporting and integration object owned by the APPS schema within Oracle E-Business Suite. It resides under the FND – Application Object Library product grouping, though its functional content belongs to the E-Business Tax (E-Business Tax / ZX) module used to manage tax determination, tax lines, and tax distributions across Payables, Receivables, and related subledgers. The view provides a flattened extraction of deferred recoverability tax distribution records, joining distribution detail against tax account setup so that consumers obtain the recoverable tax amount together with the appropriate tax account code combination for deferred settlement scenarios.

The name prefix ZX_AP indicates the view is oriented toward the Payables (AP) tax extraction path, while DEF refers to deferred or non-recoverable handling and TAX_EXTRACT_V reflects its purpose as a read-only extraction interface. Because the object is a view, it stores no data of its own; it is resolved at query time against the underlying distributions and accounts tables. It is commonly consumed by reporting tools, reconciliation processes, and downstream integrations that need to reconcile recoverable and settlement-option-driven tax postings without navigating the more normalized base tables directly.

Underlying Base Objects

The view is defined over two documented base objects:

• ZX_REC_NREC_DIST (referenced as a synonym in APPS) — the recoverable/non-recoverable distribution table holding tax line and transaction line distribution identifiers, recoverability flags, and deferred settlement option codes.
• ZX_ACCOUNTS (referenced as a synonym in APPS) — the tax account definition table holding account CCID, organization, and ledger assignments keyed by tax account entity.

The join is a LEFT OUTER JOIN from distributions to accounts, so every distribution row is preserved even when no matching account configuration exists. The join predicate pairs accounts to distributions on entity identifier, entity code, internal organization, and ledger, with the account entity identifier resolved through an NVL against the account-source tax rate ID or the tax rate ID. The account entity code must equal 'RATES', restricting the join to rate-level account assignments. This LEFT OUTER construction ensures the extract does not silently drop distributions that lack a matching account row.

Key Columns

• REC_NREC_TAX_DIST_ID — primary distribution identifier from ZX_REC_NREC_DIST.
• SUMMARY_TAX_LINE_ID and TAX_LINE_ID — links to the summary and detail tax lines driving the distribution.
• TRX_LINE_DIST_ID — the associated transaction line distribution identifier.
• RECOVERABLE_FLAG — indicates whether the tax is recoverable.
• DEF_REC_SETTLEMENT_OPTION_CODE — the deferred recovery settlement option; a value of 'DEFERRED' triggers the account CCID exposure.
• TAX_ACCOUNT_CCID — populated via DECODE from ZX_ACCOUNTS.TAX_ACCOUNT_CCID only when the settlement option is 'DEFERRED'; otherwise NULL.
• ORG_ID — the internal organization identifier from the accounts table.
• LEDGER_ID — the ledger against which the distribution and account are aligned.

Common Use Cases and Queries

Typical uses include reconciling deferred recoverable tax postings, verifying that deferred distributions carry a valid tax account CCID, and feeding downstream extracts. A representative query:

• SELECT REC_NREC_TAX_DIST_ID, TAX_LINE_ID, RECOVERABLE_FLAG, DEF_REC_SETTLEMENT_OPTION_CODE, TAX_ACCOUNT_CCID, ORG_ID, LEDGER_ID FROM APPS.ZX_AP_DEF_TAX_EXTRACT_V WHERE DEF_REC_SETTLEMENT_OPTION_CODE = 'DEFERRED' AND LEDGER_ID = :p_ledger;
• Filtering on TAX_ACCOUNT_CCID IS NULL while the settlement option equals 'DEFERRED' exposes missing account configuration.
• Joining TAX_LINE_ID back to ZX_LINES or transaction distributions supports detailed tax audit reporting.