VIEW: APPS.IGSFV_PARTY_REFUNDS

Source

View Text - Preformatted

SELECT re1.fee_type, re1.fee_cal_type, re1.reversal_ind, re1.voucher_date, re1.gl_date, re1.refund_amount, '_LA:re1.TRANSFER_STATUS:IGS_LOOKUP_VALUES:REFUND_TRANSFER_STATUS:MEANING', re1.reason, re1.reversal_gl_date, re1.dr_account_cd, re1.cr_account_cd, '_KF:SQLGL:GL#:gcc1', '_KF:SQLGL:GL#:gcc2', pa1.party_number, pa1.party_name, pa2.party_number, pa2.party_name, fe.description, ci.start_dt, ci.end_dt, ci.description, ci.alternate_code, iv.invoice_number, ac1.description, ac2.description, re2.voucher_date, '_DF:IGS:IGS_FI_REFUNDS_FLEX:re1', re1.dr_gl_ccid, re1.cr_gl_ccid, re1.refund_id, re1.person_id, re1.pay_person_id, re1.fee_ci_sequence_number, re1.invoice_id, re1.source_refund_id, re1.creation_date, re1.created_by, re1.last_update_date, re1.last_updated_by FROM igs_fi_refunds re1, igs_fi_refunds re2, hz_parties pa1, hz_parties pa2, igs_fi_fee_type_all fe, igs_ca_inst_all ci, igs_fi_inv_int_all iv, igs_fi_acc_all ac1, igs_fi_acc_all ac2, gl_code_combinations gcc1, gl_code_combinations gcc2 WHERE re1.source_refund_id = re2.refund_id(+) AND re1.person_id = pa1.party_id AND re1.pay_person_id = pa2.party_id AND re1.invoice_id = iv.invoice_id AND re1.fee_type = fe.fee_type AND re1.fee_cal_type = ci.cal_type AND re1.fee_ci_sequence_number = ci.sequence_number AND re1.dr_account_cd = ac1.account_cd(+) AND re1.cr_account_cd = ac2.account_cd(+) AND re1.dr_gl_ccid = gcc1.code_combination_id(+) AND re1.cr_gl_ccid = gcc2.code_combination_id(+) WITH READ ONLY

View Text - HTML Formatted

SELECT RE1.FEE_TYPE
, RE1.FEE_CAL_TYPE
, RE1.REVERSAL_IND
, RE1.VOUCHER_DATE
, RE1.GL_DATE
, RE1.REFUND_AMOUNT
, '_LA:RE1.TRANSFER_STATUS:IGS_LOOKUP_VALUES:REFUND_TRANSFER_STATUS:MEANING'
, RE1.REASON
, RE1.REVERSAL_GL_DATE
, RE1.DR_ACCOUNT_CD
, RE1.CR_ACCOUNT_CD
, '_KF:SQLGL:GL#:GCC1'
, '_KF:SQLGL:GL#:GCC2'
, PA1.PARTY_NUMBER
, PA1.PARTY_NAME
, PA2.PARTY_NUMBER
, PA2.PARTY_NAME
, FE.DESCRIPTION
, CI.START_DT
, CI.END_DT
, CI.DESCRIPTION
, CI.ALTERNATE_CODE
, IV.INVOICE_NUMBER
, AC1.DESCRIPTION
, AC2.DESCRIPTION
, RE2.VOUCHER_DATE
, '_DF:IGS:IGS_FI_REFUNDS_FLEX:RE1'
, RE1.DR_GL_CCID
, RE1.CR_GL_CCID
, RE1.REFUND_ID
, RE1.PERSON_ID
, RE1.PAY_PERSON_ID
, RE1.FEE_CI_SEQUENCE_NUMBER
, RE1.INVOICE_ID
, RE1.SOURCE_REFUND_ID
, RE1.CREATION_DATE
, RE1.CREATED_BY
, RE1.LAST_UPDATE_DATE
, RE1.LAST_UPDATED_BY
FROM IGS_FI_REFUNDS RE1
, IGS_FI_REFUNDS RE2
, HZ_PARTIES PA1
, HZ_PARTIES PA2
, IGS_FI_FEE_TYPE_ALL FE
, IGS_CA_INST_ALL CI
, IGS_FI_INV_INT_ALL IV
, IGS_FI_ACC_ALL AC1
, IGS_FI_ACC_ALL AC2
, GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
WHERE RE1.SOURCE_REFUND_ID = RE2.REFUND_ID(+)
AND RE1.PERSON_ID = PA1.PARTY_ID
AND RE1.PAY_PERSON_ID = PA2.PARTY_ID
AND RE1.INVOICE_ID = IV.INVOICE_ID
AND RE1.FEE_TYPE = FE.FEE_TYPE
AND RE1.FEE_CAL_TYPE = CI.CAL_TYPE
AND RE1.FEE_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND RE1.DR_ACCOUNT_CD = AC1.ACCOUNT_CD(+)
AND RE1.CR_ACCOUNT_CD = AC2.ACCOUNT_CD(+)
AND RE1.DR_GL_CCID = GCC1.CODE_COMBINATION_ID(+)
AND RE1.CR_GL_CCID = GCC2.CODE_COMBINATION_ID(+) WITH READ ONLY