eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AMS_DM_SCORE_HISTORY_V

Object Details

Object Name:	AMS_DM_SCORE_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_DM_SCORE_HISTORY_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE_ID	NUMBER		Yes	Unique identifier.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
PARTY_ID	NUMBER		Yes	Reference identifier for the unique identifier of the data source used by the model or scoring run.
CONTINUOUS_SCORE	NUMBER			The probability that the scoring results is positive in percentage.
DECILE	NUMBER			Deciles by probability of a positive score.
PERCENTILE	NUMBER			The percentile for the probability of a positive score.
SCORE_ID	NUMBER		Yes	Unique identifier for a scoring run.
SCORE_NAME	VARCHAR2	(120)	Yes	Name of the model scoring instance.
MODEL_ID	NUMBER		Yes	Foreign key reference to the model which was used for scoring.
MODEL_NAME	VARCHAR2	(120)	Yes	Name of the model to bused by Marketing users to identify models.
MODEL_TYPE_CODE	VARCHAR2	(30)	Yes	Type of model used to indicate the mining algorithm.
MODEL_TYPE_MEANING	VARCHAR2	(80)	Yes	Descriptive text for the model type.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SOURCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      PARTY_ID
,      CONTINUOUS_SCORE
,      DECILE
,      PERCENTILE
,      SCORE_ID
,      SCORE_NAME
,      MODEL_ID
,      MODEL_NAME
,      MODEL_TYPE_CODE
,      MODEL_TYPE_MEANING
FROM APPS.AMS_DM_SCORE_HISTORY_V;

Dependencies

[top of page]

APPS.AMS_DM_SCORE_HISTORY_V references the following:

APPS: AMS_DM_MODELS_ALL_B; AMS_DM_MODELS_ALL_TL; AMS_DM_SCORES_ALL_B; AMS_DM_SCORES_ALL_TL; AMS_DM_SOURCE; AMS_LOOKUPS

APPS.AMS_DM_SCORE_HISTORY_V is not referenced by any database object