VIEW: APPS.AP_PAYMENT_SCHEDULES_V

Source

View Text - Preformatted

SELECT APS.ROWID ROW_ID , APS.AMOUNT_REMAINING AMOUNT_REMAINING , APS.ATTRIBUTE1 ATTRIBUTE1 , APS.ATTRIBUTE10 ATTRIBUTE10 , APS.ATTRIBUTE11 ATTRIBUTE11 , APS.ATTRIBUTE12 ATTRIBUTE12 , APS.ATTRIBUTE13 ATTRIBUTE13 , APS.ATTRIBUTE14 ATTRIBUTE14 , APS.ATTRIBUTE15 ATTRIBUTE15 , APS.ATTRIBUTE2 ATTRIBUTE2 , APS.ATTRIBUTE3 ATTRIBUTE3 , APS.ATTRIBUTE4 ATTRIBUTE4 , APS.ATTRIBUTE5 ATTRIBUTE5 , APS.ATTRIBUTE6 ATTRIBUTE6 , APS.ATTRIBUTE7 ATTRIBUTE7 , APS.ATTRIBUTE8 ATTRIBUTE8 , APS.ATTRIBUTE9 ATTRIBUTE9 , APS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , APS.BATCH_ID BATCH_ID , APS.CREATED_BY CREATED_BY , APS.CREATION_DATE CREATION_DATE , APS.DISCOUNT_AMOUNT_AVAILABLE DISCOUNT_AMOUNT_AVAILABLE , APS.DISCOUNT_AMOUNT_REMAINING DISCOUNT_AMOUNT_REMAINING , APS.DISCOUNT_DATE DISCOUNT_DATE , APS.DUE_DATE DUE_DATE , APS.FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE , APS.GROSS_AMOUNT GROSS_AMOUNT , APS.HOLD_FLAG HOLD_FLAG , APS.INVOICE_ID INVOICE_ID , APS.LAST_UPDATED_BY LAST_UPDATED_BY , APS.LAST_UPDATE_DATE LAST_UPDATE_DATE , APS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , APS.PAYMENT_CROSS_RATE PAYMENT_CROSS_RATE , APS.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE , APS.PAYMENT_NUM PAYMENT_NUM , APS.PAYMENT_PRIORITY PAYMENT_PRIORITY , APS.PAYMENT_STATUS_FLAG PAYMENT_STATUS_FLAG , APS.SECOND_DISCOUNT_DATE SECOND_DISCOUNT_DATE , APS.SECOND_DISC_AMT_AVAILABLE SECOND_DISC_AMT_AVAILABLE , APS.THIRD_DISCOUNT_DATE THIRD_DISCOUNT_DATE , APS.THIRD_DISC_AMT_AVAILABLE THIRD_DISC_AMT_AVAILABLE , AB.BATCH_NAME BATCH_NAME , AI.INVOICE_NUM INVOICE_NUM , AP_INVOICE_PAYMENTS_PKG.GET_PAID_BY( AI.INVOICE_ID, APS.PAYMENT_NUM) PAID_BY , AP_INVOICE_PAYMENTS_PKG.GET_PAID_DATE( AI.INVOICE_ID, APS.PAYMENT_NUM) PAID_DATE , AP_INVOICE_PAYMENTS_PKG.GET_PAYMENT_ID( AI.INVOICE_ID, APS.PAYMENT_NUM) PAYMENT_ID , AP_INVOICE_PAYMENTS_PKG.GET_PAYMENT_TYPE( AI.INVOICE_ID, APS.PAYMENT_NUM) PAYMENT_TYPE , APS.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY , APS.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1 , APS.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2 , APS.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3 , APS.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4 , APS.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5 , APS.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6 , APS.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7 , APS.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8 , APS.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9 , APS.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10 , APS.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11 , APS.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12 , APS.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13 , APS.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14 , APS.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15 , APS.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16 , APS.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17 , APS.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18 , APS.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19 , APS.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20 , APS.ORG_ID ORG_ID /* Bug 7535348*/ , APS.REMIT_TO_SUPPLIER_NAME , APS.REMIT_TO_SUPPLIER_ID , APS.REMIT_TO_SUPPLIER_SITE , APS.REMIT_TO_SUPPLIER_SITE_ID , APS.RELATIONSHIP_ID /* Bug 7535348*/ FROM AP_PAYMENT_SCHEDULES APS, AP_BATCHES_ALL AB, AP_INVOICES_ALL AI WHERE APS.BATCH_ID = AB.BATCH_ID (+) AND APS.INVOICE_ID = AI.INVOICE_ID

