Search Results zip_code

Overview

POS_ORG_ADDRESS_V is a public, VALID view owned by the APPS schema within the Oracle Purchasing (PO) product family. It exposes the organizational address information stored for inventory organizations defined in Oracle E-Business Suite, presenting a flattened, reporting-friendly projection of the MTL_ORGANIZATIONS data. Its principal role is to provide Purchasing and related modules with a single, consistently formatted source of organization identity and address data without requiring callers to join or parse the underlying organization tables directly.

Because the view includes both the raw address components and a pre-concatenated city/state/zip string, it is frequently consumed by reports, concurrent programs, Oracle Discoverer workbooks, and external integrations that need to display or exchange ship-to and organizational address information. The ZIP_CODE column is of particular interest to users searching this object, as it is the primary postal identifier surfaced by the view.

Underlying Base Objects

The documented metadata for release 12.2.2 identifies the referenced base objects as:

• MTL_ORGANIZATIONS (VIEW) — the primary source of the organization and address columns.
• HR_GENERAL (PACKAGE) — Oracle HRMS general utilities, invoked for organization-related context and security evaluation.
• HR_SECURITY (PACKAGE) — the HRMS security package that governs organization-level access restrictions.

The view text is a simple SELECT against MTL_ORGANIZATIONS, projecting ORGANIZATION_ID, ORGANIZATION_CODE, ORGANIZATION_NAME, the three address lines (ADDRESS1, ADDRESS2, ADDRESS3), CITY, STATE, COUNTRY, ZIP_CODE, a concatenated CITY_STATE_ZIP expression, SET_OF_BOOKS_ID, SET_OF_BOOKS_NAME, SYMBOL, ORG_INFO, and VALUE. The presence of HR_GENERAL and HR_SECURITY reflects that organizational visibility may be filtered through HRMS security profiles, meaning a user's access to specific organizations can affect the rows returned.

Key Columns

• ORGANIZATION_ID — the unique inventory organization identifier; the primary key for joining to other PO and INV objects.
• ORGANIZATION_CODE / ORGANIZATION_NAME — the short code and descriptive name of the organization.
• ADDRESS1, ADDRESS2, ADDRESS3 — the street address lines.
• CITY, STATE, COUNTRY — the locality, region, and country components.
• ZIP_CODE — the postal or ZIP code for the organization address.
• CITY_STATE_ZIP — a derived expression concatenating city, state, and ZIP code with a comma and space delimiter for display purposes.
• SET_OF_BOOKS_ID / SET_OF_BOOKS_NAME — the ledger associated with the organization, supporting financial reporting context.
• SYMBOL, ORG_INFO, VALUE — supporting descriptive and reference attributes carried from the base object.

Common Use Cases and Queries

Typical scenarios include organization address lookups for purchase order reports, ship-to validation, and integrations exporting organization master data. The following example retrieves organization identity and postal information by ZIP code:

• SELECT organization_id, organization_code, organization_name, city, state, zip_code
• FROM apps.pos_org_address_v
• WHERE zip_code LIKE '90%';

A second common pattern uses the display column for report output:

• SELECT organization_name, city_state_zip
• FROM apps.pos_org_address_v
• WHERE organization_id = :p_org_id;

Because the view is defined over MTL_ORGANIZATIONS and subject to HRMS security, queries should be run under an application responsibility or a user with appropriate organization access to ensure the expected rows are visible. Filtering on ZIP_CODE is efficient only when it is applied alongside organization restrictions, since the view is not indexed independently but inherits the indexing of its base object.