Product: | AMS - Marketing |
---|---|
Description: | View to be used to identify the score and the model used for a scoring run for a specific party. |
Implementation/DBA Data: | APPS.AMS_DM_SCORE_HISTORY_V |
SELECT SRC.SOURCE_ID
, SRC.LAST_UPDATE_DATE
, SRC.LAST_UPDATED_BY
, SRC.CREATION_DATE
, SRC.CREATED_BY
, SRC.LAST_UPDATE_LOGIN
, SRC.SECURITY_GROUP_ID
, SRC.PARTY_ID
, SRC.CONTINUOUS_SCORE
, SRC.DECILE
, SRC.PERCENTILE
, SCORE.SCORE_ID
, SCORE_TL.SCORE_NAME
, SCORE.MODEL_ID
, MODEL_TL.MODEL_NAME
, MODEL.MODEL_TYPE MODEL_TYPE_CODE
, TYPELK.MEANING MODEL_TYPE_MEANING
FROM AMS_DM_SOURCE SRC
, AMS_DM_MODELS_ALL_B MODEL
, AMS_DM_MODELS_ALL_TL MODEL_TL
, AMS_DM_SCORES_ALL_B SCORE
, AMS_DM_SCORES_ALL_TL SCORE_TL
, AMS_LOOKUPS TYPELK
WHERE SCORE.SCORE_ID = SRC.USED_FOR_OBJECT_ID
AND SRC.ARC_USED_FOR_OBJECT = 'SCOR'
AND SCORE_TL.SCORE_ID = SCORE.SCORE_ID
AND SCORE_TL.LANGUAGE = USERENV ('LANG')
AND MODEL.MODEL_ID = SCORE.MODEL_ID
AND MODEL_TL.MODEL_ID = MODEL.MODEL_ID
AND MODEL_TL.LANGUAGE = USERENV ('LANG')
AND TYPELK.LOOKUP_TYPE = 'AMS_DM_MODEL_TYPE'
AND TYPELK.LOOKUP_CODE = MODEL.MODEL_TYPE