Results for “line_amt”

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

Overview

ZX_USR_PROC_NEG_LINE_V is a PL/SQL view owned by the APPS schema within the Oracle E-Business Tax (E-Business Tax / ETRM) product family, surfaced in Oracle EBS 12.1.1 and 12.2.2 under the FND – Application Object Library module designation. The view exposes a consolidated, pre-processing data set of tax line details for a transaction as captured by the tax partner negation line global temporary table. It joins partner negation line facts against transaction pre-processing options, enriching each fact row with the applicable tax provider and tax regime context. Because the source objects are session-scoped global temporary tables, the view behaves as a working data set rather than a persistent reporting table: it is populated only within the scope of the calling transaction and is intended to feed downstream tax calculation, validation, and adjustment routines.

Underlying Base Objects

The documented base objects are two synonyms referenced by the view definition:

• ZX_PTNR_NEG_LINE_GT (alias ZX_NEG_LINE_DET_FACT) — the partner negation line global temporary table, supplying line-level tax facts including organization, application, entity, event class, transaction, product, party tax profile, and adjustment attributes.
• ZX_TRX_PRE_PROC_OPTIONS_GT (alias ZX_PRE_REC_OPT) — the transaction pre-processing options global temporary table, supplying the tax provider ID and tax regime code.

The two tables are joined on INTERNAL_ORGANIZATION_ID, ensuring the negation line facts are matched to the pre-processing options established for the same operating unit. In 12.1.1 the objects reside under the ZX (E-Business Tax) schema with APPS synonyms; in 12.2.2 the same structure is retained, reflecting E-Business Tax's continued ownership of the tax determination data model. Researchers searching for the string "zx_ptnr_neg_line_gt" will recognize the first base object directly as the primary driver of this view.

Key Columns

The view projects a broad set of identifying, party, and adjustment columns:

• INTERNAL_ORGANIZATION_ID, APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE — the transaction identity envelope, defining which document, line, and level the fact applies to.
• TAX_PROVIDER_ID, TAX_REGIME_CODE — sourced from ZX_TRX_PRE_PROC_OPTIONS_GT, identifying the tax authority and regime governing the line.
• PRODUCT_ID, PRODUCT_ORG_ID — the inventory item and organization associated with the line.
• EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON, EXEMPTION_CONTROL_FLAG — exemption and certificate handling attributes.
• SHIP_FROM_PARTY_TAX_PROF_ID, SHIP_TO_PARTY_TAX_PROF_ID, SHIP_TO_SITE_TAX_PROF_ID, BILL_TO_PARTY_TAX_PROF_ID, BILL_TO_SITE_TAX_PROF_ID, TRADING_HQ_PARTY_TAX_PROF_ID, TRADING_HQ_SITE_TAX_PROF_ID — party and site tax profile identifiers establishing which registrations apply at each transaction role.
• SHIP_TO_LOCATION_ID, BILL_TO_LOCATION_ID, SHIP_TO_CUST_ACCT_SITE_USE_ID, BILL_TO_CUST_ACCT_SITE_USE_ID, SHIP_THIRD_PTY_ACCT_SITE_ID, BILL_THIRD_PTY_ACCT_SITE_ID, BILL_THIRD_PTY_ACCT_ID — location and third-party account site references.
• LINE_LEVEL_ACTION, LINE_AMT, ADJUSTED_DOC_TRX_ID, ADJUSTED_DOC_LINE_ID, ADJUSTED_DOC_APPLICATION_ID, ADJUSTED_DOC_ENTITY_CODE, ADJUSTED_DOC_EVENT_CLASS_CODE, ADJUSTED_DOC_TRX_LEVEL_TYPE, RECEIVABLES_TRX_TYPE_ID — negation and adjustment mechanics, identifying the original document being negated, the line amount, and the receivables transaction type.

Common Use Cases and Queries

This view is typically queried during debugging and support of tax determination logic, particularly when negation or adjustment lines fail to calculate correctly. Because it draws on global temporary tables, any query must run inside the session that populates ZX_PTNR_NEG_LINE_GT. A representative query follows:

• Retrieve all negation line facts for a transaction:
  SELECT trx_id, trx_line_id, tax_regime_code, tax_provider_id, line_amt, line_level_action FROM apps.zx_usr_proc_neg_line_v WHERE trx_id = :p_trx_id;
• Inspect exemption attributes for a party:
  SELECT trx_line_id, exempt_certificate_number, exempt_reason, exemption_control_flag FROM apps.zx_usr_proc_neg_line_v WHERE bill_to_party_tax_prof_id = :p_profile_id;
• Trace adjusted document linkage:
  SELECT trx_id, adjusted_doc_trx_id, adjusted_doc_line_id, adjusted_doc_entity_code FROM apps.zx_usr_proc_neg_line_v;

Typical scenarios include reconciling tax lines posted against a credit memo to the original invoice, confirming that ship-to and bill-to tax profiles resolve for direct and third-party sales, and validating that the correct tax regime and provider are carried forward from pre-processing options into the negation facts surfaced for downstream calculation.