VIEW: APPS.IGSBV_PARTY_REFUNDS

Source

View Text - Preformatted

SELECT re.fee_type, re.fee_cal_type, re.reversal_ind, re.voucher_date, re.gl_date, re.refund_amount, '_LA:re.TRANSFER_STATUS:IGS_LOOKUP_VALUES:REFUND_TRANSFER_STATUS:MEANING', re.reason, re.reversal_gl_date, re.dr_account_cd, re.cr_account_cd, 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, re.dr_gl_ccid, re.cr_gl_ccid, re.refund_id, re.person_id, re.pay_person_id, re.fee_ci_sequence_number, re.invoice_id, re.source_refund_id, re.creation_date, re.created_by, re.last_update_date, re.last_updated_by FROM igs_fi_refunds re, hz_parties pa1, hz_parties pa2, igs_fi_fee_type_all fe, igs_ca_inst_all ci, igs_fi_inv_int_all iv WHERE re.person_id = pa1.party_id AND re.pay_person_id = pa2.party_id AND re.invoice_id = iv.invoice_id AND re.fee_type = fe.fee_type AND re.fee_cal_type = ci.cal_type AND re.fee_ci_sequence_number = ci.sequence_number WITH READ ONLY

View Text - HTML Formatted

SELECT RE.FEE_TYPE
, RE.FEE_CAL_TYPE
, RE.REVERSAL_IND
, RE.VOUCHER_DATE
, RE.GL_DATE
, RE.REFUND_AMOUNT
, '_LA:RE.TRANSFER_STATUS:IGS_LOOKUP_VALUES:REFUND_TRANSFER_STATUS:MEANING'
, RE.REASON
, RE.REVERSAL_GL_DATE
, RE.DR_ACCOUNT_CD
, RE.CR_ACCOUNT_CD
, 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
, RE.DR_GL_CCID
, RE.CR_GL_CCID
, RE.REFUND_ID
, RE.PERSON_ID
, RE.PAY_PERSON_ID
, RE.FEE_CI_SEQUENCE_NUMBER
, RE.INVOICE_ID
, RE.SOURCE_REFUND_ID
, RE.CREATION_DATE
, RE.CREATED_BY
, RE.LAST_UPDATE_DATE
, RE.LAST_UPDATED_BY
FROM IGS_FI_REFUNDS RE
, HZ_PARTIES PA1
, HZ_PARTIES PA2
, IGS_FI_FEE_TYPE_ALL FE
, IGS_CA_INST_ALL CI
, IGS_FI_INV_INT_ALL IV
WHERE RE.PERSON_ID = PA1.PARTY_ID
AND RE.PAY_PERSON_ID = PA2.PARTY_ID
AND RE.INVOICE_ID = IV.INVOICE_ID
AND RE.FEE_TYPE = FE.FEE_TYPE
AND RE.FEE_CAL_TYPE = CI.CAL_TYPE
AND RE.FEE_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY