[Home] [Help]
View: CSC_PROFILE_CATEGORY_DB_V
View Text
SELECT L.MEANING CATEGORY_CHECK_NAME
, GC.CATEGORY_SEQUENCE CATEGORY_SEQUENCE
, -1 CHECK_SEQUENCE
, NULL CHECK_ID
, NULL CURRENCY_CODE
, NULL VALUE
, NULL GRADE
, -1 PARTY_ID
, -1 CUST_ACCOUNT_ID
, 'P' PARTY_TYPE
, '1' SEQUENCE
, NULL THRESHOLD_FLAG
, NULL RESULTS_THRESHOLD_FLAG
, GC.GROUP_ID DASHBOARD_GROUP_ID FROM CSC_PROF_GROUP_CATEGORIES GC
, CSC_LOOKUPS L
WHERE L.LOOKUP_CODE = GC.CATEGORY_CODE AND L.LOOKUP_TYPE = 'CSC_PROF_CATEGORIES' UNION ALL SELECT CKS.CHECK_NAME CATEGORY_CHECK_NAME
, GC.CATEGORY_SEQUENCE CATEGORY_SEQUENCE
, GCKS.CHECK_SEQUENCE CHECK_SEQUENCE
, TO_CHAR(CKS.CHECK_ID) CHECK_ID
, RES.CURRENCY_CODE CURRENCY_CODE
, RES.VALUE VALUE
, RES.GRADE GRADE
, RES.PARTY_ID PARTY_ID
, RES.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, 'P' PARTY_TYPE
, '2' SEQUENCE
, GCKS.THRESHOLD_FLAG THRESHOLD_FLAG
, RES.RESULTS_THRESHOLD_FLAG RESULTS_THRESHOLD_FLAG
, GCKS.GROUP_ID DASHBOARD_GROUP_ID FROM CSC_PROF_CHECKS_VL CKS
, CSC_PROF_GROUP_CATEGORIES GC
, CSC_PROF_GROUP_CHECKS GCKS
, CSC_PROF_CHECK_RESULTS RES WHERE CKS.CHECK_ID = GCKS.CHECK_ID AND CKS.CHECK_ID = RES.CHECK_ID AND GCKS.GROUP_ID = GC.GROUP_ID AND GCKS.CATEGORY_CODE = GC.CATEGORY_CODE AND SYSDATE BETWEEN NVL( GCKS.START_DATE_ACTIVE
, SYSDATE )
AND NVL( GCKS.END_DATE_ACTIVE
, SYSDATE)
Columns
Name |
CATEGORY_CHECK_NAME |
CATEGORY_SEQUENCE |
CHECK_SEQUENCE |
CHECK_ID |
CURRENCY_CODE |
VALUE |
GRADE |
PARTY_ID |
CUST_ACCOUNT_ID |
PARTY_TYPE |
SEQUENCE |
THRESHOLD_FLAG |
RESULTS_THRESHOLD_FLAG |
DASHBOARD_GROUP_ID |