Search Results amw_key_account

Overview

APPS.RCI_FS_ACCT_EVAL_V is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments that is associated with the Oracle Application Management Workbench (AMW)/Enterprise Tax and Reporting Management (ETRM) modules. This view exposes evaluation opinion values and the associated configuration object names, and it also includes a synthetic row representing the "Not Evaluated" status for a certification evaluation lookup. The view serves as a flattened, business-friendly access layer over the underlying AMW opinion configuration tables, allowing reporting tools and integration routines to retrieve evaluation-related values without directly navigating the normalized AMW schema.

Because the view is defined as a UNION of an opinion-values query and a lookup-code query, it presents a unified enumeration of possible evaluation results, including both configured opinion values and the special "NOT_EVALUATED" status. This makes the view useful whenever a report, screen, or integration must present a complete list of evaluation outcomes for a given object.

Underlying Base Objects

The view is defined over several AMW configuration tables and one FND table:

• AMW_OPINION_VALUES_B — base table holding opinion value definitions, including OPINION_VALUE_CODE and OPINION_VALUE_ID.
• AMW_OPINION_VALUES_TL — translated table providing the language-dependent OPINION_VALUE_NAME; joined using USERENV('LANG') so the caller's session language is applied.
• AMW_OPINION_COMPONTS_B — opinion component definitions; the join constrains OPINION_COMPONENT_CODE to 'OVERALL'.
• AMW_OPINION_TYPES_B — opinion type definitions; the query filters OPINION_TYPE_CODE = 'EVALUATION'.
• AMW_OBJECT_OPINION_TYPES — association table linking opinion types to objects via OBJECT_OPINION_TYPE_ID and OBJECT_ID.
• FND_OBJECTS — the EBS object registry; supplies OBJ_NAME through the join on OBJECT_ID.
• AMW_LOOKUPS — lookup table; the UNION branch selects the LOOKUP_CODE ('NOT_EVALUATED') and MEANING where LOOKUP_TYPE = 'RCI_CERT_EVAL_STATUS'.

The documented ETRM metadata states that no referenced base objects are formally documented, so the relationships above are derived directly from the view definition text.

Key Columns

• ID — the identifier of the evaluation value. It is the OPINION_VALUE_CODE for configured opinion values, or the lookup code (for example, 'NOT_EVALUATED') for the union branch.
• VALUE — the human-readable, language-dependent name of the opinion value (OPINION_VALUE_NAME), or the lookup MEANING for the union branch.
• OBJ_NAME — the name of the associated FND object for configured opinion values; for the union branch, this is hard-coded as 'AMW_KEY_ACCOUNT'.

The hard-coded 'AMW_KEY_ACCOUNT' value in the union branch is meaningful for users searching on that term: the synthetic "NOT_EVALUATED" evaluation status row is attributed to the AMW_KEY_ACCOUNT object name.

Common Use Cases and Queries

Typical usages include populating LOVs or value sets with evaluation results, reporting on configured evaluation opinions per object, and retrieving the enumerated set of possible evaluation outcomes.

• List all evaluation values and their object names:
  SELECT id, value, obj_name FROM apps.rci_fs_acct_eval_v;
• Filter to the key-account "Not Evaluated" status row:
  SELECT * FROM apps.rci_fs_acct_eval_v WHERE obj_name = 'AMW_KEY_ACCOUNT';
• Find evaluation values for a specific object name:
  SELECT id, value FROM apps.rci_fs_acct_eval_v WHERE obj_name = :obj_name;

Because the view applies USERENV('LANG'), results are returned in the language of the execution session, which is important for multilingual deployments.