VIEW: APPS.IGF_AW_AWARD_V

Source

View Text - Preformatted

SELECT AWD.ROW_ID ROW_ID, AWD.AWARD_ID AWARD_ID , FMAST.CI_CAL_TYPE CI_CAL_TYPE, FMAST.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER, CI.ALTERNATE_CODE CI_ALTERNATE_CODE, CI.START_DT CI_START_DT, CI.END_DT CI_END_DT, FMAST.FUND_CODE FUND_CODE, FTYPE.FUND_TYPE FUND_TYPE, FCAT.FED_FUND_CODE FED_FUND_CODE, FCAT.SYS_FUND_TYPE SYS_FUND_TYPE, AWD.FUND_ID FUND_ID, FMAST.DESCRIPTION DESCRIPTION, AWD.BASE_ID BASE_ID, AWD.OFFERED_AMT OFFERED_AMT, AWD.ACCEPTED_AMT ACCEPTED_AMT, AWD.PAID_AMT PAID_AMT, AWD.PACKAGING_TYPE PACKAGING_TYPE, AWD.MANUAL_UPDATE MANUAL_UPDATE, AWD.RULES_OVERRIDE RULES_OVERRIDE, AWD.BATCH_ID BATCH_ID, AWD.AWARD_DATE AWARD_DATE, AWD.AWARD_STATUS AWARD_STATUS, IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_STATUS',AWD.AWARD_STATUS) AWARD_STATUS_DESC, AWD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, AWD.ATTRIBUTE1 ATTRIBUTE1, AWD.ATTRIBUTE2 ATTRIBUTE2, AWD.ATTRIBUTE3 ATTRIBUTE3, AWD.ATTRIBUTE4 ATTRIBUTE4, AWD.ATTRIBUTE5 ATTRIBUTE5, AWD.ATTRIBUTE6 ATTRIBUTE6, AWD.ATTRIBUTE7 ATTRIBUTE7, AWD.ATTRIBUTE8 ATTRIBUTE8, AWD.ATTRIBUTE9 ATTRIBUTE9, AWD.ATTRIBUTE10 ATTRIBUTE10, AWD.ATTRIBUTE11 ATTRIBUTE11, AWD.ATTRIBUTE12 ATTRIBUTE12, AWD.ATTRIBUTE13 ATTRIBUTE13, AWD.ATTRIBUTE14 ATTRIBUTE14, AWD.ATTRIBUTE15 ATTRIBUTE15, AWD.ATTRIBUTE16 ATTRIBUTE16, AWD.ATTRIBUTE17 ATTRIBUTE17, AWD.ATTRIBUTE18 ATTRIBUTE18, AWD.ATTRIBUTE19 ATTRIBUTE19, AWD.ATTRIBUTE20 ATTRIBUTE20, FCAT.FUND_SOURCE FUND_SOURCE, FACON.PERSON_ID STUDENT_ID, FACON.PERSON_ID PERSON_ID, PE.PARTY_NUMBER PERSON_NUMBER, PIT.API_PERSON_ID SSN, PE.PERSON_LAST_NAME||','||PE.PERSON_FIRST_NAME FULL_NAME, AWD.RVSN_ID RVSN_ID, RVSN.DESCP REVISION_DESC, AWD.CREATED_BY CREATED_BY, AWD.CREATION_DATE CREATION_DATE, AWD.LAST_UPDATED_BY LAST_UPDATED_BY, AWD.LAST_UPDATE_DATE LAST_UPDATE_DATE, AWD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, AWD.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, AWD.PROGRAM_ID PROGRAM_ID, AWD.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, AWD.REQUEST_ID REQUEST_ID, AWD.ALT_PELL_SCHEDULE , awd.legacy_record_flag, awd.award_number_txt, AWD.ADPLANS_ID, ADPLANS.AWD_DIST_PLAN_CD, ADPLANS.AWD_DIST_PLAN_CD_DESC, ADPLANS.DIST_PLAN_METHOD_CODE, AWD.LOCK_AWARD_FLAG, AWD.APP_TRANS_num_txt, FCAT.ALT_LOAN_CODE ALT_LOAN_CODE, FCAT.ALT_REL_CODE ALT_REL_CODE, AWD.AWD_PROC_STATUS_CODE, AWD.NOTIFICATION_STATUS_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_NOTIFIC_STAT',AWD. NOTIFICATION_STATUS_CODE) NOTIFICATION_STATUS_CODE_DESC, AWD.NOTIFICATION_STATUS_DATE, awd.publish_in_ss_flag FROM IGF_AW_AWARD AWD, IGF_AW_FUND_MAST FMAST, IGF_AW_FUND_CAT FCAT , IGF_AW_FUND_TYPE FTYPE , IGS_CA_INST CI, IGF_AP_FA_BASE_REC FACON, ( SELECT API_PERSON_ID, PE_PERSON_ID FROM IGS_PE_PERSON_ID_TYP PIT_2, IGS_PE_ALT_PERS_ID API_2 WHERE API_2.PERSON_ID_TYPE = PIT_2.PERSON_ID_TYPE AND PIT_2.S_PERSON_ID_TYPE = 'SSN' AND SYSDATE BETWEEN API_2.START_DT AND NVL(API_2.END_DT, SYSDATE) ) PIT, HZ_PARTIES PE, IGF_AW_AWD_RVSN_RSN RVSN, IGF_AW_AWD_DIST_PLANS ADPLANS WHERE AWD.FUND_ID = FMAST.FUND_ID AND FMAST.FUND_CODE = FCAT.FUND_CODE AND FCAT.FUND_TYPE = FTYPE.FUND_TYPE AND FMAST.CI_CAL_TYPE = CI.CAL_TYPE AND FMAST.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND AWD.BASE_ID = FACON.BASE_ID AND PE.PARTY_ID =FACON.PERSON_ID AND PE.PARTY_ID = PIT.PE_PERSON_ID (+) AND AWD.RVSN_ID = RVSN.RVSN_ID (+) AND AWD.ADPLANS_ID = ADPLANS.ADPLANS_ID (+) AND FMAST.FUND_ID = AWD.FUND_ID

