VIEW: APPS.IGI_CIS_INVOICE_PAYMENTS

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)