VIEW: APPS.IGS_HE_FTE_CAL_PRD_V

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID, A.FTE_CAL_TYPE FTE_CAL_TYPE, A.FTE_SEQUENCE_NUM FTE_SEQUENCE_NUM, B.ALTERNATE_CODE FTE_CAL_NAME, B.START_DT FTE_START_DT, B.END_DT FTE_END_DT, A.TEACH_CAL_TYPE TEACH_CAL_TYPE, A.TEACH_SEQUENCE_NUM TEACH_SEQUENCE_NUM, C.ALTERNATE_CODE TEACH_CAL_NAME, C.START_DT TEACH_START_DT, C.END_DT TEACH_END_DT, 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 FROM IGS_HE_FTE_CAL_PRD A, IGS_CA_INST B, IGS_CA_INST C WHERE A.FTE_CAL_TYPE=B.CAL_TYPE AND A.FTE_SEQUENCE_NUM=B.SEQUENCE_NUMBER AND A.TEACH_CAL_TYPE=C.CAL_TYPE AND A.TEACH_SEQUENCE_NUM=C.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.FTE_CAL_TYPE FTE_CAL_TYPE
, A.FTE_SEQUENCE_NUM FTE_SEQUENCE_NUM
, B.ALTERNATE_CODE FTE_CAL_NAME
, B.START_DT FTE_START_DT
, B.END_DT FTE_END_DT
, A.TEACH_CAL_TYPE TEACH_CAL_TYPE
, A.TEACH_SEQUENCE_NUM TEACH_SEQUENCE_NUM
, C.ALTERNATE_CODE TEACH_CAL_NAME
, C.START_DT TEACH_START_DT
, C.END_DT TEACH_END_DT
, 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
FROM IGS_HE_FTE_CAL_PRD A
, IGS_CA_INST B
, IGS_CA_INST C
WHERE A.FTE_CAL_TYPE=B.CAL_TYPE
AND A.FTE_SEQUENCE_NUM=B.SEQUENCE_NUMBER
AND A.TEACH_CAL_TYPE=C.CAL_TYPE
AND A.TEACH_SEQUENCE_NUM=C.SEQUENCE_NUMBER