VIEW: APPS.CSC_PROF_RESULTS_V

Source

View Text - Preformatted

SELECT res.check_id , res.party_id , res.cust_account_id , res.rating_code , res.color_code ,res.created_by ,res.creation_date ,res.last_updated_by ,res.last_update_date ,res.last_update_login ,res.currency_code ,res.value ,res.grade ,gc.group_id ,gc.check_sequence ,gc.threshold_flag ,gc.category_code ,res.results_threshold_flag ,gc.category_sequence ,chk.check_name ,chk.select_type ,chk.format_mask ,chk.threshold_grade ,chk.threshold_rating_code ,chk.threshold_color_code FROM csc_prof_checks_vl chk ,csc_prof_group_checks gc ,csc_prof_check_results res WHERE gc.check_id = chk.check_id AND ( Sysdate BETWEEN Nvl(chk.start_date_active,Sysdate) AND Nvl(chk.end_date_active,Sysdate) ) AND res.check_id = chk.check_id

View Text - HTML Formatted

SELECT RES.CHECK_ID
, RES.PARTY_ID
, RES.CUST_ACCOUNT_ID
, RES.RATING_CODE
, RES.COLOR_CODE
, RES.CREATED_BY
, RES.CREATION_DATE
, RES.LAST_UPDATED_BY
, RES.LAST_UPDATE_DATE
, RES.LAST_UPDATE_LOGIN
, RES.CURRENCY_CODE
, RES.VALUE
, RES.GRADE
, GC.GROUP_ID
, GC.CHECK_SEQUENCE
, GC.THRESHOLD_FLAG
, GC.CATEGORY_CODE
, RES.RESULTS_THRESHOLD_FLAG
, GC.CATEGORY_SEQUENCE
, CHK.CHECK_NAME
, CHK.SELECT_TYPE
, CHK.FORMAT_MASK
, CHK.THRESHOLD_GRADE
, CHK.THRESHOLD_RATING_CODE
, CHK.THRESHOLD_COLOR_CODE
FROM CSC_PROF_CHECKS_VL CHK
, CSC_PROF_GROUP_CHECKS GC
, CSC_PROF_CHECK_RESULTS RES
WHERE GC.CHECK_ID = CHK.CHECK_ID
AND ( SYSDATE BETWEEN NVL(CHK.START_DATE_ACTIVE
, SYSDATE)
AND NVL(CHK.END_DATE_ACTIVE
, SYSDATE) )
AND RES.CHECK_ID = CHK.CHECK_ID