View: IGI_CIS_INVOICE_PAYMENTS

Product:	IGI - Public Sector Financials International
Description:	Displays records of invoice payments coupled with CIS Payment Voucher details.
Implementation/DBA Data:	APPS.IGI_CIS_INVOICE_PAYMENTS

View Text

SELECT AIP. ACCOUNTING_EVENT_ID
, AIP. ACCOUNTING_DATE
, AIP.ACCRUAL_POSTED_FLAG
, AIP. AMOUNT
, CASH_POSTED_FLAG
, AIP.CHECK_ID
, AIP.INVOICE_ID
, AIP.INVOICE_PAYMENT_ID
, AIP.LAST_UPDATED_BY
, AIP. LAST_UPDATE_DATE
, AIP. PAYMENT_NUM
, AIP.PERIOD_NAME
, AIP. POSTED_FLAG
, AIP.SET_OF_BOOKS_ID
, AIP. ACCTS_PAY_CODE_COMBINATION_ID
, AIP.ASSET_CODE_COMBINATION_ID
, AIP. CREATED_BY
, AIP.CREATION_DATE
, AIP. LAST_UPDATE_LOGIN
, AIP.BANK_ACCOUNT_NUM
, AIP. BANK_ACCOUNT_TYPE
, AIP. BANK_NUM
, AIP. DISCOUNT_LOST
, AIP. DISCOUNT_TAKEN
, AIP. EXCHANGE_DATE
, AIP. EXCHANGE_RATE
, AIP. EXCHANGE_RATE_TYPE
, AIP. GAIN_CODE_COMBINATION_ID
, AIP. INVOICE_BASE_AMOUNT
, AIP. LOSS_CODE_COMBINATION_ID
, AIP.PAYMENT_BASE_AMOUNT
, AIP.ATTRIBUTE1
, AIP.ATTRIBUTE10
, AIP.ATTRIBUTE11
, AIP.ATTRIBUTE12
, AIP.ATTRIBUTE13
, AIP.ATTRIBUTE14
, AIP. ATTRIBUTE15
, AIP.ATTRIBUTE2
, AIP. ATTRIBUTE3
, AIP. ATTRIBUTE4
, AIP. ATTRIBUTE5
, AIP. ATTRIBUTE6
, AIP.ATTRIBUTE7
, AIP.ATTRIBUTE8
, AIP.ATTRIBUTE9
, AIP. ATTRIBUTE_CATEGORY
, AIP.CASH_JE_BATCH_ID
, AIP. FUTURE_PAY_CODE_COMBINATION_ID
, AIP. FUTURE_PAY_POSTED_FLAG
, AIP.JE_BATCH_ID
, AIP. ELECTRONIC_TRANSFER_ID
, AIP. ASSETS_ADDITION_FLAG
, AIP. INVOICE_PAYMENT_TYPE
, AIP. OTHER_INVOICE_ID
, AIP.ORG_ID
, AIP.GLOBAL_ATTRIBUTE_CATEGORY
, AIP. GLOBAL_ATTRIBUTE1
, AIP.GLOBAL_ATTRIBUTE2
, AIP.GLOBAL_ATTRIBUTE3
, AIP. GLOBAL_ATTRIBUTE4
, AIP.GLOBAL_ATTRIBUTE5
, AIP. GLOBAL_ATTRIBUTE6
, AIP. GLOBAL_ATTRIBUTE7
, AIP.GLOBAL_ATTRIBUTE8
, AIP. GLOBAL_ATTRIBUTE9
, AIP. GLOBAL_ATTRIBUTE10
, AIP.GLOBAL_ATTRIBUTE11
, AIP.GLOBAL_ATTRIBUTE12
, AIP. GLOBAL_ATTRIBUTE13
, AIP.GLOBAL_ATTRIBUTE14
, AIP.GLOBAL_ATTRIBUTE15
, AIP. GLOBAL_ATTRIBUTE16
, AIP.GLOBAL_ATTRIBUTE17
, AIP.GLOBAL_ATTRIBUTE18
, AIP. GLOBAL_ATTRIBUTE19
, AIP.GLOBAL_ATTRIBUTE20
, AIP.EXTERNAL_BANK_ACCOUNT_ID
, AIP. MRC_EXCHANGE_DATE
, AIP. MRC_EXCHANGE_RATE
, AIP. MRC_EXCHANGE_RATE_TYPE
, AIP. MRC_GAIN_CODE_COMBINATION_ID
, AIP.MRC_INVOICE_BASE_AMOUNT
, AIP. MRC_LOSS_CODE_COMBINATION_ID
, AIP. MRC_PAYMENT_BASE_AMOUNT
, AIP. REVERSAL_FLAG
, AIP.REVERSAL_INV_PMT_ID
, ICPV.ROW_ID
, ICPV.PMT_VCH_NUMBER
, ICPV.PMT_VCH_AMOUNT
, ICPV.PMT_VCH_RECEIVED_DATE
, ICPV.PMT_VCH_DESCRIPTION
FROM AP_INVOICE_PAYMENTS AIP
, IGI_CIS_PAYMENT_VOUCHERS ICPV
WHERE AIP.INVOICE_PAYMENT_ID = ICPV.INVOICE_PAYMENT_ID (+)

Columns