VIEW: APPS.CSC_CUSTOMER_PROFILE_DB_V

Source

View Text - Preformatted

SELECT res.check_id , res.party_id , res.cust_account_id , res.created_by , res.creation_date , res.last_updated_by , res.last_update_date , res.last_update_login , res.currency_code , res.value , gc.threshold_flag , res.results_threshold_flag , res.grade , gcat.category_code , gc.check_sequence , gcat.category_sequence , chk.check_name , mod.party_type , mod.dashboard_group_id , mod.module_group_id FROM csc_prof_checks_vl chk ,csc_prof_group_checks_v gc ,csc_prof_check_results res ,csc_prof_module_groups_v mod ,csc_prof_group_categories gcat WHERE gc.category_code = gcat.category_code and mod.dashboard_group_id = gcat.group_id and mod.dashboard_group_id = gc.group_id AND gc.check_id = chk.check_id AND ( Sysdate BETWEEN Nvl(gc.start_date_active,Sysdate) AND Nvl(gc.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.CREATED_BY
, RES.CREATION_DATE
, RES.LAST_UPDATED_BY
, RES.LAST_UPDATE_DATE
, RES.LAST_UPDATE_LOGIN
, RES.CURRENCY_CODE
, RES.VALUE
, GC.THRESHOLD_FLAG
, RES.RESULTS_THRESHOLD_FLAG
, RES.GRADE
, GCAT.CATEGORY_CODE
, GC.CHECK_SEQUENCE
, GCAT.CATEGORY_SEQUENCE
, CHK.CHECK_NAME
, MOD.PARTY_TYPE
, MOD.DASHBOARD_GROUP_ID
, MOD.MODULE_GROUP_ID
FROM CSC_PROF_CHECKS_VL CHK
, CSC_PROF_GROUP_CHECKS_V GC
, CSC_PROF_CHECK_RESULTS RES
, CSC_PROF_MODULE_GROUPS_V MOD
, CSC_PROF_GROUP_CATEGORIES GCAT
WHERE GC.CATEGORY_CODE = GCAT.CATEGORY_CODE
AND MOD.DASHBOARD_GROUP_ID = GCAT.GROUP_ID
AND MOD.DASHBOARD_GROUP_ID = GC.GROUP_ID
AND GC.CHECK_ID = CHK.CHECK_ID
AND ( SYSDATE BETWEEN NVL(GC.START_DATE_ACTIVE
, SYSDATE)
AND NVL(GC.END_DATE_ACTIVE
, SYSDATE) )
AND RES.CHECK_ID = CHK.CHECK_ID