Results for “pa_output_tax_code_txn_v”
42 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_OUTPUT_TAX_CODE_TXN_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in the ETRM metadata, the object is a VIEW with VALID status, and its description is recorded as "10SC Only," indicating that it is intended for a specific localized configuration rather than general global use. The view exposes a filtered, projects-oriented list of output tax classifications that can be consumed by reporting, integration, and validation logic. Its practical role is to present only those output tax classification lookup values that are presently enabled, thereby shielding downstream consumers from inactive or retired codes.
The naming and metadata confirm a close relationship to the Tax (ZX) product. The object surfaced in the user's search for "zx_output_classifications_v" is the same underlying view that PA_OUTPUT_TAX_CODE_TXN_V selects from, so the user's query is directly satisfied by this object. In EBS reporting and integration contexts, such a view is typically used to populate value sets, validate transaction-level tax codes, and drive output tax classification on project-related transactions.
Underlying Base Objects
The ETRM metadata documents a single referenced base object: ZX_OUTPUT_CLASSIFICATIONS_V, itself a view. PA_OUTPUT_TAX_CODE_TXN_V is therefore defined over ZX_OUTPUT_CLASSIFICATIONS_V and does not reference base tables directly. The dependency is a straightforward one-to-one selection with a filter.
The documented view text is:
- SELECT MEANING, LOOKUP_CODE, START_DATE_ACTIVE, END_DATE_ACTIVE, ORG_ID FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE ENABLED_FLAG = 'Y'
The where clause restricts the result set to enabled output tax classifications. Because the base object is a view in the ZX schema, the actual base tables (such as the lookup and tax classification tables underpinning ZX_OUTPUT_CLASSIFICATIONS_V) are not enumerated in the metadata excerpt. Documentation of those tables would need to be obtained from the ZX object metadata. The ORG_ID column indicates that the source view is organization-aware, supporting multi-org filtering in EBS 12.1.1 and 12.2.2.
Key Columns
The view exposes the following columns, per the documented metadata. Note the column naming in the view text differs from the column list in the metadata, so both mappings are noted:
- TAX_NAME / MEANING — the descriptive name of the output tax classification. In the select list this is aliased from MEANING.
- TAX_CODE / LOOKUP_CODE — the code value identifying the tax classification, mapped from LOOKUP_CODE.
- START_DATE_ACTIVE — the date on which the classification becomes active.
- END_DATE_ACTIVE — the date on which the classification ceases to be active; a null value generally indicates no defined end date.
- ORG_ID — the operating unit or organization identifier, enabling multi-org aware queries.
The ENABLED_FLAG column used in the filter is not projected in the select list, so it is a selection criterion rather than a reported attribute.
Common Use Cases and Queries
Typical uses include populating LOVs or value sets for project tax entry, validating tax codes before transaction processing, and extracting a clean list of active output tax classifications for integration or reporting. Because the view filters on ENABLED_FLAG = 'Y', consumers automatically receive only enabled classifications.
A representative query follows:
- SELECT TAX_NAME, TAX_CODE, START_DATE_ACTIVE, END_DATE_ACTIVE, ORG_ID FROM APPS.PA_OUTPUT_TAX_CODE_TXN_V WHERE ORG_ID = :p_org_id ORDER BY TAX_NAME;
Analysts may also join to the base ZX_OUTPUT_CLASSIFICATIONS_V to retrieve classifications that are disabled, or to reconcile the filtered list against the full set. Given the "10SC Only" designation, usage should be confirmed against the specific localization and release (12.1.1 or 12.2.2) before relying on the view in custom code or interfaces.
-
10SC Only
APPS.PA_OUTPUT_TAX_CODE_TXN_V·↳ ZX_OUTPUT_CLASSIFICATIONS_V·Explore PA module →
-
10SC Only
APPS.PA_OUTPUT_TAX_CODE_TXN_V·↳ ZX_OUTPUT_CLASSIFICATIONS_V·Explore PA module →
-
APPS.PA_OUTPUT_TAX_CODE_SETUP_V·↳ PA_OUTPUT_TAX_CODE_TXN_V·Explore PA module →
-
APPS.PA_OUTPUT_TAX_CODE_SETUP_V·↳ PA_OUTPUT_TAX_CODE_TXN_V·Explore PA module →
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - FND Tables and Views 12.2.2
No longer used
-
eTRM - PA Tables and Views 12.1.1
-
eTRM - PA Tables and Views 12.2.2
-
eTRM - FND Tables and Views 12.1.1
No longer used
-
eTRM - FND Tables and Views 12.2.2
No longer used
-
eTRM - PA Tables and Views 12.1.1
-
eTRM - PA Tables and Views 12.2.2
-
eTRM - FND Tables and Views 12.1.1
No longer used