VIEW: APPS.IGS_PR_COHORT_INST_V

Source

View Text - Preformatted

SELECT cohi.rowid , cohi.cohort_name , cohi.load_cal_type , cohi.load_ci_sequence_number , ci.start_dt , ci.end_dt , ci.description , cohi.cohort_status , lkv.meaning , cohi.rank_status , lkv1.meaning , cohi.run_date , cohi.created_by , cohi.creation_date , cohi.last_updated_by , cohi.last_update_date , cohi.last_update_login , cohi.request_id , cohi.program_application_id , cohi.program_id , cohi.program_update_date FROM IGS_PR_cohort_inst cohi, igs_lookup_values lkv , igs_lookup_values lkv1, igs_ca_inst ci WHERE cohi.cohort_status = lkv.lookup_code AND lkv.lookup_type = 'COHORT_STATUS' AND cohi.rank_status = lkv1.lookup_code AND lkv1.lookup_type = 'RANK_STATUS' AND cohi.load_cal_type = ci.cal_type AND cohi.load_ci_sequence_number = ci.sequence_number

View Text - HTML Formatted

SELECT COHI.ROWID
, COHI.COHORT_NAME
, COHI.LOAD_CAL_TYPE
, COHI.LOAD_CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.DESCRIPTION
, COHI.COHORT_STATUS
, LKV.MEANING
, COHI.RANK_STATUS
, LKV1.MEANING
, COHI.RUN_DATE
, COHI.CREATED_BY
, COHI.CREATION_DATE
, COHI.LAST_UPDATED_BY
, COHI.LAST_UPDATE_DATE
, COHI.LAST_UPDATE_LOGIN
, COHI.REQUEST_ID
, COHI.PROGRAM_APPLICATION_ID
, COHI.PROGRAM_ID
, COHI.PROGRAM_UPDATE_DATE
FROM IGS_PR_COHORT_INST COHI
, IGS_LOOKUP_VALUES LKV
, IGS_LOOKUP_VALUES LKV1
, IGS_CA_INST CI
WHERE COHI.COHORT_STATUS = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'COHORT_STATUS'
AND COHI.RANK_STATUS = LKV1.LOOKUP_CODE
AND LKV1.LOOKUP_TYPE = 'RANK_STATUS'
AND COHI.LOAD_CAL_TYPE = CI.CAL_TYPE
AND COHI.LOAD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER