Results for “ax_orgs_subs_v”

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

Overview

AX_ORGS_SUBS_V is a database view belonging to the AX - Global Accounting Engine product within Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to expose the identifier, name, and operating unit (org) information for third-party subidentifiers used by the Global Accounting Engine. A "third party" in this context is either a supplier or a customer, and the "subidentifier" is the finer-grained entity associated with that party, such as a supplier site or a customer bill-to site. The view therefore provides a consolidated, normalized listing of valid subidentifier values that the accounting engine can reference when constructing and validating accounting entries.

Because the view normalizes multiple heterogeneous sources into a single row format, it is primarily used by Global Accounting Engine logic and by reporting or reconciliation queries that need to resolve a subidentifier into a human-readable name while retaining the owning operating unit. The search term "org_name" maps directly to the ORG_NAME column, which returns the operating unit name from HR_ORGANIZATION_UNITS.

Underlying Base Objects

AX_ORGS_SUBS_V is defined as a UNION of several SELECT statements, each contributing one category of third-party subidentifier. The documented base objects are:

• HR_ORGANIZATION_UNITS (aliased HOU) — the source of ORG_NAME via HOU.NAME, joined to each branch on ORGANIZATION_ID with an outer join (+).
• PO_VENDOR_SITES_ALL (aliased PVSSA) — supplies supplier-side subidentifiers (VENDOR_ID, VENDOR_SITE_ID, VENDOR_SITE_CODE).
• RA_ADDRESSES_ALL and RA_SITE_USES_ALL (aliased RA and RSU) — supply customer bill-to sites, restricted to SITE_USE_CODE = 'BILL_TO' and excluding CUSTOMER_ID = -999.
• RA_CUSTOMERS (aliased RC) — used in the unidentified customer branch.
• AX_LOOKUPS (aliased AL) — supplies the AX_3RD_PARTY_UNIDENTIFIED lookup meanings for the placeholder rows.
• MTL_PARAMETERS and AX_SECONDARY_INVENTORY (aliased MTL and ASI) — supply inventory organization and secondary inventory subidentifiers, where the primary cost method is not 2.

Each branch is tagged with an APPLICATION_ID indicating the owning application: 200 for purchasing (suppliers), 222 for receivables (customers), and 401 for inventory. The ETRM metadata records that no base objects are formally documented for this view, so the relationship is expressed only through the view text itself. Note that the documentation states the view is "not implemented in this database," meaning it may not exist in every environment even though its definition is shipped.

Key Columns

• APPLICATION_ID — identifies the source application of the row (200 = supplier, 222 = customer, 401 = inventory).
• THIRD_PARTY_ID — the supplier ID, customer ID, or organization ID that owns the subidentifier.
• SUB_ID — the specific subidentifier key: VENDOR_SITE_ID, SITE_USE_ID, SECONDARY_INVENTORY_ID, or the -999 placeholder.
• SUB_NAME — the descriptive name: VENDOR_SITE_CODE, concatenated customer address components, secondary inventory name, or the unidentified lookup meaning.
• ORG_ID — the operating unit identifier, or NULL for the unidentified branches.
• ORG_NAME — the operating unit name from HR_ORGANIZATION_UNITS; this is the column most commonly searched for and may be NULL where no matching organization exists.

Common Use Cases and Queries

The most frequent use is resolving a subidentifier to its name and owning operating unit for reporting or reconciliation. A representative query is:

SELECT third_party_id, sub_id, sub_name, org_id, org_name FROM ax_orgs_subs_v WHERE UPPER(org_name) LIKE UPPER('%:org_name%');

Analysts also filter by APPLICATION_ID to isolate suppliers or customers, join THIRD_PARTY_ID back to PO_VENDORS or RA_CUSTOMERS for detail, and use the unidentified (-999) rows to detect transactions that reference parties without a defined site. All queries should anticipate NULL ORG_NAME values resulting from the outer join to HR_ORGANIZATION_UNITS.