View: AMS_DS_SCORES_V

Product:	AMS - Marketing
Description:
Implementation/DBA Data:	APPS.AMS_DS_SCORES_V

View Text

SELECT B.SCORE_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, MB.MODEL_TYPE
, ADS.USED_FOR_OBJECT_ID
, ADS.ARC_USED_FOR_OBJECT
, ADS.PARTY_ID
, MT.MODEL_NAME
, ADS.DECILE
, ADS.SOURCE_ID
, B.MODEL_ID
, T.SCORE_NAME
, ADS.CONTINUOUS_SCORE
FROM AMS_DM_SCORES_ALL_B B
, AMS_DM_SCORES_ALL_TL T
, AMS_DM_MODELS_ALL_B MB
, AMS_DM_MODELS_ALL_TL MT
, AMS_DM_SOURCE ADS
WHERE B.SCORE_ID = T.SCORE_ID
AND T.LANGUAGE = USERENV ('LANG')
AND MB.MODEL_ID = B.MODEL_ID
AND MB.MODEL_ID = MT.MODEL_ID
AND MT.LANGUAGE = USERENV ('LANG')
AND ADS.USED_FOR_OBJECT_ID = B.SCORE_ID
AND ADS.ARC_USED_FOR_OBJECT ='SCOR'

Columns