VIEW: APPS.AMS_DS_SCORES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'