VIEW: APPS.IGS_FI_REFUNDS_V

Source

View Text - Preformatted

SELECT rfnd.rowid, rfnd.refund_id, rfnd.voucher_date, rfnd.person_id, rfnd.pay_person_id, pe.person_number, pe.full_name, rfnd.dr_gl_ccid, rfnd.cr_gl_ccid, rfnd.dr_account_cd, acc1.description, rfnd.cr_account_cd, acc2.description, rfnd.refund_amount, rfnd.fee_type, rfnd.fee_cal_type, rfnd.fee_ci_sequence_number, ci.start_dt, ci.end_dt, cat.description, rfnd.payment_number, rfnd.payment_date, rfnd.payment_mode, NULL, rfnd.source_refund_id, rfnd.invoice_id, inv.invoice_number, rfnd.transfer_status, lkp1.meaning, rfnd.reversal_ind, rfnd.reason, rfnd.attribute_category, rfnd.attribute1, rfnd.attribute2, rfnd.attribute3, rfnd.attribute4, rfnd.attribute5, rfnd.attribute6, rfnd.attribute7, rfnd.attribute8, rfnd.attribute9, rfnd.attribute10, rfnd.attribute11, rfnd.attribute12, rfnd.attribute13, rfnd.attribute14, rfnd.attribute15, rfnd.attribute16, rfnd.attribute17, rfnd.attribute18, rfnd.attribute19, rfnd.attribute20, rfnd.created_by, rfnd.creation_date, rfnd.last_updated_by, rfnd.last_update_date, rfnd.last_update_login, rfnd.request_id, rfnd.program_application_id, rfnd.program_id, rfnd.program_update_date, rfnd.gl_date, rfnd.reversal_gl_date from igs_fi_refunds rfnd, igs_lookup_values lkp1, igs_fi_parties_v pe, igs_ca_type cat, igs_ca_inst ci, igs_fi_inv_int inv, igs_fi_acc acc1, igs_fi_acc acc2 WHERE rfnd.pay_person_id=pe.person_id and rfnd.fee_cal_type=ci.cal_type and rfnd.fee_ci_sequence_number=ci.sequence_number and rfnd.fee_cal_type=cat.cal_type and rfnd.invoice_id=inv.invoice_id(+) and rfnd.transfer_status=lkp1.lookup_code and lkp1.lookup_type='REFUND_TRANSFER_STATUS' and acc1.account_cd(+) =rfnd.dr_account_cd and acc2.account_cd(+) =rfnd.cr_account_cd

View Text - HTML Formatted

SELECT RFND.ROWID
, RFND.REFUND_ID
, RFND.VOUCHER_DATE
, RFND.PERSON_ID
, RFND.PAY_PERSON_ID
, PE.PERSON_NUMBER
, PE.FULL_NAME
, RFND.DR_GL_CCID
, RFND.CR_GL_CCID
, RFND.DR_ACCOUNT_CD
, ACC1.DESCRIPTION
, RFND.CR_ACCOUNT_CD
, ACC2.DESCRIPTION
, RFND.REFUND_AMOUNT
, RFND.FEE_TYPE
, RFND.FEE_CAL_TYPE
, RFND.FEE_CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CAT.DESCRIPTION
, RFND.PAYMENT_NUMBER
, RFND.PAYMENT_DATE
, RFND.PAYMENT_MODE
, NULL
, RFND.SOURCE_REFUND_ID
, RFND.INVOICE_ID
, INV.INVOICE_NUMBER
, RFND.TRANSFER_STATUS
, LKP1.MEANING
, RFND.REVERSAL_IND
, RFND.REASON
, RFND.ATTRIBUTE_CATEGORY
, RFND.ATTRIBUTE1
, RFND.ATTRIBUTE2
, RFND.ATTRIBUTE3
, RFND.ATTRIBUTE4
, RFND.ATTRIBUTE5
, RFND.ATTRIBUTE6
, RFND.ATTRIBUTE7
, RFND.ATTRIBUTE8
, RFND.ATTRIBUTE9
, RFND.ATTRIBUTE10
, RFND.ATTRIBUTE11
, RFND.ATTRIBUTE12
, RFND.ATTRIBUTE13
, RFND.ATTRIBUTE14
, RFND.ATTRIBUTE15
, RFND.ATTRIBUTE16
, RFND.ATTRIBUTE17
, RFND.ATTRIBUTE18
, RFND.ATTRIBUTE19
, RFND.ATTRIBUTE20
, RFND.CREATED_BY
, RFND.CREATION_DATE
, RFND.LAST_UPDATED_BY
, RFND.LAST_UPDATE_DATE
, RFND.LAST_UPDATE_LOGIN
, RFND.REQUEST_ID
, RFND.PROGRAM_APPLICATION_ID
, RFND.PROGRAM_ID
, RFND.PROGRAM_UPDATE_DATE
, RFND.GL_DATE
, RFND.REVERSAL_GL_DATE
FROM IGS_FI_REFUNDS RFND
, IGS_LOOKUP_VALUES LKP1
, IGS_FI_PARTIES_V PE
, IGS_CA_TYPE CAT
, IGS_CA_INST CI
, IGS_FI_INV_INT INV
, IGS_FI_ACC ACC1
, IGS_FI_ACC ACC2
WHERE RFND.PAY_PERSON_ID=PE.PERSON_ID
AND RFND.FEE_CAL_TYPE=CI.CAL_TYPE
AND RFND.FEE_CI_SEQUENCE_NUMBER=CI.SEQUENCE_NUMBER
AND RFND.FEE_CAL_TYPE=CAT.CAL_TYPE
AND RFND.INVOICE_ID=INV.INVOICE_ID(+)
AND RFND.TRANSFER_STATUS=LKP1.LOOKUP_CODE
AND LKP1.LOOKUP_TYPE='REFUND_TRANSFER_STATUS'
AND ACC1.ACCOUNT_CD(+) =RFND.DR_ACCOUNT_CD
AND ACC2.ACCOUNT_CD(+) =RFND.CR_ACCOUNT_CD