DBA Data[Home] [Help]

VIEW: APPS.IGS_PE_TEACH_PERIODS

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.teaching_period_id teaching_period_id, tab.person_id person_id, tab.teach_period_resid_stat_cd teach_period_resid_stat_cd, tab.cal_type cal_type, tab.sequence_number sequence_number, tab.start_date start_date, tab.end_date end_date, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login, tab.org_id org_id FROM igs_pe_teach_periods_all tab
View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.TEACHING_PERIOD_ID TEACHING_PERIOD_ID
, TAB.PERSON_ID PERSON_ID
, TAB.TEACH_PERIOD_RESID_STAT_CD TEACH_PERIOD_RESID_STAT_CD
, TAB.CAL_TYPE CAL_TYPE
, TAB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, TAB.START_DATE START_DATE
, TAB.END_DATE END_DATE
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ORG_ID ORG_ID
FROM IGS_PE_TEACH_PERIODS_ALL TAB