View Text - HTML Formatted

SELECT APS.ROWID ROW_ID
, APS.AMOUNT_REMAINING AMOUNT_REMAINING
, APS.ATTRIBUTE1 ATTRIBUTE1
, APS.ATTRIBUTE10 ATTRIBUTE10
, APS.ATTRIBUTE11 ATTRIBUTE11
, APS.ATTRIBUTE12 ATTRIBUTE12
, APS.ATTRIBUTE13 ATTRIBUTE13
, APS.ATTRIBUTE14 ATTRIBUTE14
, APS.ATTRIBUTE15 ATTRIBUTE15
, APS.ATTRIBUTE2 ATTRIBUTE2
, APS.ATTRIBUTE3 ATTRIBUTE3
, APS.ATTRIBUTE4 ATTRIBUTE4
, APS.ATTRIBUTE5 ATTRIBUTE5
, APS.ATTRIBUTE6 ATTRIBUTE6
, APS.ATTRIBUTE7 ATTRIBUTE7
, APS.ATTRIBUTE8 ATTRIBUTE8
, APS.ATTRIBUTE9 ATTRIBUTE9
, APS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, APS.BATCH_ID BATCH_ID
, APS.CREATED_BY CREATED_BY
, APS.CREATION_DATE CREATION_DATE
, APS.DISCOUNT_AMOUNT_AVAILABLE DISCOUNT_AMOUNT_AVAILABLE
, APS.DISCOUNT_AMOUNT_REMAINING DISCOUNT_AMOUNT_REMAINING
, APS.DISCOUNT_DATE DISCOUNT_DATE
, APS.DUE_DATE DUE_DATE
, APS.FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE
, APS.GROSS_AMOUNT GROSS_AMOUNT
, APS.HOLD_FLAG HOLD_FLAG
, APS.INVOICE_ID INVOICE_ID
, APS.LAST_UPDATED_BY LAST_UPDATED_BY
, APS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, APS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, APS.PAYMENT_CROSS_RATE PAYMENT_CROSS_RATE
, APS.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, APS.PAYMENT_NUM PAYMENT_NUM
, APS.PAYMENT_PRIORITY PAYMENT_PRIORITY
, APS.PAYMENT_STATUS_FLAG PAYMENT_STATUS_FLAG
, APS.SECOND_DISCOUNT_DATE SECOND_DISCOUNT_DATE
, APS.SECOND_DISC_AMT_AVAILABLE SECOND_DISC_AMT_AVAILABLE
, APS.THIRD_DISCOUNT_DATE THIRD_DISCOUNT_DATE
, APS.THIRD_DISC_AMT_AVAILABLE THIRD_DISC_AMT_AVAILABLE
, AB.BATCH_NAME BATCH_NAME
, AI.INVOICE_NUM INVOICE_NUM
, AP_INVOICE_PAYMENTS_PKG.GET_PAID_BY( AI.INVOICE_ID
, APS.PAYMENT_NUM) PAID_BY
, AP_INVOICE_PAYMENTS_PKG.GET_PAID_DATE( AI.INVOICE_ID
, APS.PAYMENT_NUM) PAID_DATE
, AP_INVOICE_PAYMENTS_PKG.GET_PAYMENT_ID( AI.INVOICE_ID
, APS.PAYMENT_NUM) PAYMENT_ID
, AP_INVOICE_PAYMENTS_PKG.GET_PAYMENT_TYPE( AI.INVOICE_ID
, APS.PAYMENT_NUM) PAYMENT_TYPE
, APS.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, APS.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, APS.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, APS.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, APS.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, APS.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, APS.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, APS.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, APS.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, APS.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, APS.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, APS.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, APS.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, APS.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, APS.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, APS.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, APS.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, APS.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, APS.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, APS.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, APS.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, APS.ORG_ID ORG_ID /* BUG 7535348*/
, APS.REMIT_TO_SUPPLIER_NAME
, APS.REMIT_TO_SUPPLIER_ID
, APS.REMIT_TO_SUPPLIER_SITE
, APS.REMIT_TO_SUPPLIER_SITE_ID
, APS.RELATIONSHIP_ID /* BUG 7535348*/
FROM AP_PAYMENT_SCHEDULES APS
, AP_BATCHES_ALL AB
, AP_INVOICES_ALL AI
WHERE APS.BATCH_ID = AB.BATCH_ID (+)
AND APS.INVOICE_ID = AI.INVOICE_ID