Results for “pos_primary_pay”

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

Overview

The view APPS.POS_SUPP_PROF_EXT_OCV is a seeded Oracle E-Business Suite database object associated with the Oracle iSupplier Portal / Sourcing supplier profile extension framework. Its name follows the EBS convention for "Open Candidate Values" (OCV) views: it returns the permissible values that may be presented to users when building or configuring supplier profile extension attributes. The view is a UNION ALL construct that aggregates lookup codes, descriptive meanings, geographic territories, and application messages into a single normalized result set of code, language, and meaning columns.

Because it draws from FND lookup infrastructure, the view is fully multilingual. Every branch of the union filters on userenv('LANG'), ensuring that values returned match the session language of the connected user. This makes the view suitable for both transactional form rendering and reporting/integration scenarios where a flattened, language-aware list of candidate values is required. It is commonly surfaced through iSupplier Portal and Sourcing setup pages that let administrators select base supplier profile attributes, business classifications, and payment-related types.

Underlying Base Objects

The documented dependents of this view, per ETRM 12.2.2, are:

• FND_LOOKUP_VALUES (synonym) — supplies base supplier profile extensions (POS_SUPP_PROF_EXT_BASE), vendor types (VENDOR TYPE, view application 201), and business classifications (POS_BUSINESS_CLASSIFICATIONS), each prefixed with a literal tag such as BS:, ST:, or BC:.
• HZ_CLASS_CATEGORIES (synonym) — joined to FND_LOOKUP_VALUES where view_application_id = 222 to enumerate Trading Community class categories, prefixed HZ:.
• FND_TERRITORIES_TL (synonym) — provides territory codes and short names, prefixed AC:.
• FND_NEW_MESSAGES (synonym) — retrieves message text for payment and purchasing-related messages such as POS_PAY_NEW, POS_HT_B_PURCHASING, PON_AUC_NEG_R, PON_AUCTS_PAY_PROC_CARD, and POS_PRIMARY_PAY, prefixed AP:.
• POS_PRODUCT_SERVICE_UTL_PKG (package) and SYS_PLSQL_B4736A10_495_1 (type) — ETRM-documented dependencies supporting the view's construction.

Key Columns

• code — a composite, tagged identifier. Prefixes (BS:, ST:, BC:, HZ:, AC:, AP:) identify the originating source category, allowing consumers to distinguish suppliers, vendor types, classifications, territories, and application messages.
• language — the language of the returned row, driven by userenv('LANG') (or the FND_NEW_MESSAGES language_code column). The user's search term language_code corresponds directly to this filter; note the FND_NEW_MESSAGES branches alias language_code as language.
• meaning — the human-readable display value: lookup meaning, territory short name, or message text.

Common Use Cases and Queries

Typical uses include populating LOVs during supplier profile extension setup, validating candidate values before insertion, and generating multilingual reports of permissible values.

Retrieve all candidate values for the current session language:

• SELECT code, language, meaning FROM apps.pos_supp_prof_ext_ocv ORDER BY code;

Isolate only business classification candidates:

• SELECT code, meaning FROM apps.pos_supp_prof_ext_ocv WHERE code LIKE 'BC:%';

Filter by a specific language (when running outside a userenv-based session):

• SELECT code, meaning FROM apps.pos_supp_prof_ext_ocv WHERE language = 'US';