Product: | IGF - Financial Aid |
---|---|
Description: | Base 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.IGFBV_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