VIEW: APPS.IGS_PR_COHORT_V

Source

View Text - Preformatted

SELECT coh.rowid, coh.cohort_name , coh.description , coh.org_unit_cd , ou.description , coh.stat_type , pst.description , coh.timeframe, lkv1.meaning, coh.dflt_display_type , lkv.meaning , coh.dense_rank_ind , coh.INCL_ON_TRANSCRIPT_IND , coh.INCL_ON_STUD_ACAD_HIST_IND, coh.rule_sequence_number , igs_ru_gen_003.rulp_get_rule(coh.rule_sequence_number), coh.closed_ind , coh.created_by , coh.creation_date , coh.last_updated_by , coh.last_update_date , coh.last_update_login FROM IGS_PR_cohort coh, igs_or_unit ou, igs_pr_stat_type pst, igs_lookup_values lkv, igs_lookup_values lkv1 WHERE coh.org_unit_cd = ou.org_unit_cd (+) AND coh.stat_type = pst.stat_type AND coh.dflt_display_type = lkv.lookup_code AND lkv.lookup_type = 'DFLT_DISPLAY_TYPE' AND coh.timeframe = lkv1.lookup_code AND lkv1.lookup_type = 'TIMEFRAME'

View Text - HTML Formatted

SELECT COH.ROWID
, COH.COHORT_NAME
, COH.DESCRIPTION
, COH.ORG_UNIT_CD
, OU.DESCRIPTION
, COH.STAT_TYPE
, PST.DESCRIPTION
, COH.TIMEFRAME
, LKV1.MEANING
, COH.DFLT_DISPLAY_TYPE
, LKV.MEANING
, COH.DENSE_RANK_IND
, COH.INCL_ON_TRANSCRIPT_IND
, COH.INCL_ON_STUD_ACAD_HIST_IND
, COH.RULE_SEQUENCE_NUMBER
, IGS_RU_GEN_003.RULP_GET_RULE(COH.RULE_SEQUENCE_NUMBER)
, COH.CLOSED_IND
, COH.CREATED_BY
, COH.CREATION_DATE
, COH.LAST_UPDATED_BY
, COH.LAST_UPDATE_DATE
, COH.LAST_UPDATE_LOGIN
FROM IGS_PR_COHORT COH
, IGS_OR_UNIT OU
, IGS_PR_STAT_TYPE PST
, IGS_LOOKUP_VALUES LKV
, IGS_LOOKUP_VALUES LKV1
WHERE COH.ORG_UNIT_CD = OU.ORG_UNIT_CD (+)
AND COH.STAT_TYPE = PST.STAT_TYPE
AND COH.DFLT_DISPLAY_TYPE = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'DFLT_DISPLAY_TYPE'
AND COH.TIMEFRAME = LKV1.LOOKUP_CODE
AND LKV1.LOOKUP_TYPE = 'TIMEFRAME'