View: AP_PAYMENT_SCHEDULES_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AP_PAYMENT_SCHEDULES_V

View Text

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_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_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
FROM AP_PAYMENT_SCHEDULES APS
, AP_BATCHES AB
, AP_INVOICES AI
WHERE APS.BATCH_ID = AB.BATCH_ID (+)
AND APS.INVOICE_ID = AI.INVOICE_ID

Columns