VIEW: APPS.CSC_PROFILE_CATEGORY_DB_V

Source

View Text - Preformatted

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 ,null check_level , -1 party_site_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 ,cks.check_level check_level , res.party_site_id party_site_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)

View Text - HTML Formatted

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
, NULL CHECK_LEVEL
, -1 PARTY_SITE_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
, CKS.CHECK_LEVEL CHECK_LEVEL
, RES.PARTY_SITE_ID PARTY_SITE_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)