Results for “internal_organization_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
ZX_USER_PROC_INPUT_V is a VALID view owned by the APPS schema within the FND - Application Object Library product group in Oracle E-Business Suite, documented under ETRM for releases 12.1.1 and 12.2.2. The view exposes the pre-processing input parameters captured for user-defined tax processing in the E-Business Tax (ZX) module. Its name reflects its purpose: it presents the "user processing input" values that Oracle's tax engine consumes before the tax determination and calculation routines execute for a transaction.
In Oracle EBS reporting and integration contexts, this view functions as a lightweight, denormalized access point into a global temporary table used during tax pre-processing. Rather than exposing the entire GT structure, the view projects a focused set of identifying and configuration columns, allowing external programs, concurrent reports, and custom SQL to read the pre-processing options associated with a transaction. Because it is a view over a session-scoped temporary table, the rows visible to any query are limited to those populated by the current session's tax processing activity.
Underlying Base Objects
According to the documented ETRM metadata for 12.2.2, the view is defined over a single referenced base object: ZX_TRX_PRE_PROC_OPTIONS_GT, which is registered in the APPS schema as a synonym. The documented view text confirms this directly:
- SELECT INTERNAL_ORGANIZATION_ID, APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TAX_PROVIDER_ID, TAX_REGIME_CODE
- FROM ZX_TRX_PRE_PROC_OPTIONS_GT
ZX_TRX_PRE_PROC_OPTIONS_GT is a global temporary table (GT) that holds transaction pre-processing options during E-Business Tax processing. Because ZX_USER_PROC_INPUT_V selects from the GT without joins, filters, or aggregations, it is a direct pass-through view. It does not persist data of its own; all content is transient and scoped to the session and transaction context in which the underlying GT is populated. This design means the view does not participate in row-level security or partitioning logic beyond what the GT itself enforces.
Key Columns
The view exposes seven columns, each carrying transactional or tax-configuration context:
- INTERNAL_ORGANIZATION_ID — Identifies the internal organization (operating unit or inventory organization) associated with the transaction, anchoring the tax event to a legal and business context.
- APPLICATION_ID — The application identifier (FND_APPLICATION.APPLICATION_ID) of the source application, distinguishing tax processing for Receivables, Payables, Purchasing, and other modules.
- ENTITY_CODE — The application entity code representing the type of tax event or business entity being processed.
- EVENT_CLASS_CODE — Classifies the event driving tax processing, such as a customer invoice, purchase order, or credit memo.
- TRX_ID — The transaction identifier linking the pre-processing input row to the specific document under tax evaluation.
- TAX_PROVIDER_ID — The tax provider identifier, indicating which provider or service supplies or overrides tax calculation for the transaction.
- TAX_REGIME_CODE — The tax regime code, identifying the tax regime (for example, a country-specific VAT or sales tax regime) applied to the transaction.
Common Use Cases and Queries
Typical usage centers on diagnostics, integration extraction, and reporting on tax pre-processing behavior. A common pattern is to retrieve the options captured for a specific transaction within the active session:
- Transaction-level inspection: Select all columns from ZX_USER_PROC_INPUT_V where TRX_ID equals the document number in question, to verify which tax provider and regime were supplied before calculation.
- By organization or application: Filter on INTERNAL_ORGANIZATION_ID or APPLICATION_ID to analyze pre-processing options across an operating unit or module.
- Event classification: Aggregate rows by EVENT_CLASS_CODE or ENTITY_CODE to understand how tax pre-processing inputs differ across document types.
- Integration extraction: Programs integrating with external tax engines can read this view to synchronize the provider and regime parameters used for each transaction.
Because the underlying object is a global temporary table, queries outside the processing session may return no rows. Analysts should invoke the view within the same session or concurrent request that populates ZX_TRX_PRE_PROC_OPTIONS_GT, which is why the view is best suited to in-process diagnostics and point-in-time reporting rather than historical analysis. For historical tax data, base transactional tax tables should be queried instead.
-
View: ZX_USER_PROC_INPUT_V 12.1.1
APPS.ZX_USER_PROC_INPUT_V·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
View: ZX_USER_PROC_INPUT_V 12.2.2
APPS.ZX_USER_PROC_INPUT_V·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
APPS.ZX_USER_PROC_HDR_INPUT_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
This table stores the various provider pre-processing options for the applicable regime of the transaction under consideration before calling respective service of the provider.
-
This table stores the various provider pre-processing options for the applicable regime of the transaction under consideration before calling respective service of the provider.
-
APPS.ZX_USER_PROC_HDR_INPUT_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
This global temporary table is used to pass summary or detail tax lines when importing documents with tax.
-
This view displays Tax Summary for Invoice or Credit Memo.
APPS.OKL_CS_INVCM_TAX_SUM_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
This view displays Tax Summary for Invoice or Credit Memo.
APPS.OKL_CS_INVCM_TAX_SUM_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
View: ZX_USR_PROC_NEG_LINE_V 12.2.2
APPS.ZX_USR_PROC_NEG_LINE_V·↳ ZX_PTNR_NEG_LINE_GT·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
APPS.ZX_DETAIL_TAX_LINES_QUOTE_V·↳ ZX_DETAIL_TAX_LINES_GT·↳ ZX_LINES·↳ ZX_LINES_DET_FACTORS·Explore FND module →
-
APPS.ZX_DETAIL_TAX_LINES_QUOTE_V·↳ ZX_DETAIL_TAX_LINES_GT·↳ ZX_LINES·↳ ZX_LINES_DET_FACTORS·Explore FND module →
-
APPS.ZX_USER_PROC_LINE_INPUT_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
View: ZX_USR_PROC_NEG_LINE_V 12.1.1
APPS.ZX_USR_PROC_NEG_LINE_V·↳ ZX_PTNR_NEG_LINE_GT·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
This table contains default tax accounts for jurisdictions and rates. Each record represents default tax accounts defined by the internal organization for a jurisdiction or a rate.
-
Table: ZX_REVERSE_DIST_GT 12.1.1
This global temporary table is used to pass transaction line distribution identifiers of reversing and reversed documents.
-
View: ZX_SYNC_HDR_INPUT_V 12.2.2
APPS.ZX_SYNC_HDR_INPUT_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_PRVDR_HDR_EXTNS_GT·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
This table is used to store the tax lines for OLM tax events
-
This table is used during upgrades, to store the tax lines.
-
APPS.ZX_O2C_CALC_TXN_INPUT_V·↳ RA_CUST_TRX_TYPES_ALL·↳ ZX_LINES_DET_FACTORS·↳ ZX_PRVDR_HDR_EXTNS_GT·Explore FND module →
-
This global temporary table is used to pass summary or detail tax lines when importing documents with tax.
-
Table: ZX_REVERSE_DIST_GT 12.2.2
This global temporary table is used to pass transaction line distribution identifiers of reversing and reversed documents.
-
View: ZX_LINES_V 12.1.1
APPS.ZX_LINES_V·↳ ZX_JURISDICTIONS_TL·↳ ZX_LINES·↳ ZX_RATES_TL·Explore FND module →
-
View: ZX_SYNC_HDR_INPUT_V 12.1.1
APPS.ZX_SYNC_HDR_INPUT_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_PRVDR_HDR_EXTNS_GT·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
APPS.ZX_USER_PROC_LINE_INPUT_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
APPS.ZX_O2C_CALC_TXN_INPUT_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_PRVDR_HDR_EXTNS_GT·↳ ZX_PRVDR_LINE_EXTNS_GT·Explore FND module →
-
View: ZX_LINES_SUMMARY_V 12.1.1
APPS.ZX_LINES_SUMMARY_V·↳ ZX_LINES_SUMMARY·↳ ZX_RATES_TL·Explore FND module →
-
This table contains default tax accounts for jurisdictions and rates. Each record represents default tax accounts defined by the internal organization for a jurisdiction or a rate.
-
View: ZX_TRANSACTIONS_V 12.2.2
APPS.ZX_TRANSACTIONS_V·↳ FND_APPLICATION_VL·↳ HR_OPERATING_UNITS·↳ XLE_ENTITY_PROFILES·Explore FND module →
-
APPS.ZX_DETAIL_TAX_LINES_GT_V·↳ ZX_DETAIL_TAX_LINES_GT·↳ ZX_JURISDICTIONS_TL·↳ ZX_RATES_TL·Explore FND module →
-
APPS.ZX_P2P_CALC_TXN_INPUT_V·↳ ZX_EVNT_CLS_MAPPINGS·↳ ZX_LINES_DET_FACTORS·↳ ZX_PRVDR_HDR_EXTNS_GT·Explore ZX module →
-
This global temporary table is used to pass transaction information for tax calculation.
-
This table stores the summarized tax lines for transactions of multiple event classes.
-
This table stores the tax lines information from Payables, Receivables and General Ledger.
-
This table is used during upgrades, to store the tax lines.
-
This table is used to store the tax lines for OLM tax events
-
This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class.
-
This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class.
-
View: OKL_TAX_TRX_DETAILS_V 12.2.2
This is a simple view on top of okl_tax_trx_details, which stores the tax lines for a tax event.
APPS.OKL_TAX_TRX_DETAILS_V·↳ OKL_TAX_TRX_DETAILS·Explore OKL module →
-
View: OKL_TAX_TRX_DETAILS_V 12.1.1
This is a simple view on top of okl_tax_trx_details, which stores the tax lines for a tax event.
APPS.OKL_TAX_TRX_DETAILS_V·↳ OKL_TAX_TRX_DETAILS·Explore OKL module →
-
This global temporary table is used to cache tax distributions during tax processing for transactions.
-
View: ZX_TRANSACTIONS_V 12.1.1
APPS.ZX_TRANSACTIONS_V·↳ FND_APPLICATION_VL·↳ HR_OPERATING_UNITS·↳ XLE_ENTITY_PROFILES·Explore FND module →
-
APPS.ZX_DETAIL_TAX_LINES_GT_V·↳ ZX_DETAIL_TAX_LINES_GT·↳ ZX_JURISDICTIONS_TL·↳ ZX_RATES_TL·Explore FND module →
-
APPS.ZX_P2P_CALC_TXN_INPUT_V·↳ ZX_EVNT_CLS_MAPPINGS·↳ ZX_LINES_DET_FACTORS·↳ ZX_PRVDR_HDR_EXTNS_GT·Explore ZX module →
-
This global temporary table is used to cache copy of the transaction lines before user modifies them. This copying is carried only for upgraded tax partner integration.
-
Contains AP, AR and GL Transactions selected for VAT reporting
-
This table stores transactions entered by the user through tax simulator.
-
This table stores transactions entered by the user through tax simulator.