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_DS_SCORES_V

Object Details

Object Name:	AMS_DS_SCORES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_DS_SCORES_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
SCORE_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
MODEL_TYPE	VARCHAR2	(30)	Yes	Type of model used to indicate the mining algorithm.
USED_FOR_OBJECT_ID	NUMBER		Yes	Foreign key reference to the object which the source is used for.
ARC_USED_FOR_OBJECT	VARCHAR2	(30)	Yes	Identifies the type of object which the source is used for.
PARTY_ID	NUMBER		Yes	Reference identifier for the unique identifier of the data source used by the model or scoring run.
MODEL_NAME	VARCHAR2	(120)	Yes	Name of the model to bused by Marketing users to identify models.
DECILE	NUMBER			Binned summary for the probability of a positive score.
SOURCE_ID	NUMBER		Yes	The response predicted by the tree node.
MODEL_ID	NUMBER		Yes	Foreign key reference to the model which was used for scoring.
SCORE_NAME	VARCHAR2	(120)	Yes	Name of the model scoring instance.
CONTINUOUS_SCORE	NUMBER			The probability that the scoring results is positive in percentage.

Query Text

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


SELECT SCORE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      MODEL_TYPE
,      USED_FOR_OBJECT_ID
,      ARC_USED_FOR_OBJECT
,      PARTY_ID
,      MODEL_NAME
,      DECILE
,      SOURCE_ID
,      MODEL_ID
,      SCORE_NAME
,      CONTINUOUS_SCORE
FROM APPS.AMS_DS_SCORES_V;

Dependencies

[top of page]

APPS.AMS_DS_SCORES_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

APPS.AMS_DS_SCORES_V is not referenced by any database object