VIEW: APPS.IGSFV_PR_COHORTS

Source

View Text - Preformatted

SELECT COH.COHORT_NAME, COH.DESCRIPTION, COH.ORG_UNIT_CD, COH.STAT_TYPE, COH.DFLT_DISPLAY_TYPE, COH.TIMEFRAME, COH.DENSE_RANK_IND, COH.INCL_ON_TRANSCRIPT_IND, COH.INCL_ON_STUD_ACAD_HIST_IND, COH.RULE_SEQUENCE_NUMBER, STAT.DESCRIPTION, '_LA:COH.DFLT_DISPLAY_TYPE:IGS_LOOKUP_VALUES:DFLT_DISPLAY_TYPE:MEANING', '_LA:COH.TIMEFRAME:IGS_LOOKUP_VALUES:TIMEFRAME:MEANING', HP.PARTY_NAME, COH.CLOSED_IND, COH.CREATED_BY, COH.CREATION_DATE, COH.LAST_UPDATED_BY, COH.LAST_UPDATE_DATE FROM IGS_PR_COHORT COH, IGS_PR_STAT_TYPE STAT, HZ_PARTIES HP WHERE COH.STAT_TYPE = STAT.STAT_TYPE AND COH.ORG_UNIT_CD = HP.PARTY_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT COH.COHORT_NAME
, COH.DESCRIPTION
, COH.ORG_UNIT_CD
, COH.STAT_TYPE
, COH.DFLT_DISPLAY_TYPE
, COH.TIMEFRAME
, COH.DENSE_RANK_IND
, COH.INCL_ON_TRANSCRIPT_IND
, COH.INCL_ON_STUD_ACAD_HIST_IND
, COH.RULE_SEQUENCE_NUMBER
, STAT.DESCRIPTION
, '_LA:COH.DFLT_DISPLAY_TYPE:IGS_LOOKUP_VALUES:DFLT_DISPLAY_TYPE:MEANING'
, '_LA:COH.TIMEFRAME:IGS_LOOKUP_VALUES:TIMEFRAME:MEANING'
, HP.PARTY_NAME
, COH.CLOSED_IND
, COH.CREATED_BY
, COH.CREATION_DATE
, COH.LAST_UPDATED_BY
, COH.LAST_UPDATE_DATE
FROM IGS_PR_COHORT COH
, IGS_PR_STAT_TYPE STAT
, HZ_PARTIES HP
WHERE COH.STAT_TYPE = STAT.STAT_TYPE
AND COH.ORG_UNIT_CD = HP.PARTY_NUMBER WITH READ ONLY