Search Results exemption_control_flag




Overview
Explore in AI Chat

Overview

ZX_USER_PROC_LINE_INPUT_V is an APPS-owned database view within the Oracle E-Business Suite ETRM (E-Business Tax) module. It functions as a user-facing input interface for line-level tax determination processing, presenting the transaction line attributes that the tax engine consumes when evaluating applicability rules, tax regimes, and exemption logic. The view is registered under FND Design Data as FND.ZX_USER_PROC_LINE_INPUT_V and holds a VALID status in both the 12.1.1 and 12.2.2 releases. Its principal role is to expose a normalized set of tax-relevant line factors—party tax profiles, product identifiers, exemption attributes, and document references—so that external programs, concurrent processes, or custom reporting logic can supply or inspect the inputs used by E-Business Tax processing.

Because the object is a view rather than a table, it does not store data itself; it derives its result set from transaction pre-processing constructs and tax determination factor sources. This makes it suitable for read-oriented reporting and integration rather than direct DML.

Underlying Base Objects

The documented base objects referenced by this view are ZX_LINES_DET_FACTORS (accessed via a synonym) and ZX_TRX_PRE_PROC_OPTIONS_GT (also via a synonym). ZX_LINES_DET_FACTORS supplies the determinant factor values that the tax engine uses to resolve tax rules at the transaction line level, including party and location tax profile references. ZX_TRX_PRE_PROC_OPTIONS_GT is a global temporary table that carries pre-processing options and runtime control values set during tax processing initiation.

The join between these objects allows the view to present line-level tax determinants alongside the processing options active for the session or run. Consequently, the view reflects a transient processing context combined with stored determinant factors, which is consistent with its designation as a "user process line input" view.

Key Columns

Common Use Cases and Queries

Typical uses include diagnosing why a line received a particular exemption result, validating that the correct party tax profiles were passed to the engine, and building custom extracts that feed downstream tax reporting. The exemption_control_flag is frequently queried when reconciling exempt versus taxable lines.

Sample query:

  • SELECT trx_id, trx_line_id, exemption_control_flag, exempt_certificate_number, exempt_reason_code, tax_regime_code, line_amt FROM apps.zx_user_proc_line_input_v WHERE trx_id = :p_trx_id ORDER BY trx_line_id;
  • SELECT exemption_control_flag, COUNT(*) FROM apps.zx_user_proc_line_input_v WHERE entity_code = :p_entity GROUP BY exemption_control_flag;

Given the transient nature of the global temporary table component, results are meaningful only within an active tax processing context.