VIEW: APPS.AP_INVOICE_PAYMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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