Results for “loc_unedisc_ccid”

8 results




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

Overview

ZX_AR_LOC_ACCOUNTS_EXTRACT_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Despite its "ZX" prefix, which normally associates an object with the E-Business Tax (formerly Oracle Tax) product family, the documented ETRM metadata classifies this object under FND — Application Object Library. The view is registered with a status of VALID and serves as a projection layer over Accounts Receivable location-level accounting setups. Its name indicates its principal function: to extract, in a normalized column format, the accounting flexfield identifiers (CCIDs) and related attributes that Receivables stores against a combination of operating unit and location segment.

In practice, the view presents a single row per Receivables location-account assignment, exposing tax, interim tax, adjustment, earned discount, unearned discount, and finance charge accounts, together with non-recoverable tax variants of those accounts. This makes it a convenient extraction interface for downstream reporting, reconciliation, and integration workloads without requiring the caller to bind directly to the AR base table.

Underlying Base Objects

The view is defined over a single documented base object, referenced through an APPS synonym: AR_LOCATION_ACCOUNTS_ALL. That table stores the accounting assignments keyed by operating unit (ORG_ID) and location segment (LOCATION_SEGMENT_ID). The view selects directly from this table with no joins, unions, or aggregations. Consequently, the view inherits the row population, partitioning, and Multi-Org behavior of AR_LOCATION_ACCOUNTS_ALL. In a Multi-Org environment, the underlying table is secured by the operating unit, and querying the view within a given MO: Operating Unit context returns only that organization's rows, whereas querying outside an organization context returns all organizations' rows that the application user is authorized to see.

Key Columns

All CCID columns reference Accounting Flexfield code combinations in the GL_CODE_COMBINATIONS table.

Common Use Cases and Queries

Typical scenarios include extracting location-level tax and Receivables accounting setups for reconciliation against the general ledger, populating data warehouses, validating account assignments after an operating unit or location change, and supporting migration or upgrade audits between release levels. Because the view surfaces all account columns with consistent aliases, it is well suited to bulk extraction.

A representative query retrieving assignments for a specific location is:

  • SELECT organization_id, location_segment_id, loc_tax_account_ccid, loc_interim_tax_ccid, loc_edisc_ccid, loc_finchrgccid FROM zx_ar_loc_accounts_extract_v WHERE location_segment_id = :p_location_segment_id;

To resolve the tax account to its segment values, the view can be joined to GL_CODE_COMBINATIONS:

  • SELECT v.organization_id, v.location_segment_id, g.segment1, g.segment2, g.segment3 FROM zx_ar_loc_accounts_extract_v v, gl_code_combinations g WHERE v.loc_tax_account_ccid = g.code_combination_id;

Because the view is a direct projection, no filtering, DISTINCT, or aggregation is applied; any row-level restriction or performance tuning must be introduced by the calling query. Callers should also avoid the LOC_NON_REC_ACCOUNT_CCID column for functional logic, as it is permanently null by definition.