VIEW: APPS.IGS_PE_TEACH_PERIODS_V

Source

View Text - Preformatted

SELECT TP.ROWID ROW_ID, TP.TEACHING_PERIOD_ID, TP.PERSON_ID, NULL PERSON_NUMBER, CI.ALTERNATE_CODE, TP.TEACH_PERIOD_RESID_STAT_CD, CC.MEANING RES_STATUS_DESC, TO_DATE(NULL) START_DATE, TO_DATE(NULL) END_DATE, TP.CAL_TYPE, TP.SEQUENCE_NUMBER, TP.CREATED_BY, TP.CREATION_DATE, TP.LAST_UPDATED_BY, TP.LAST_UPDATE_DATE, TP.LAST_UPDATE_LOGIN, CI.DESCRIPTION CALENDAR_DESC, CAL_CAT.MEANING CALENDAR_CATEGORY FROM IGS_PE_TEACH_PERIODS_ALL TP, IGS_CA_INST_ALL CI, IGS_LOOKUP_VALUES CC, IGS_CA_TYPE TYP, IGS_LOOKUP_VALUES CAL_CAT WHERE CC.LOOKUP_CODE = TP.TEACH_PERIOD_RESID_STAT_CD AND CC.LOOKUP_TYPE='PE_TEA_PER_RES' AND CI.SEQUENCE_NUMBER = TP.SEQUENCE_NUMBER AND CI.CAL_TYPE = TP.CAL_TYPE AND TYP.CAL_TYPE = CI.CAL_TYPE AND CAL_CAT.LOOKUP_TYPE = 'CAL_CAT' AND CAL_CAT.LOOKUP_CODE = TYP.S_CAL_CAT

View Text - HTML Formatted

SELECT TP.ROWID ROW_ID
, TP.TEACHING_PERIOD_ID
, TP.PERSON_ID
, NULL PERSON_NUMBER
, CI.ALTERNATE_CODE
, TP.TEACH_PERIOD_RESID_STAT_CD
, CC.MEANING RES_STATUS_DESC
, TO_DATE(NULL) START_DATE
, TO_DATE(NULL) END_DATE
, TP.CAL_TYPE
, TP.SEQUENCE_NUMBER
, TP.CREATED_BY
, TP.CREATION_DATE
, TP.LAST_UPDATED_BY
, TP.LAST_UPDATE_DATE
, TP.LAST_UPDATE_LOGIN
, CI.DESCRIPTION CALENDAR_DESC
, CAL_CAT.MEANING CALENDAR_CATEGORY
FROM IGS_PE_TEACH_PERIODS_ALL TP
, IGS_CA_INST_ALL CI
, IGS_LOOKUP_VALUES CC
, IGS_CA_TYPE TYP
, IGS_LOOKUP_VALUES CAL_CAT
WHERE CC.LOOKUP_CODE = TP.TEACH_PERIOD_RESID_STAT_CD
AND CC.LOOKUP_TYPE='PE_TEA_PER_RES'
AND CI.SEQUENCE_NUMBER = TP.SEQUENCE_NUMBER
AND CI.CAL_TYPE = TP.CAL_TYPE
AND TYP.CAL_TYPE = CI.CAL_TYPE
AND CAL_CAT.LOOKUP_TYPE = 'CAL_CAT'
AND CAL_CAT.LOOKUP_CODE = TYP.S_CAL_CAT