VIEW: APPS.IGF_AP_FA_ANT_DATA_V

Source

View Text - Preformatted

SELECT FA.ROWID, FA.BASE_ID, LD.ALTERNATE_CODE, FA.LD_CAL_TYPE, FA.LD_SEQUENCE_NUMBER, LD.START_DT, LD.END_DT, FA.ORG_UNIT_CD, FA.PROGRAM_TYPE, FA.PROGRAM_LOCATION_CD, FA.PROGRAM_CD, FA.CLASS_STANDING, FA.RESIDENCY_STATUS_CODE, FA.HOUSING_STATUS_CODE, FA.ATTENDANCE_TYPE, FA.ATTENDANCE_MODE, FA.MONTHS_ENROLLED_NUM, FA.CREDIT_POINTS_NUM, FA.CREATED_BY, FA.CREATION_DATE, FA.LAST_UPDATED_BY, FA.LAST_UPDATE_DATE, FA.LAST_UPDATE_LOGIN FROM IGF_AP_FA_ANT_DATA FA, IGS_CA_INST LD WHERE FA.LD_CAL_TYPE = LD.CAL_TYPE AND FA.LD_SEQUENCE_NUMBER = LD.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT FA.ROWID
, FA.BASE_ID
, LD.ALTERNATE_CODE
, FA.LD_CAL_TYPE
, FA.LD_SEQUENCE_NUMBER
, LD.START_DT
, LD.END_DT
, FA.ORG_UNIT_CD
, FA.PROGRAM_TYPE
, FA.PROGRAM_LOCATION_CD
, FA.PROGRAM_CD
, FA.CLASS_STANDING
, FA.RESIDENCY_STATUS_CODE
, FA.HOUSING_STATUS_CODE
, FA.ATTENDANCE_TYPE
, FA.ATTENDANCE_MODE
, FA.MONTHS_ENROLLED_NUM
, FA.CREDIT_POINTS_NUM
, FA.CREATED_BY
, FA.CREATION_DATE
, FA.LAST_UPDATED_BY
, FA.LAST_UPDATE_DATE
, FA.LAST_UPDATE_LOGIN
FROM IGF_AP_FA_ANT_DATA FA
, IGS_CA_INST LD
WHERE FA.LD_CAL_TYPE = LD.CAL_TYPE
AND FA.LD_SEQUENCE_NUMBER = LD.SEQUENCE_NUMBER