View Text - HTML Formatted

SELECT AWD.ROW_ID ROW_ID
, AWD.AWARD_ID AWARD_ID
, FMAST.CI_CAL_TYPE CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE CI_ALTERNATE_CODE
, CI.START_DT CI_START_DT
, CI.END_DT CI_END_DT
, FMAST.FUND_CODE FUND_CODE
, FTYPE.FUND_TYPE FUND_TYPE
, FCAT.FED_FUND_CODE FED_FUND_CODE
, FCAT.SYS_FUND_TYPE SYS_FUND_TYPE
, AWD.FUND_ID FUND_ID
, FMAST.DESCRIPTION DESCRIPTION
, AWD.BASE_ID BASE_ID
, AWD.OFFERED_AMT OFFERED_AMT
, AWD.ACCEPTED_AMT ACCEPTED_AMT
, AWD.PAID_AMT PAID_AMT
, AWD.PACKAGING_TYPE PACKAGING_TYPE
, AWD.MANUAL_UPDATE MANUAL_UPDATE
, AWD.RULES_OVERRIDE RULES_OVERRIDE
, AWD.BATCH_ID BATCH_ID
, AWD.AWARD_DATE AWARD_DATE
, AWD.AWARD_STATUS AWARD_STATUS
, IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_STATUS'
, AWD.AWARD_STATUS) AWARD_STATUS_DESC
, AWD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AWD.ATTRIBUTE1 ATTRIBUTE1
, AWD.ATTRIBUTE2 ATTRIBUTE2
, AWD.ATTRIBUTE3 ATTRIBUTE3
, AWD.ATTRIBUTE4 ATTRIBUTE4
, AWD.ATTRIBUTE5 ATTRIBUTE5
, AWD.ATTRIBUTE6 ATTRIBUTE6
, AWD.ATTRIBUTE7 ATTRIBUTE7
, AWD.ATTRIBUTE8 ATTRIBUTE8
, AWD.ATTRIBUTE9 ATTRIBUTE9
, AWD.ATTRIBUTE10 ATTRIBUTE10
, AWD.ATTRIBUTE11 ATTRIBUTE11
, AWD.ATTRIBUTE12 ATTRIBUTE12
, AWD.ATTRIBUTE13 ATTRIBUTE13
, AWD.ATTRIBUTE14 ATTRIBUTE14
, AWD.ATTRIBUTE15 ATTRIBUTE15
, AWD.ATTRIBUTE16 ATTRIBUTE16
, AWD.ATTRIBUTE17 ATTRIBUTE17
, AWD.ATTRIBUTE18 ATTRIBUTE18
, AWD.ATTRIBUTE19 ATTRIBUTE19
, AWD.ATTRIBUTE20 ATTRIBUTE20
, FCAT.FUND_SOURCE FUND_SOURCE
, FACON.PERSON_ID STUDENT_ID
, FACON.PERSON_ID PERSON_ID
, PE.PARTY_NUMBER PERSON_NUMBER
, PIT.API_PERSON_ID SSN
, PE.PERSON_LAST_NAME||'
, '||PE.PERSON_FIRST_NAME FULL_NAME
, AWD.RVSN_ID RVSN_ID
, RVSN.DESCP REVISION_DESC
, AWD.CREATED_BY CREATED_BY
, AWD.CREATION_DATE CREATION_DATE
, AWD.LAST_UPDATED_BY LAST_UPDATED_BY
, AWD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AWD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AWD.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AWD.PROGRAM_ID PROGRAM_ID
, AWD.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AWD.REQUEST_ID REQUEST_ID
, AWD.ALT_PELL_SCHEDULE
, AWD.LEGACY_RECORD_FLAG
, AWD.AWARD_NUMBER_TXT
, AWD.ADPLANS_ID
, ADPLANS.AWD_DIST_PLAN_CD
, ADPLANS.AWD_DIST_PLAN_CD_DESC
, ADPLANS.DIST_PLAN_METHOD_CODE
, AWD.LOCK_AWARD_FLAG
, AWD.APP_TRANS_NUM_TXT
, FCAT.ALT_LOAN_CODE ALT_LOAN_CODE
, FCAT.ALT_REL_CODE ALT_REL_CODE
, AWD.AWD_PROC_STATUS_CODE
, AWD.NOTIFICATION_STATUS_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_NOTIFIC_STAT'
, AWD. NOTIFICATION_STATUS_CODE) NOTIFICATION_STATUS_CODE_DESC
, AWD.NOTIFICATION_STATUS_DATE
, AWD.PUBLISH_IN_SS_FLAG
FROM IGF_AW_AWARD AWD
, IGF_AW_FUND_MAST FMAST
, IGF_AW_FUND_CAT FCAT
, IGF_AW_FUND_TYPE FTYPE
, IGS_CA_INST CI
, IGF_AP_FA_BASE_REC FACON
, ( SELECT API_PERSON_ID
, PE_PERSON_ID
FROM IGS_PE_PERSON_ID_TYP PIT_2
, IGS_PE_ALT_PERS_ID API_2
WHERE API_2.PERSON_ID_TYPE = PIT_2.PERSON_ID_TYPE
AND PIT_2.S_PERSON_ID_TYPE = 'SSN'
AND SYSDATE BETWEEN API_2.START_DT
AND NVL(API_2.END_DT
, SYSDATE) ) PIT
, HZ_PARTIES PE
, IGF_AW_AWD_RVSN_RSN RVSN
, IGF_AW_AWD_DIST_PLANS ADPLANS
WHERE AWD.FUND_ID = FMAST.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND FCAT.FUND_TYPE = FTYPE.FUND_TYPE
AND FMAST.CI_CAL_TYPE = CI.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND AWD.BASE_ID = FACON.BASE_ID
AND PE.PARTY_ID =FACON.PERSON_ID
AND PE.PARTY_ID = PIT.PE_PERSON_ID (+)
AND AWD.RVSN_ID = RVSN.RVSN_ID (+)
AND AWD.ADPLANS_ID = ADPLANS.ADPLANS_ID (+)
AND FMAST.FUND_ID = AWD.FUND_ID