Search Results recovery_rate_code

Overview

ZX_REC_NREC_DIST_QUOTE_V is a reporting view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2, registered under the FND – Application Object Library product family. The view exposes recoverable and non-recoverable tax distribution data generated by the E-Business Tax (EBTax) engine, specifically in the context of tax quoting and tax simulation performed through the ZX (Tax) application programming interfaces. It presents a consolidated, denormalized projection of the base tax distribution records held in ZX_REC_NREC_DIST, joined with calculation detail factors and global temporary staging rows to support interactive quoting and reporting of recoverability outcomes.

The "_QUOTE_V" suffix indicates that this view is intended for use in quoting and simulation flows rather than definitive transaction accrual. It allows reporting tools, custom concurrent programs, and integration layers to retrieve recoverable and non-recoverable tax amounts, recovery rates, and applicability metadata without directly navigating multiple base tables. The inclusion of APPLICABILITY_RESULT_ID and REC_RATE_RESULT_ID links each row back to the EBTax calculation result tables, enabling traceability of how a tax was evaluated.

Underlying Base Objects

According to ETRM documentation for release 12.2.2, the view is defined over the following referenced base objects:

• ZX_REC_NREC_DIST (SYNONYM) – the primary tax distribution table storing recoverable and non-recoverable tax amounts and rates.
• ZX_LINES_DET_FACTORS (SYNONYM) – the detail factor table holding the attribute values (intended use, project, task, award, expenditure type, etc.) that drive tax determination.
• ZX_REC_NREC_DIST_GT (SYNONYM) – a global temporary table used to stage recoverability distribution rows during quoting or simulation processing.

The view text confirms it selects columns from ZX_REC_NREC_DIST and integrates attributes sourced from the determination-factor and temporary staging structures. Because the underlying objects are exposed as synonyms in the APPS schema, application code should reference the view as APPS.ZX_REC_NREC_DIST_QUOTE_V rather than the base synonyms directly.

Key Columns

• REC_NREC_TAX_DIST_ID – primary identifier for the recoverable/non-recoverable distribution row.
• APPLICABILITY_RESULT_ID – the identifier linking the row to the tax applicability result produced by the tax engine; this is the column referenced by the user search.
• REC_RATE_RESULT_ID – identifier of the recovery-rate determination result.
• TRX_ID, TRX_LINE_ID, TRX_LINE_NUMBER – transaction and transaction line context.
• TAX_LINE_ID, TAX_LINE_NUMBER – the associated tax line.
• TAX_REGIME_CODE, TAX, TAX_STATUS_CODE, TAX_RATE_CODE – tax regime, tax, status, and rate identifiers.
• RECOVERY_TYPE_CODE, RECOVERY_RATE_CODE, REC_NREC_RATE – recovery classification and the recoverable percentage applied.
• RECOVERABLE_FLAG, REVERSE_FLAG, HISTORICAL_FLAG – recoverability and reversal indicators.
• REC_NREC_TAX_AMT, REC_NREC_TAX_AMT_TAX_CURR, REC_NREC_TAX_AMT_FUNCL_CURR – the recoverable/non-recoverable tax amount in transaction, tax, and functional currencies.
• INTENDED_USE, PROJECT_ID, TASK_ID, AWARD_ID, EXPENDITURE_TYPE – determination factors qualifying the recovery outcome.
• LEDGER_ID, TRX_CURRENCY_CODE, TAX_CURRENCY_CODE – ledger and currency context.
• ATTRIBUTE1–15, GLOBAL_ATTRIBUTE1–15 – descriptive flexfield and global descriptive flexfield columns.

Common Use Cases and Queries

The view is typically queried to audit recoverable versus non-recoverable tax amounts, to reconcile tax quoting simulations, and to trace recoverability outcomes back to applicability and rate results.

• Retrieve distributions for a transaction: SELECT trx_id, trx_line_id, tax, rec_nrec_tax_amt, recoverable_flag FROM zx_rec_nrec_dist_quote_v WHERE trx_id = :p_trx_id;
• Trace by applicability result: SELECT rec_nrec_tax_dist_id, applicability_result_id, rec_rate_result_id, rec_nrec_rate FROM zx_rec_nrec_dist_quote_v WHERE applicability_result_id = :p_applicability_result_id;
• Recoverability by project and expenditure type: SELECT project_id, task_id, expenditure_type, SUM(rec_nrec_tax_amt) FROM zx_rec_nrec_dist_quote_v WHERE ledger_id = :p_ledger_id GROUP BY project_id, task_id, expenditure_type;

Because the view draws on a global temporary table, callers should invoke it within the same session context that populated ZX_REC_NREC_DIST_GT to obtain complete results.