View: AP_INVOICE_PAYMENTS_V

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

View Text

SELECT AIP.ROWID ROW_ID
, AIP.ACCOUNTING_DATE ACCOUNTING_DATE
, AIP.ACCRUAL_POSTED_FLAG ACCRUAL_POSTED_FLAG
, AIP.ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, AIP.AMOUNT AMOUNT
, AIP.ASSETS_ADDITION_FLAG ASSETS_ADDITION_FLAG
, 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
, AIP.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, AIP.BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, AIP.BANK_NUM BANK_NUM
, AIP.CASH_JE_BATCH_ID CASH_JE_BATCH_ID
, AIP.CASH_POSTED_FLAG CASH_POSTED_FLAG
, AIP.CHECK_ID CHECK_ID
, AIP.CREATED_BY CREATED_BY
, AIP.CREATION_DATE CREATION_DATE
, AIP.DISCOUNT_LOST DISCOUNT_LOST
, AIP.DISCOUNT_TAKEN DISCOUNT_TAKEN
, AIP.EXCHANGE_DATE EXCHANGE_DATE
, AIP.EXCHANGE_RATE EXCHANGE_RATE
, AIP.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, AIP.FUTURE_PAY_CODE_COMBINATION_ID FUTURE_PAY_CODE_COMBINATION_ID
, AIP.FUTURE_PAY_POSTED_FLAG FUTURE_PAY_POSTED_FLAG
, AIP.GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID
, AIP.INVOICE_BASE_AMOUNT INVOICE_BASE_AMOUNT
, AIP.INVOICE_ID INVOICE_ID
, AIP.INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
, AIP.JE_BATCH_ID JE_BATCH_ID
, AIP.LAST_UPDATED_BY LAST_UPDATED_BY
, AIP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AIP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AIP.LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID
, 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.OTHER_INVOICE_ID OTHER_INVOICE_ID
, AC.CHECK_NUMBER CHECK_NUMBER
, AC.CHECK_DATE CHECK_DATE
, AC.AMOUNT CHECK_AMOUNT
, IBY1.PAYMENT_METHOD_NAME CHECK_TYPE
, ALC2.DISPLAYED_FIELD CHECK_STATUS
, ALC3.DISPLAYED_FIELD PAYMENT_TYPE
, AI.INVOICE_NUM INVOICE_NUM
, AI.INVOICE_DATE INVOICE_DATE
, AI.INVOICE_AMOUNT INVOICE_AMOUNT
, AI.AMOUNT_PAID AMOUNT_PAID
, AI.DESCRIPTION DESCRIPTION
, GJB.NAME JE_BATCH_NAME
, GSOB.NAME SET_OF_BOOKS_NAME
, AIP.EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, APS.EXTERNAL_BANK_ACCOUNT_ID APS_EXTERNAL_BANK_ACCOUNT_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.ORG_ID ORG_ID
, AC.PAYMENT_ID
, AIP.REVERSAL_INV_PMT_ID /*BUG4879944*/
, AIP.REVERSAL_FLAG /*BUG4879944*/ /* BUG 7535348*/
, AIP.REMIT_TO_SUPPLIER_NAME
, AIP.REMIT_TO_SUPPLIER_ID
, AIP.REMIT_TO_SUPPLIER_SITE
, AIP.REMIT_TO_SUPPLIER_SITE_ID
, AI.RELATIONSHIP_ID /* BUG 7535348*/
FROM AP_INVOICE_PAYMENTS AIP
, AP_INVOICES_ALL AI
, AP_CHECKS_ALL AC
, IBY_PAYMENT_METHODS_VL IBY1
, AP_LOOKUP_CODES ALC2
, AP_LOOKUP_CODES ALC3
, GL_JE_BATCHES GJB
, GL_SETS_OF_BOOKS GSOB
, AP_PAYMENT_SCHEDULES_ALL APS
WHERE AIP.INVOICE_ID = AI.INVOICE_ID
AND AIP.CHECK_ID = AC.CHECK_ID
AND IBY1.PAYMENT_METHOD_CODE (+) = AC.PAYMENT_METHOD_CODE
AND ALC2.LOOKUP_TYPE (+) = 'CHECK STATE'
AND ALC2.LOOKUP_CODE (+) = AC.STATUS_LOOKUP_CODE
AND ALC3.LOOKUP_TYPE (+) = 'NLS TRANSLATION'
AND ALC3.LOOKUP_CODE (+) = AIP.INVOICE_PAYMENT_TYPE
AND AIP.JE_BATCH_ID = GJB.JE_BATCH_ID (+)
AND AIP.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND APS.INVOICE_ID = AIP.INVOICE_ID
AND APS.PAYMENT_NUM = AIP.PAYMENT_NUM

Columns