DBA Data[Home] [Help]

VIEW: APPS.IGSBV_USEC_REPEAT_CONDITIONS

Source

View Text - Preformatted

SELECT US.UNIT_SECTION_REPT_CONDITION_ID, US.REPEATABLE_IND REPEATABLE_INDICATOR, US.SAME_TEACHING_PERIOD, US.MAX_REPEATS_FOR_CREDIT, US.MAX_REPEATS_FOR_FUNDING, US.MAX_REPEAT_CREDIT_POINTS, US.SAME_TEACH_PERIOD_REPEATS, US.SAME_TEACH_PERIOD_REPEATS_CP, US.UOO_ID UNIT_SECTION_ID, UN.UNIT_CD, UN.VERSION_NUMBER, UN.CAL_TYPE, UN.CI_SEQUENCE_NUMBER, UN.LOCATION_CD, UN.UNIT_CLASS, US.CREATED_BY, US.CREATION_DATE, US.LAST_UPDATED_BY, US.LAST_UPDATE_DATE FROM IGS_PS_USEC_RPT_COND US, IGS_PS_UNIT_OFR_OPT_ALL UN WHERE US.UOO_ID = UN.UOO_ID WITH READ ONLY
View Text - HTML Formatted

SELECT US.UNIT_SECTION_REPT_CONDITION_ID
, US.REPEATABLE_IND REPEATABLE_INDICATOR
, US.SAME_TEACHING_PERIOD
, US.MAX_REPEATS_FOR_CREDIT
, US.MAX_REPEATS_FOR_FUNDING
, US.MAX_REPEAT_CREDIT_POINTS
, US.SAME_TEACH_PERIOD_REPEATS
, US.SAME_TEACH_PERIOD_REPEATS_CP
, US.UOO_ID UNIT_SECTION_ID
, UN.UNIT_CD
, UN.VERSION_NUMBER
, UN.CAL_TYPE
, UN.CI_SEQUENCE_NUMBER
, UN.LOCATION_CD
, UN.UNIT_CLASS
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
FROM IGS_PS_USEC_RPT_COND US
, IGS_PS_UNIT_OFR_OPT_ALL UN
WHERE US.UOO_ID = UN.UOO_ID WITH READ ONLY