Search Results ptp_party

Overview

APPS.ZX_EXEMPTIONS_V is a reporting and integration view within the Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2 E-Business Tax (EBTax, also known as ETRM) module. It exposes exemption certificate data held in the ZX_EXEMPTIONS table, combining each exemption record with the associated third-party party or party-site context and the owning operating unit (legal entity). The view is owned by the APPS schema and is primarily consumed by tax determination, tax reporting, and downstream integrations that need to resolve an exemption to a specific party, cust_account, or site. The view returns only exemptions whose exemption_status_code is one of PRIMARY, MANUAL, or UNAPPROVED, and which carry a non-null exempt_certificate_number, thereby filtering to actionable exemption records.

Because the object is named in user search terms such as "ptp_party", it is commonly located by developers tracing how an exemption joins to the party tax profile. In the view definition, the alias ptp_party refers to the ZX_PARTY_TAX_PROFILE row for a THIRD_PARTY (party-level) exemption, while a parallel UNION ALL branch joins that same table to party-site records.

Underlying Base Objects

The view is defined over several base objects, per the documented metadata:

• ZX_EXEMPTIONS (synonym) — the driving table holding exemption certificate records, keyed by party_tax_profile_id and content_owner_id.
• ZX_PARTY_TAX_PROFILE (synonym) — joined twice: once as the third-party profile (ptp_party, party_type_code = 'THIRD_PARTY' or 'THIRD_PARTY_SITE'), and once as the operating unit profile (ou, party_type_code = 'OU', use_le_as_subscriber_flag = 'N').
• FND_LOOKUP_VALUES (synonym) — supplies the Meaning for the exemption reason code, restricted to lookup type ZX_EXEMPTION_REASON_CODE.
• HZ_PARTY_SITES (synonym) — used in the party-site UNION branch to derive party_site_id.
• GL_LEDGER_LE_V, HR_OPERATING_UNITS, XLE_ENTITY_PROFILES (views/synonyms) — referenced surrounding legal-entity and operating unit resolution.

Key Columns

• exempt_certificate_number — the exemption certificate identifier.
• exempt_reason_code / Meaning — reason code and its translated lookup meaning.
• exemption_status_code — PRIMARY, MANUAL, or UNAPPROVED.
• rate_modifier, tax_regime_code — tax rate/treatment context.
• cust_account_id, site_use_id — customer account and site usage context.
• party_id, party_site_id — resolved party or party site (site column is null in the party-level branch).
• effective_from, effective_to — validity window of the exemption.
• content_owner_id, org_id — owning operating unit.

Common Use Cases and Queries

Typical uses include reporting active exemptions per customer or party, checking exemption expiry, and tracing a party tax profile to its exemption. Example:

SELECT party_id, exempt_certificate_number, exempt_reason_code,
       exemption_status_code, effective_from, effective_to, org_id
FROM   apps.zx_exemptions_v
WHERE  effective_to >= SYSDATE
ORDER  BY party_id;

A join to HZ_PARTIES on party_id resolves the party name, and filtering on org_id isolates a single operating unit. Because party_site_id is null in the THIRD_PARTY branch, site-specific logic should filter accordingly.