Search Results ams_dm_models_v




Overview
Explore in AI Chat

Overview

AMS_DM_MODELS_V is a denormalized reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the AMS (Marketing) product family. It presents data mining model definitions and their associated descriptive metadata in a single flattened result set, joining base model records to their translated names and descriptions, lookup meanings, resource identities, target definitions, and list source type descriptions. The view is available in both EBS 12.1.1 and 12.2.2 and is marked VALID in the ETRM repository.

Because the underlying data mining tables store multilingual text in separate base (_B) and translation (_TL) tables, direct reporting against the base tables requires multiple joins plus explicit language filtering. AMS_DM_MODELS_V removes that burden by resolving every translated attribute against the session language through USERENV('LANG'), making it suitable for concurrent programs, OAF pages, Oracle Reports, and integration extracts that require model metadata in the user's preferred language.

Underlying Base Objects

The documented base objects referenced by the view are: AMS_DM_MODELS_ALL_B, AMS_DM_MODELS_ALL_TL, AMS_DM_TARGETS_B, AMS_DM_TARGETS_TL, AMS_LIST_SRC_TYPES_TL, AMS_USER_STATUSES_TL, JTF_RS_RESOURCE_EXTNS_TL, FND_LOOKUP_VALUES, and the FND_GLOBAL package. Each is accessed through an APPS synonym, so the view is only valid when queried from a session whose language and security context are initialized by FND_GLOBAL.

  • AMS_DM_MODELS_ALL_B — primary source of model rows; supplies MODEL_ID and all operational/configuration columns.
  • AMS_DM_MODELS_ALL_TL — provides MODEL_NAME and DESCRIPTION filtered by session language.
  • AMS_DM_TARGETS_B / AMS_DM_TARGETS_TL — supply TARGET_NAME and validate the target relationship.
  • AMS_USER_STATUSES_TL — resolves USER_STATUS_ID to a translated status name (USRT.NAME).
  • JTF_RS_RESOURCE_EXTNS_TL — resolves OWNER_USER_ID to RESOURCE_NAME.
  • FND_LOOKUP_VALUES — resolves MODEL_TYPE to its meaning via lookup type AMS_DM_MODEL_TYPE, restricted to VIEW_APPLICATION_ID 530 and language/security group filters.
  • AMS_LIST_SRC_TYPES_TL — supplies the list source type identifier and name.
  • FND_GLOBAL — invoked through FND_GLOBAL.LOOKUP_SECURITY_GROUP to enforce lookup security at query time.

Key Columns

Common Use Cases and Queries

The view supports model inventory listings, status dashboards, and metadata extracts for downstream analytics. A typical query filters by status and orders by build date:

  • SELECT MODEL_ID, MODEL_NAME, MEANING, NAME, RESOURCE_NAME, LAST_BUILD_DATE FROM AMS_DM_MODELS_V WHERE STATUS_CODE = 'ACTIVE' ORDER BY LAST_BUILD_DATE DESC;
  • SELECT MODEL_NAME, TARGET_NAME, TOTAL_RECORDS, TOTAL_POSITIVES, PERFORMANCE FROM AMS_DM_MODELS_V WHERE ORG_ID = :p_org_id;
  • SELECT MODEL_ID, MODEL_NAME, RESOURCE_NAME FROM AMS_DM_MODELS_V WHERE OWNER_USER_ID = :p_user_id;

Because the view applies USERENV('LANG') predicates internally, callers must not append language filters of their own; doing so can eliminate all rows if the session language does not match the requested code. Applications should also run under a valid FND_GLOBAL session so the lookup security group resolves correctly.