VIEW: APPS.IGFFV_STUDENT_AUTHORIZATIONS

Source

View Text - Preformatted

SELECT SEAUT.FLAG, SEAUT.FIRST_NAME, SEAUT.LAST_NAME, SEAUT.ADDRESS1, SEAUT.ADDRESS2, SEAUT.ADDRESS3, SEAUT.ADDRESS4, SEAUT.CITY, SEAUT.STATE, SEAUT.PROVINCE, SEAUT.COUNTY, SEAUT.COUNTRY, SEAUT.SEX, SEAUT.BIRTH_DT, SEAUT.SSN_NO, SEAUT.MARITAL_STATUS, SEAUT.VISA_TYPE, SEAUT.VISA_CATEGORY, SEAUT.VISA_NUMBER, SEAUT.VISA_EXPIRY_DT, SEAUT.ENTRY_DATE, NULL, NULL, SEAUT.THRESHOLD_PERCT, SEAUT.THRESHOLD_VALUE, NULL, NULL, SEAUT.ACCEPTED_AMNT, SEAUT.AW_CAL_TYPE, SEAUT.AW_SEQUENCE_NUMBER, SEAUT.LD_CAL_TYPE, SEAUT.LD_SEQUENCE_NUMBER, AWARD_CI.ALTERNATE_CODE, LOAD_CI.ALTERNATE_CODE, HZ.PARTY_NUMBER, FMAST.FUND_CODE, FMAST.DESCRIPTION, SEAUT.AUTH_ID, SEAUT.PERSON_ID, SEAUT.FUND_ID, SEAUT.SEQUENCE_NO, SEAUT.CREATED_BY, SEAUT.CREATION_DATE, SEAUT.LAST_UPDATED_BY, SEAUT.LAST_UPDATE_DATE, SEAUT.AWARD_ID, SEAUT.AUTHORIZATION_DATE, SEAUT.NOTIFICATION_DATE FROM IGF_SE_AUTH SEAUT, IGF_AW_FUND_MAST_ALL FMAST, IGS_CA_INST_ALL AWARD_CI, IGS_CA_INST_ALL LOAD_CI, HZ_PARTIES HZ WHERE SEAUT.FUND_ID = FMAST.FUND_ID AND SEAUT.LD_CAL_TYPE = LOAD_CI.CAL_TYPE AND SEAUT.LD_SEQUENCE_NUMBER = LOAD_CI.SEQUENCE_NUMBER AND FMAST.CI_CAL_TYPE = AWARD_CI.CAL_TYPE AND FMAST.CI_SEQUENCE_NUMBER = AWARD_CI.SEQUENCE_NUMBER AND HZ.PARTY_ID = SEAUT.PERSON_ID WITH READ ONLY

View Text - HTML Formatted

SELECT SEAUT.FLAG
, SEAUT.FIRST_NAME
, SEAUT.LAST_NAME
, SEAUT.ADDRESS1
, SEAUT.ADDRESS2
, SEAUT.ADDRESS3
, SEAUT.ADDRESS4
, SEAUT.CITY
, SEAUT.STATE
, SEAUT.PROVINCE
, SEAUT.COUNTY
, SEAUT.COUNTRY
, SEAUT.SEX
, SEAUT.BIRTH_DT
, SEAUT.SSN_NO
, SEAUT.MARITAL_STATUS
, SEAUT.VISA_TYPE
, SEAUT.VISA_CATEGORY
, SEAUT.VISA_NUMBER
, SEAUT.VISA_EXPIRY_DT
, SEAUT.ENTRY_DATE
, NULL
, NULL
, SEAUT.THRESHOLD_PERCT
, SEAUT.THRESHOLD_VALUE
, NULL
, NULL
, SEAUT.ACCEPTED_AMNT
, SEAUT.AW_CAL_TYPE
, SEAUT.AW_SEQUENCE_NUMBER
, SEAUT.LD_CAL_TYPE
, SEAUT.LD_SEQUENCE_NUMBER
, AWARD_CI.ALTERNATE_CODE
, LOAD_CI.ALTERNATE_CODE
, HZ.PARTY_NUMBER
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, SEAUT.AUTH_ID
, SEAUT.PERSON_ID
, SEAUT.FUND_ID
, SEAUT.SEQUENCE_NO
, SEAUT.CREATED_BY
, SEAUT.CREATION_DATE
, SEAUT.LAST_UPDATED_BY
, SEAUT.LAST_UPDATE_DATE
, SEAUT.AWARD_ID
, SEAUT.AUTHORIZATION_DATE
, SEAUT.NOTIFICATION_DATE
FROM IGF_SE_AUTH SEAUT
, IGF_AW_FUND_MAST_ALL FMAST
, IGS_CA_INST_ALL AWARD_CI
, IGS_CA_INST_ALL LOAD_CI
, HZ_PARTIES HZ
WHERE SEAUT.FUND_ID = FMAST.FUND_ID
AND SEAUT.LD_CAL_TYPE = LOAD_CI.CAL_TYPE
AND SEAUT.LD_SEQUENCE_NUMBER = LOAD_CI.SEQUENCE_NUMBER
AND FMAST.CI_CAL_TYPE = AWARD_CI.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = AWARD_CI.SEQUENCE_NUMBER
AND HZ.PARTY_ID = SEAUT.PERSON_ID WITH READ ONLY