Results for “party_type_code”

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

Overview

ZX_FIRST_PARTY_ORGS_MOAC_V is a reporting view owned by the APPS schema in Oracle E-Business Tax (EBTax). It exposes first-party organizations registered in the tax repository (ZX_PARTY_TAX_PROFILE) together with a resolved party name and the subscriber configuration flag. The view consolidates three distinct classes of first-party tax parties — legal entities stored in XLE_ENTITY_PROFILES, operating units stored in HR_OPERATING_UNITS, and a generic "GCO" classification sourced from FND_LOOKUPS — into a single, unioned result set keyed by PARTY_TAX_PROFILE_ID.

In the 12.1.1 and 12.2.2 releases the view is documented as a VALID object in the Application Object Library (FND) product grouping, though functionally it belongs to the tax configuration domain. It is typically used by tax setup diagnostics, party tax profile inquiries, and downstream reporting or integration layers that need a flat list of the organizations that can act as first-party subscribers for tax determination.

Underlying Base Objects

The documented base objects are:

• ZX_PARTY_TAX_PROFILE (synonym) — the driving table holding party tax profile records for all party types.
• HZ_PARTIES (synonym) — the TCA party registry, joined for the FIRST_PARTY branch.
• XLE_ENTITY_PROFILES (synonym) — legal entity definitions, supplying the party name for legal entities.
• HR_OPERATING_UNITS (view) — operating unit definitions, supplying the party name for OU-type profiles.
• MO_GLOB_ORG_ACCESS_TMP (synonym) — the organization access security structure used to constrain operating unit visibility.
• FND_LOOKUPS (view) — the lookup source for the GCO party type, using lookup type ZX_PTP_PARTY_TYPE.
• FND_GLOBAL (package) — referenced for session context such as the current organization.

Each UNION ALL branch filters ZX_PARTY_TAX_PROFILE by PARTY_TYPE_CODE ('FIRST_PARTY', 'OU', or 'GCO') and joins to the corresponding name source. Because the branches are disjoint by party type, the union does not duplicate rows.

Key Columns

• PARTY_TAX_PROFILE_ID — primary identifier of the party tax profile; the join key back to ZX_PARTY_TAX_PROFILE and to tax configuration tables.
• PARTY_NAME — the resolved display name. For first parties it is XLE_ENTITY_PROFILES.NAME; for operating units it is HR_OPERATING_UNITS.NAME; for GCO it is the lookup MEANING from FND_LOOKUPS.
• PARTY_TYPE_CODE — indicates the class of party: 'FIRST_PARTY', 'OU', or 'GCO'.
• USE_LE_AS_SUBSCRIBER_FLAG — indicates whether the legal entity associated with the party is to be used as the subscriber for tax purposes.

Common Use Cases and Queries

The view is commonly queried when validating tax setup, troubleshooting subscriber resolution, or feeding downstream extracts that require first-party organization names. A typical diagnostic lists all configured first-party parties with their subscriber flag:

• SELECT party_tax_profile_id, party_name, party_type_code, use_le_as_subscriber_flag FROM zx_first_party_orgs_moac_v ORDER BY party_type_code, party_name;
• SELECT party_name FROM zx_first_party_orgs_moac_v WHERE party_type_code = 'OU'; — enumerate operating units available as tax parties.
• SELECT party_tax_profile_id FROM zx_first_party_orgs_moac_v WHERE use_le_as_subscriber_flag = 'Y'; — find parties whose legal entity acts as subscriber.

Because the view is read-only and derived from the tax repository and TCA, it should be used for inquiry and reporting, not for DML. Access is subject to the standard APPS schema grants and to organization access security applied through the MOAC access structure referenced in the operating unit branch.