VIEW: APPS.IGS_HE_POOUS

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID, A.HESA_POOUS_ID HESA_POOUS_ID ,A.COURSE_CD COURSE_CD ,A.CRV_VERSION_NUMBER CRV_VERSION_NUMBER ,A.CAL_TYPE CAL_TYPE ,A.LOCATION_CD LOCATION_CD ,A.ATTENDANCE_MODE ATTENDANCE_MODE ,A.ATTENDANCE_TYPE ATTENDANCE_TYPE ,A.UNIT_SET_CD UNIT_SET_CD ,A.US_VERSION_NUMBER US_VERSION_NUMBER ,A.LOCATION_OF_STUDY LOCATION_OF_STUDY ,A.MODE_OF_STUDY MODE_OF_STUDY ,A.UFI_PLACE UFI_PLACE ,A.FRANCHISING_ACTIVITY FRANCHISING_ACTIVITY ,A.TYPE_OF_YEAR TYPE_OF_YEAR ,A.LENG_CURRENT_YEAR LENG_CURRENT_YEAR ,A.GRADING_SCHEMA_CD GRADING_SCHEMA_CD ,A.GS_VERSION_NUMBER GS_VERSION_NUMBER ,A.CREDIT_VALUE_YOP1 CREDIT_VALUE_YOP1 ,A.LEVEL_CREDIT1 LEVEL_CREDIT1 ,A.CREDIT_VALUE_YOP2 CREDIT_VALUE_YOP2 ,A.LEVEL_CREDIT2 LEVEL_CREDIT2 ,A. FTE_INTENSITY FTE_INTENSITY ,A.FTE_CALC_TYPE FTE_CALC_TYPE ,A.TEACH_PERIOD_START_DT TEACH_PERIOD_START_DT ,A.TEACH_PERIOD_END_DT TEACH_PERIOD_END_DT ,A.OTHER_INSTIT_TEACH1 OTHER_INSTIT_TEACH1 ,A.OTHER_INSTIT_TEACH2 OTHER_INSTIT_TEACH2 ,A.PROP_NOT_TAUGHT PROP_NOT_TAUGHT ,A.FUNDABILITY_CD FUNDABILITY_CD ,A.FEE_BAND FEE_BAND ,A.FUNDING_SOURCE FUNDING_SOURCE ,A.LEVEL_APPLICABLE_TO_FUNDING LEVEL_APPLICABLE_TO_FUNDING ,A.CREATED_BY CREATED_BY ,A.CREATION_DATE CREATION_DATE ,A.LAST_UPDATED_BY LAST_UPDATED_BY ,A.LAST_UPDATE_DATE LAST_UPDATE_DATE ,A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,A.CREDIT_VALUE_YOP3 CREDIT_VALUE_YOP3 ,A.LEVEL_CREDIT3 LEVEL_CREDIT3 ,A.CREDIT_VALUE_YOP4 CREDIT_VALUE_YOP4 ,A.LEVEL_CREDIT4 LEVEL_CREDIT4 FROM IGS_HE_POOUS_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_POOUS_ID HESA_POOUS_ID
, A.COURSE_CD COURSE_CD
, A.CRV_VERSION_NUMBER CRV_VERSION_NUMBER
, A.CAL_TYPE CAL_TYPE
, A.LOCATION_CD LOCATION_CD
, A.ATTENDANCE_MODE ATTENDANCE_MODE
, A.ATTENDANCE_TYPE ATTENDANCE_TYPE
, A.UNIT_SET_CD UNIT_SET_CD
, A.US_VERSION_NUMBER US_VERSION_NUMBER
, A.LOCATION_OF_STUDY LOCATION_OF_STUDY
, A.MODE_OF_STUDY MODE_OF_STUDY
, A.UFI_PLACE UFI_PLACE
, A.FRANCHISING_ACTIVITY FRANCHISING_ACTIVITY
, A.TYPE_OF_YEAR TYPE_OF_YEAR
, A.LENG_CURRENT_YEAR LENG_CURRENT_YEAR
, A.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, A.GS_VERSION_NUMBER GS_VERSION_NUMBER
, A.CREDIT_VALUE_YOP1 CREDIT_VALUE_YOP1
, A.LEVEL_CREDIT1 LEVEL_CREDIT1
, A.CREDIT_VALUE_YOP2 CREDIT_VALUE_YOP2
, A.LEVEL_CREDIT2 LEVEL_CREDIT2
, A. FTE_INTENSITY FTE_INTENSITY
, A.FTE_CALC_TYPE FTE_CALC_TYPE
, A.TEACH_PERIOD_START_DT TEACH_PERIOD_START_DT
, A.TEACH_PERIOD_END_DT TEACH_PERIOD_END_DT
, A.OTHER_INSTIT_TEACH1 OTHER_INSTIT_TEACH1
, A.OTHER_INSTIT_TEACH2 OTHER_INSTIT_TEACH2
, A.PROP_NOT_TAUGHT PROP_NOT_TAUGHT
, A.FUNDABILITY_CD FUNDABILITY_CD
, A.FEE_BAND FEE_BAND
, A.FUNDING_SOURCE FUNDING_SOURCE
, A.LEVEL_APPLICABLE_TO_FUNDING LEVEL_APPLICABLE_TO_FUNDING
, A.CREATED_BY CREATED_BY
, A.CREATION_DATE CREATION_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, A.CREDIT_VALUE_YOP3 CREDIT_VALUE_YOP3
, A.LEVEL_CREDIT3 LEVEL_CREDIT3
, A.CREDIT_VALUE_YOP4 CREDIT_VALUE_YOP4
, A.LEVEL_CREDIT4 LEVEL_CREDIT4
FROM IGS_HE_POOUS_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)