Search Results amw_organization

Overview

APPS.RCI_BP_CERT_RESULT_V is a reporting view in Oracle E-Business Suite (12.1.1 and 12.2.2) that consolidates the valid certification result codes available for the AMW_ORGANIZATION object. It is part of the Oracle Applications "AMW" (Application Management Workbench / certification) data model, which stores opinion and certification configuration used by the RCI (Regulatory/Compliance Integration) certification evaluation logic. The view returns a normalized two-column result set of ID and VALUE pairs describing the certification opinion values that apply to an organization, plus a hardcoded fallback status of "NOT_CERTIFIED".

Its role is chiefly as a lookup source: instead of hardcoding certification result codes, downstream reports, concurrent programs, LOVs, and integrations reference this view to obtain the currently effective certification values. Because the query filters on userenv('LANG'), the returned VALUE is language-sensitive, making the view suitable for multilingual reporting.

Underlying Base Objects

The view is defined by a UNION ALL of two logical blocks, both of which resolve to AMW and FND tables:

• AMW_OPINION_VALUES_B — certification opinion value definitions (drives the ID column via OPINION_VALUE_CODE).
• AMW_OPINION_VALUES_TL — translated opinion value names, joined on OPINION_VALUE_ID and LANGUAGE = userenv('LANG').
• AMW_OPINION_COMPONTS_B — links opinion components to object opinion types.
• AMW_OBJECT_OPINION_TYPES — associates object opinion types with specific FND objects.
• AMW_OPINION_TYPES_B — opinion type definitions; filtered to OPINION_TYPE_CODE = 'CERTIFICATION'.
• FND_OBJECTS — the registered object registry; filtered to OBJ_NAME = 'AMW_ORGANIZATION', which is precisely what ties this view to the searched term amw_organization.
• AMW_LOOKUPS — second UNION branch, supplying the static "NOT_CERTIFIED" value from lookup type RCI_CERT_EVAL_STATUS.

No other base objects are documented for this view in the ETRM 12.2.2 metadata; the external references above are inherited from the view definition text, not from a separately documented object list.

Key Columns

• ID — the certification result code. Sourced from AMW_OPINION_VALUES_B.OPINION_VALUE_CODE for the primary branch, and from AMW_LOOKUPS.LOOKUP_CODE for the fallback not-certified row.
• VALUE — the human-readable, language-dependent meaning. Sourced from AMW_OPINION_VALUES_TL.OPINION_VALUE_NAME for the primary branch, and from AMW_LOOKUPS.MEANING for the fallback row.

Note that the view exposes only these two columns; all join and filter predicates are internal. Date effectiveness is enforced through (b.END_DATE is null or b.END_DATE >= sysdate), so only currently active opinion values are returned.

Common Use Cases and Queries

Typical scenarios include populating certification result LOVs, joining evaluation results to descriptive labels, and validating that a stored certification code still exists in the effective set.

• Retrieve all effective certification results for organization certification:

SELECT id, value
FROM   apps.rci_bp_cert_result_v
ORDER BY value;

• Resolve a stored certification code to its display label:

SELECT r.value
FROM   apps.rci_bp_cert_result_v r
WHERE  r.id = :p_certification_code;

• Identify the not-certified fallback row specifically:

SELECT id, value
FROM   apps.rci_bp_cert_result_v
WHERE  id = 'NOT_CERTIFIED';

Because VALUE is language-sensitive, ensure the session language (userenv('LANG')) is set appropriately before querying, particularly in concurrent programs and multi-language reporting integrations.