VIEW: APPS.IGS_HE_ST_PROG

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID ,A.HESA_ST_PROG_ID ,A.COURSE_CD ,A.VERSION_NUMBER ,A.TEACHER_TRAIN_PROG_ID ,A.ITT_PHASE ,A.BILINGUAL_ITT_MARKER ,A.TEACHING_QUAL_SOUGHT_SECTOR ,A.TEACHING_QUAL_SOUGHT_SUBJ1 ,A.TEACHING_QUAL_SOUGHT_SUBJ2 ,A.TEACHING_QUAL_SOUGHT_SUBJ3 ,A.LOCATION_OF_STUDY ,A.OTHER_INST_PROV_TEACHING1 ,A.OTHER_INST_PROV_TEACHING2 ,A.PROP_TEACHING_IN_WELSH ,A.PROP_NOT_TAUGHT ,A.CREDIT_TRANSFER_SCHEME ,A.RETURN_TYPE ,A.DEFAULT_AWARD ,A.PROGRAM_CALC ,A.LEVEL_APPLICABLE_TO_FUNDING ,A.FRANCHISING_ACTIVITY ,A.NHS_FUNDING_SOURCE ,A.FE_PROGRAM_MARKER ,A.FEE_BAND ,A.FUNDABILITY ,A.FTE_INTENSITY ,A.TEACH_PERIOD_START_DT ,A.TEACH_PERIOD_END_DT ,A.CREATION_DATE ,A.CREATED_BY ,A.LAST_UPDATE_DATE ,A.LAST_UPDATED_BY ,A.LAST_UPDATE_LOGIN ,A.IMPLIED_FUND_RATE ,A.GOV_INITIATIVES_CD ,A.UNITS_FOR_QUAL ,A.DISADV_UPLIFT_ELIG_CD ,A.FRANCH_PARTNER_CD ,A.FRANCH_OUT_ARR_CD ,A.EXCLUDE_FLAG FROM IGS_HE_ST_PROG_ALL A WHERE NVL (org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.HESA_ST_PROG_ID
, A.COURSE_CD
, A.VERSION_NUMBER
, A.TEACHER_TRAIN_PROG_ID
, A.ITT_PHASE
, A.BILINGUAL_ITT_MARKER
, A.TEACHING_QUAL_SOUGHT_SECTOR
, A.TEACHING_QUAL_SOUGHT_SUBJ1
, A.TEACHING_QUAL_SOUGHT_SUBJ2
, A.TEACHING_QUAL_SOUGHT_SUBJ3
, A.LOCATION_OF_STUDY
, A.OTHER_INST_PROV_TEACHING1
, A.OTHER_INST_PROV_TEACHING2
, A.PROP_TEACHING_IN_WELSH
, A.PROP_NOT_TAUGHT
, A.CREDIT_TRANSFER_SCHEME
, A.RETURN_TYPE
, A.DEFAULT_AWARD
, A.PROGRAM_CALC
, A.LEVEL_APPLICABLE_TO_FUNDING
, A.FRANCHISING_ACTIVITY
, A.NHS_FUNDING_SOURCE
, A.FE_PROGRAM_MARKER
, A.FEE_BAND
, A.FUNDABILITY
, A.FTE_INTENSITY
, A.TEACH_PERIOD_START_DT
, A.TEACH_PERIOD_END_DT
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.IMPLIED_FUND_RATE
, A.GOV_INITIATIVES_CD
, A.UNITS_FOR_QUAL
, A.DISADV_UPLIFT_ELIG_CD
, A.FRANCH_PARTNER_CD
, A.FRANCH_OUT_ARR_CD
, A.EXCLUDE_FLAG
FROM IGS_HE_ST_PROG_ALL A
WHERE NVL (ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)