Product: | CSC - Customer Care |
---|---|
Description: | Internal View used in Profile form |
Implementation/DBA Data: | APPS.CSC_CUSTOMER_PROFILE_V |
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
, 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
, MOD.PARTY_TYPE
, MOD.FORM_FUNCTION_ID
, MOD.FORM_FUNCTION_NAME
FROM CSC_PROF_CHECKS_VL CHK
, CSC_PROF_GROUP_CHECKS_V GC
, CSC_PROF_CHECK_RESULTS RES
, CSC_PROF_MODULE_GROUPS_V MOD
WHERE MOD.GROUP_ID = GC.GROUP_ID
AND MOD.DASHBOARD_GROUP_FLAG IS NULL
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