Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that Stores all the actual disbursement transactions and adjustments made to these, after they have been posted to the student finance interface table. For planned disbursements, this view will not have any records. |
Implementation/DBA Data: | APPS.IGFFV_DISBURSEMENT_ADJUSTMENTS |
SELECT DDTLV.AWARD_ID
, DDTLV.DISB_NUM
, DDTLV.DISB_SEQ_NUM
, DDTLV.DISB_GROSS_AMT
, DDTLV.FEE_1
, DDTLV.FEE_2
, DDTLV.DISB_NET_AMT
, DDTLV.DISB_ADJ_AMT
, DDTLV.DISB_DATE
, DDTLV.FEE_PAID_1
, DDTLV.FEE_PAID_2
, '_LA:DDTLV.DISB_ACTIVITY:IGF_LOOKUPS_VIEW: IGF_DB_DL_ACTIVITY:MEANING'
, DDTLV.DISB_BATCH_ID
, DDTLV.DISB_ACK_DATE
, DDTLV.BOOKING_BATCH_ID
, DDTLV.BOOKED_DATE
, '_LA:DDTLV.DISB_STATUS:IGF_LOOKUPS_VIEW:IGF_DB_DL_DISB_STATUS:MEANING'
, DDTLV.DISB_STATUS_DATE
, '_LA:DDTLV.SF_STATUS:IGF_LOOKUPS_VIEW:IGF_DB_SF_STATUS:MEANING'
, DDTLV.SF_STATUS_DATE
, DDTLV.SF_INVOICE_NUM
, DDTLV.ERROR_DESC
, DDTLV.NOTIFICATION_DATE
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, PE.PARTY_NUMBER
, PE.PARTY_NAME
, LD. ALTERNATE_CODE
, LD.DESCRIPTION
, TP. ALTERNATE_CODE
, TP.DESCRIPTION
, DDTLV.SPNSR_CREDIT_ID
, DDTLV.SPNSR_CHARGE_ID
, DDTLV.SF_CREDIT_ID
, DDTLV.CREATED_BY
, DDTLV.CREATION_DATE
, DDTLV.LAST_UPDATED_BY
, DDTLV.LAST_UPDATE_DATE
, BASE.PERSON_ID
FROM IGF_DB_AWD_DISB_DTL_ALL DDTLV
, IGF_AW_AWD_DISB_ALL ADISB
, IGF_AW_AWARD_ALL AWAD
, IGF_AP_FA_BASE_REC_ALL BASE
, IGS_CA_INST_ALL LD
, IGS_CA_INST_ALL TP
, IGS_CA_INST_ALL CI
, HZ_PARTIES PE
WHERE DDTLV.AWARD_ID = ADISB.AWARD_ID (+)
AND DDTLV.DISB_NUM = ADISB.DISB_NUM (+)
AND ADISB.AWARD_ID = AWAD.AWARD_ID (+)
AND ADISB.LD_CAL_TYPE = LD.CAL_TYPE
AND ADISB.LD_SEQUENCE_NUMBER = LD.SEQUENCE_NUMBER
AND ADISB.TP_CAL_TYPE =TP.CAL_TYPE(+)
AND ADISB.TP_SEQUENCE_NUMBER=TP.SEQUENCE_NUMBER(+)
AND AWAD.BASE_ID = BASE.BASE_ID (+)
AND BASE.CI_CAL_TYPE = CI.CAL_TYPE (+)
AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER(+)
AND BASE.PERSON_ID = PE.PARTY_ID (+) WITH READ ONLY