VIEW: APPS.AMS_DM_SCORE_HISTORY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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