VIEW: APPS.CSC_PROF_GROUP_CHECKS_V

Source

View Text - Preformatted

SELECT a. rowid ROW_ID , a.group_id , a.check_id , b.check_name , a.check_sequence , a.end_date_active , a.start_date_active , a.category_code , a.category_sequence , a.threshold_flag , a.created_by , a.creation_date , a.last_updated_by , a.last_update_date , a.last_update_login FROM csc_prof_group_checks a, csc_prof_checks_tl b WHERE a.check_id = b.check_id

View Text - HTML Formatted

SELECT A. ROWID ROW_ID
, A.GROUP_ID
, A.CHECK_ID
, B.CHECK_NAME
, A.CHECK_SEQUENCE
, A.END_DATE_ACTIVE
, A.START_DATE_ACTIVE
, A.CATEGORY_CODE
, A.CATEGORY_SEQUENCE
, A.THRESHOLD_FLAG
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM CSC_PROF_GROUP_CHECKS A
, CSC_PROF_CHECKS_TL B
WHERE A.CHECK_ID = B.CHECK_ID