VIEW: APPS.IGFFV_AWARD_DISBURSEMENTS

Source

View Text - Preformatted

SELECT AAD.AWARD_ID, AAD.DISB_NUM, AAD.DISB_GROSS_AMT, AAD.FEE_1, AAD.FEE_2, AAD.DISB_NET_AMT, AAD.DISB_DATE, '_LA:AAD.TRANS_TYPE:IGF_LOOKUPS_VIEW:IGF_DB_TRANS_TYPE:MEANING', '_LA:AAD.ELIG_STATUS:IGF_LOOKUPS_VIEW:IGF_DB_ELIG_STATUS:MEANING', AAD.ELIG_STATUS_DATE, '_LA:AAD.AFFIRM_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:AAD.HOLD_REL_IND:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_HOLD_REL_IND:MEANING', '_LA:AAD.MANUAL_HOLD_IND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', AAD.DISB_STATUS, AAD.DISB_STATUS_DATE, '_LA:AAD.LATE_DISB_IND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:AAD.FUND_DIST_MTHD:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_FUND_DISB_METH:MEANING', '_LA:AAD.PREV_REPORTED_IND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', AAD.FUND_RELEASE_DATE, '_LA:AAD.FUND_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_FUND_STATUS:MEANING', AAD.FUND_STATUS_DATE, AAD.FEE_PAID_1, AAD.FEE_PAID_2, AAD.CHEQUE_NUMBER, AAD.DISB_ACCEPTED_AMT, AAD.DISB_PAID_AMT, AAD.RVSN_ID, AAD.INT_REBATE_AMT, '_LA:AAD.FORCE_DISB:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', AAD.MIN_CREDIT_PTS, AAD.DISB_EXP_DT, AAD.VERF_ENFR_DT, AAD.NOTIFICATION_SENT, AAD.NOTIFICATION_DATE, AAD.AUTH_DATE, '_LA:AAD.FEE_CLASS:IGS_LOOKUP_VALUES:FEE_CLASS:MEANING', '_LA:AAD.SHOW_ON_BILL:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', PE.PARTY_NUMBER, PE.PARTY_NAME, CI.ALTERNATE_CODE, CI.DESCRIPTION, LD.ALTERNATE_CODE, LD.DESCRIPTION, LD.START_DT, LD.END_DT, TP.ALTERNATE_CODE, TP.DESCRIPTION, TP.START_DT, TP.END_DT, RVSN.DESCP, AAD.AUTH_ID, AAD.TP_CAL_TYPE, AAD.TP_SEQUENCE_NUMBER, AAD.LD_CAL_TYPE, AAD.LD_SEQUENCE_NUMBER, AAD.CREATED_BY, AAD.CREATION_DATE, AAD.LAST_UPDATED_BY, AAD.LAST_UPDATE_DATE , BASE.PERSON_ID FROM IGF_AW_AWD_DISB_ALL AAD, IGS_CA_INST_ALL LD, IGS_CA_INST_ALL TP, IGS_CA_INST_ALL CI, IGF_AW_AWARD_ALL AWD, IGF_AP_FA_BASE_REC_ALL BASE, HZ_PARTIES PE, IGF_AW_AWD_RVSN_RSN_ALL RVSN WHERE AAD.AWARD_ID = AWD.AWARD_ID AND AAD.TP_CAL_TYPE =TP.CAL_TYPE(+) AND AAD.TP_SEQUENCE_NUMBER=TP.SEQUENCE_NUMBER(+) AND AAD.LD_CAL_TYPE = LD.CAL_TYPE AND AAD.LD_SEQUENCE_NUMBER = LD.SEQUENCE_NUMBER AND AWD.BASE_ID = BASE.BASE_ID AND BASE.CI_CAL_TYPE = CI.CAL_TYPE AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND PE.PARTY_ID = BASE.PERSON_ID AND AAD.RVSN_ID = RVSN.RVSN_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT AAD.AWARD_ID
, AAD.DISB_NUM
, AAD.DISB_GROSS_AMT
, AAD.FEE_1
, AAD.FEE_2
, AAD.DISB_NET_AMT
, AAD.DISB_DATE
, '_LA:AAD.TRANS_TYPE:IGF_LOOKUPS_VIEW:IGF_DB_TRANS_TYPE:MEANING'
, '_LA:AAD.ELIG_STATUS:IGF_LOOKUPS_VIEW:IGF_DB_ELIG_STATUS:MEANING'
, AAD.ELIG_STATUS_DATE
, '_LA:AAD.AFFIRM_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:AAD.HOLD_REL_IND:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_HOLD_REL_IND:MEANING'
, '_LA:AAD.MANUAL_HOLD_IND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, AAD.DISB_STATUS
, AAD.DISB_STATUS_DATE
, '_LA:AAD.LATE_DISB_IND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:AAD.FUND_DIST_MTHD:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_FUND_DISB_METH:MEANING'
, '_LA:AAD.PREV_REPORTED_IND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, AAD.FUND_RELEASE_DATE
, '_LA:AAD.FUND_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_FUND_STATUS:MEANING'
, AAD.FUND_STATUS_DATE
, AAD.FEE_PAID_1
, AAD.FEE_PAID_2
, AAD.CHEQUE_NUMBER
, AAD.DISB_ACCEPTED_AMT
, AAD.DISB_PAID_AMT
, AAD.RVSN_ID
, AAD.INT_REBATE_AMT
, '_LA:AAD.FORCE_DISB:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, AAD.MIN_CREDIT_PTS
, AAD.DISB_EXP_DT
, AAD.VERF_ENFR_DT
, AAD.NOTIFICATION_SENT
, AAD.NOTIFICATION_DATE
, AAD.AUTH_DATE
, '_LA:AAD.FEE_CLASS:IGS_LOOKUP_VALUES:FEE_CLASS:MEANING'
, '_LA:AAD.SHOW_ON_BILL:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, PE.PARTY_NUMBER
, PE.PARTY_NAME
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, LD.ALTERNATE_CODE
, LD.DESCRIPTION
, LD.START_DT
, LD.END_DT
, TP.ALTERNATE_CODE
, TP.DESCRIPTION
, TP.START_DT
, TP.END_DT
, RVSN.DESCP
, AAD.AUTH_ID
, AAD.TP_CAL_TYPE
, AAD.TP_SEQUENCE_NUMBER
, AAD.LD_CAL_TYPE
, AAD.LD_SEQUENCE_NUMBER
, AAD.CREATED_BY
, AAD.CREATION_DATE
, AAD.LAST_UPDATED_BY
, AAD.LAST_UPDATE_DATE
, BASE.PERSON_ID
FROM IGF_AW_AWD_DISB_ALL AAD
, IGS_CA_INST_ALL LD
, IGS_CA_INST_ALL TP
, IGS_CA_INST_ALL CI
, IGF_AW_AWARD_ALL AWD
, IGF_AP_FA_BASE_REC_ALL BASE
, HZ_PARTIES PE
, IGF_AW_AWD_RVSN_RSN_ALL RVSN
WHERE AAD.AWARD_ID = AWD.AWARD_ID
AND AAD.TP_CAL_TYPE =TP.CAL_TYPE(+)
AND AAD.TP_SEQUENCE_NUMBER=TP.SEQUENCE_NUMBER(+)
AND AAD.LD_CAL_TYPE = LD.CAL_TYPE
AND AAD.LD_SEQUENCE_NUMBER = LD.SEQUENCE_NUMBER
AND AWD.BASE_ID = BASE.BASE_ID
AND BASE.CI_CAL_TYPE = CI.CAL_TYPE
AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND PE.PARTY_ID = BASE.PERSON_ID
AND AAD.RVSN_ID = RVSN.RVSN_ID(+) WITH READ ONLY