Results for “use_le_as_subscriber_flag”

50+ results




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

Overview

The view APPS.ZX_FIRST_PARTY_ORGANIZATIONS_V is a reporting and integration object within the Oracle E-Business Suite (EBS) tax and party data model. It is owned by the APPS schema and resides in the Application Object Library (FND) product grouping, which is the shared repository for cross-application objects. The view presents a consolidated list of first-party organizations as defined within the E-Business Tax (EBTax) party tax profile infrastructure. The term "first party" identifies the legal entities, operating units, and global configuration owner records that represent the organization itself from a tax determination perspective, as opposed to third-party customers or suppliers. In EBS Release 12.1.1 and 12.2.2, this view is typically surfaced through Oracle Reports, OAF-based pages, and custom integrations that require a validated list of transacting parties for tax registration, tax calculation, and configuration-owner purposes. Its role is to abstract the more complex join conditions needed to derive the qualifying first-party records from the party tax profile table, so that consumers need not understand the underlying party-type logic.

Underlying Base Objects

The view is defined over ZX_PARTY_TAX_PROFILE, which is the authoritative repository for party-level tax configuration in EBS. The documented base objects referenced by the view include HZ_PARTIES, MO_GLOB_ORG_ACCESS_TMP, FND_LOOKUPS, FND_PROFILE (package), and FND_GLOBAL (package). The view text selects PARTY_TAX_PROFILE_ID, PARTY_TYPE_CODE, and USE_LE_AS_SUBSCRIBER_FLAG from ZX_PARTY_TAX_PROFILE and filters the rows through a compound EXISTS predicate. Records with PARTY_TYPE_CODE = 'FIRST_PARTY' are included when a matching PARTY_ID is found in HZ_PARTIES. Records with PARTY_TYPE_CODE = 'OU' (Operating Unit) are included when the party identifier exists in MO_GLOB_ORG_ACCESS_TMP, or when a lookup in FND_LOOKUPS for the ZX_PTP_PARTY_TYPE lookup type matches the 'GCO' code and the profile option ZX_GCO_WRITE_ACCESS resolves to 'Y' through FND_PROFILE.VALUE. The dependency on the temporary organization access structure MO_GLOB_ORG_ACCESS_TMP reflects the multi-org architecture, where valid organization identifiers are materialized per session.

Key Columns

  • PARTY_TAX_PROFILE_ID — The primary identifier of the party tax profile record, used to join back to ZX_PARTY_TAX_PROFILE for full configuration detail.
  • PARTY_TYPE_CODE — The classification of the party, indicating whether the record represents a FIRST_PARTY, an OU, or a GCO (Global Configuration Owner). This column is central to filtering and to interpreting the source of the record.
  • USE_LE_AS_SUBSCRIBER_FLAG — A flag indicating whether the associated legal entity is used as a subscriber for tax registration or tax content subscription purposes, relevant in configuration-owner and subscription setups.

Common Use Cases and Queries

Typical scenarios include validation of first-party tax profiles in tax registration workflows, providing selection lists for legal entities and operating units in custom concurrent programs, and auditing configuration-owner assignments. A sample query returns the qualifying first-party organizations:

  • SELECT party_tax_profile_id, party_type_code, use_le_as_subscriber_flag FROM zx_first_party_organizations_v WHERE party_type_code = 'FIRST_PARTY';
  • SELECT party_tax_profile_id, party_type_code FROM zx_first_party_organizations_v WHERE party_type_code IN ('OU','GCO');
  • SELECT p.party_name, v.party_type_code, v.use_le_as_subscriber_flag FROM zx_first_party_organizations_v v, hz_parties p WHERE v.party_tax_profile_id = p.party_id AND p.party_type = 'ORGANIZATION';

When building custom reports, note that the ZX_GCO_WRITE_ACCESS profile option influences visibility of Global Configuration Owner records, so results may vary by user responsibility and session context.