View: AP_INVOICE_PAYMENT_HISTORY_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_INVOICE_PAYMENT_HISTORY_V

View Text

SELECT AIP.ROWID ROW_ID
, AIP.ACCOUNTING_DATE ACCOUNTING_DATE
, AIP.AMOUNT AMOUNT
, AIP.CHECK_ID CHECK_ID
, AIP.CREATED_BY CREATED_BY
, AIP.CREATION_DATE CREATION_DATE
, AIP.DISCOUNT_TAKEN DISCOUNT_TAKEN
, AIP.INVOICE_BASE_AMOUNT INVOICE_BASE_AMOUNT
, AIP.INVOICE_ID INVOICE_ID
, AIP.INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
, AIP.LAST_UPDATED_BY LAST_UPDATED_BY
, AIP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AIP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AIP.PAYMENT_BASE_AMOUNT PAYMENT_BASE_AMOUNT
, AIP.PAYMENT_NUM PAYMENT_NUM
, AIP.PERIOD_NAME PERIOD_NAME
, AIP.POSTED_FLAG POSTED_FLAG
, AIP.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AIP.INVOICE_PAYMENT_TYPE INVOICE_PAYMENT_TYPE
, AIP.ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, AIP.ASSET_CODE_COMBINATION_ID ASSET_CODE_COMBINATION_ID
, AIP.ATTRIBUTE1 ATTRIBUTE1
, AIP.ATTRIBUTE10 ATTRIBUTE10
, AIP.ATTRIBUTE11 ATTRIBUTE11
, AIP.ATTRIBUTE12 ATTRIBUTE12
, AIP.ATTRIBUTE13 ATTRIBUTE13
, AIP.ATTRIBUTE14 ATTRIBUTE14
, AIP.ATTRIBUTE15 ATTRIBUTE15
, AIP.ATTRIBUTE2 ATTRIBUTE2
, AIP.ATTRIBUTE3 ATTRIBUTE3
, AIP.ATTRIBUTE4 ATTRIBUTE4
, AIP.ATTRIBUTE5 ATTRIBUTE5
, AIP.ATTRIBUTE6 ATTRIBUTE6
, AIP.ATTRIBUTE7 ATTRIBUTE7
, AIP.ATTRIBUTE8 ATTRIBUTE8
, AIP.ATTRIBUTE9 ATTRIBUTE9
, AIP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, DECODE(AIP.INVOICE_PAYMENT_TYPE
, 'PREPAY'
, ALC1.DISPLAYED_FIELD
, IBY.PAYMENT_METHOD_NAME) PAYMENT_METHOD
, DECODE(AIP.INVOICE_PAYMENT_TYPE
, 'PREPAY'
, AI2.INVOICE_NUM
, AC.CHECK_NUMBER) DOCUMENT_NUMBER
, DECODE(AC.STATUS_LOOKUP_CODE
, 'VOIDED'
, 'Y'
, 'N') VOID
, AC.CHECK_DATE CHECK_DATE
, AC.AMOUNT CHECK_AMOUNT
, AI.INVOICE_NUM INVOICE_NUM
, AI.INVOICE_DATE INVOICE_DATE
, AI.INVOICE_AMOUNT INVOICE_AMOUNT
, AI.AMOUNT_PAID AMOUNT_PAID
, AI.DESCRIPTION DESCRIPTION
, AIP.OTHER_INVOICE_ID OTHER_INVOICE_ID
, AIP.ORG_ID ORG_ID
FROM AP_INVOICE_PAYMENTS AIP
, AP_INVOICES_ALL AI
, AP_INVOICES_ALL AI2
, AP_CHECKS_ALL AC
, AP_LOOKUP_CODES ALC1
, IBY_PAYMENT_METHODS_VL IBY
WHERE AIP.INVOICE_ID = AI.INVOICE_ID
AND AIP.OTHER_INVOICE_ID = AI2.INVOICE_ID (+)
AND AIP.CHECK_ID = AC.CHECK_ID
AND ALC1.LOOKUP_TYPE (+) = 'NLS TRANSLATION'
AND ALC1.LOOKUP_CODE (+) = 'PREPAY'
AND IBY.PAYMENT_METHOD_CODE(+) = AC.PAYMENT_METHOD_CODE

Columns