VIEW: APPS.IGF_SP_STDNT_REL_V

Source

View Text - Preformatted

SELECT SPSTD.ROWID, SPSTD.SPNSR_STDNT_ID, SPSTD.FUND_ID, FMAST.FUND_CODE, FMAST.DESCRIPTION, FMAST.DISCONTINUE_FUND, SPSTD.BASE_ID, SPSTD.PERSON_ID, PPB.PERSON_NUMBER, PPB.FULL_NAME, SPSTD.LD_CAL_TYPE, SPSTD.LD_SEQUENCE_NUMBER, SPSTD.TOT_SPNSR_AMOUNT, SPSTD.MIN_CREDIT_POINTS, SPSTD.MIN_ATTENDANCE_TYPE, AT.DESCRIPTION, SPSTD.CREATED_BY, SPSTD.CREATION_DATE, SPSTD.LAST_UPDATED_BY, SPSTD.LAST_UPDATE_DATE, SPSTD.LAST_UPDATE_LOGIN, SPSTD.ORG_ID FROM IGF_SP_STDNT_REL SPSTD, IGF_AW_FUND_MAST FMAST, IGF_AP_FA_BASE_REC FA_DETAIL, IGS_PE_PERSON_BASE_V PPB, IGS_CA_INST CI, IGS_EN_ATD_TYPE AT WHERE SPSTD.FUND_ID = FMAST.FUND_ID AND SPSTD.BASE_ID = FA_DETAIL.BASE_ID AND SPSTD.PERSON_ID = PPB.PERSON_ID AND SPSTD.LD_CAL_TYPE = CI.CAL_TYPE AND SPSTD.LD_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND SPSTD.MIN_ATTENDANCE_TYPE = AT.ATTENDANCE_TYPE(+)

View Text - HTML Formatted

SELECT SPSTD.ROWID
, SPSTD.SPNSR_STDNT_ID
, SPSTD.FUND_ID
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, FMAST.DISCONTINUE_FUND
, SPSTD.BASE_ID
, SPSTD.PERSON_ID
, PPB.PERSON_NUMBER
, PPB.FULL_NAME
, SPSTD.LD_CAL_TYPE
, SPSTD.LD_SEQUENCE_NUMBER
, SPSTD.TOT_SPNSR_AMOUNT
, SPSTD.MIN_CREDIT_POINTS
, SPSTD.MIN_ATTENDANCE_TYPE
, AT.DESCRIPTION
, SPSTD.CREATED_BY
, SPSTD.CREATION_DATE
, SPSTD.LAST_UPDATED_BY
, SPSTD.LAST_UPDATE_DATE
, SPSTD.LAST_UPDATE_LOGIN
, SPSTD.ORG_ID
FROM IGF_SP_STDNT_REL SPSTD
, IGF_AW_FUND_MAST FMAST
, IGF_AP_FA_BASE_REC FA_DETAIL
, IGS_PE_PERSON_BASE_V PPB
, IGS_CA_INST CI
, IGS_EN_ATD_TYPE AT
WHERE SPSTD.FUND_ID = FMAST.FUND_ID
AND SPSTD.BASE_ID = FA_DETAIL.BASE_ID
AND SPSTD.PERSON_ID = PPB.PERSON_ID
AND SPSTD.LD_CAL_TYPE = CI.CAL_TYPE
AND SPSTD.LD_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SPSTD.MIN_ATTENDANCE_TYPE = AT.ATTENDANCE_TYPE(+)