eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AR_PAYMENT_SCHEDULES_FLEX_VIEW

Source

View Text - Preformatted


SELECT PS.PAYMENT_SCHEDULE_ID, PS.ACCTD_AMOUNT_DUE_REMAINING, PS.AMOUNT_DUE_ORIGINAL, PS.AMOUNT_DUE_REMAINING, PS.CLASS, PS.CREATED_BY, PS.CREATION_DATE, PS.DUE_DATE, PS.GL_DATE, PS.INVOICE_CURRENCY_CODE, PS.LAST_UPDATED_BY, PS.LAST_UPDATE_DATE, PS.NUMBER_OF_DUE_DATES, PS.STATUS, PS.ACTUAL_DATE_CLOSED, PS.ADJUSTMENT_AMOUNT_LAST, PS.ADJUSTMENT_DATE_LAST, PS.ADJUSTMENT_GL_DATE_LAST, PS.ADJUSTMENT_ID_LAST, PS.AMOUNT_ADJUSTED, PS.AMOUNT_ADJUSTED_PENDING , PS.AMOUNT_APPLIED , PS.AMOUNT_CREDITED, PS.AMOUNT_IN_DISPUTE, PS.AMOUNT_LINE_ITEMS_ORIGINAL, PS.AMOUNT_LINE_ITEMS_REMAINING, PS.ASSOCIATED_CASH_RECEIPT_ID, PS.CALL_DATE_LAST, PS.CASH_APPLIED_AMOUNT_LAST , PS.CASH_APPLIED_DATE_LAST, PS.CASH_APPLIED_ID_LAST, PS.CASH_APPLIED_STATUS_LAST, PS.CASH_GL_DATE_LAST, PS.CASH_RECEIPT_AMOUNT_LAST, PS.CASH_RECEIPT_DATE_LAST, PS.CASH_RECEIPT_ID, PS.CASH_RECEIPT_ID_LAST, PS.CASH_RECEIPT_STATUS_LAST, PS.COLLECTOR_LAST, PS.CUSTOMER_ID, PS.CUSTOMER_SITE_USE_ID, PS.CUSTOMER_TRX_ID, PS.CUST_TRX_TYPE_ID, PS.DISCOUNT_DATE, PS.DISCOUNT_ORIGINAL, PS.DISCOUNT_REMAINING, PS.DISCOUNT_TAKEN_EARNED, PS.DISCOUNT_TAKEN_UNEARNED, PS.EXCHANGE_DATE , PS.EXCHANGE_RATE, PS.EXCHANGE_RATE_TYPE, PS.FOLLOW_UP_CODE_LAST, PS.FOLLOW_UP_DATE_LAST, PS.FREIGHT_ORIGINAL, PS.FREIGHT_REMAINING, PS.GL_DATE_CLOSED , PS.IN_COLLECTION, PS.LAST_UPDATE_LOGIN, PS.PROMISE_AMOUNT_LAST, PS.PROMISE_DATE_LAST, PS.RECEIPT_CONFIRMED_FLAG, PS.RECEIVABLES_CHARGES_CHARGED, PS.RECEIVABLES_CHARGES_REMAINING, PS.REVERSED_CASH_RECEIPT_ID, PS.SELECTED_FOR_RECEIPT_BATCH_ID, PS.TAX_ORIGINAL, PS.TAX_REMAINING, PS.TERMS_SEQUENCE_NUMBER, PS.TERM_ID, PS.TRX_DATE , PS.TRX_NUMBER, PS.REQUEST_ID, PS.PROGRAM_APPLICATION_ID, PS.PROGRAM_ID , PS.PROGRAM_UPDATE_DATE, PS.DISPUTE_DATE, PS.LAST_CHARGE_DATE, PS.SECOND_LAST_CHARGE_DATE, CR.DOC_SEQUENCE_VALUE, CR.RECEIPT_METHOD_ID, CR.USSGL_TRANSACTION_CODE, CR.USSGL_TRANSACTION_CODE_CONTEXT, CR.ATTRIBUTE_CATEGORY, CR.ATTRIBUTE1, CR.ATTRIBUTE2, CR.ATTRIBUTE3, CR.ATTRIBUTE4, CR.ATTRIBUTE5, CR.ATTRIBUTE6, CR.ATTRIBUTE7, CR.ATTRIBUTE8, CR.ATTRIBUTE9, CR.ATTRIBUTE10, CR.ATTRIBUTE11, CR.ATTRIBUTE12, CR.ATTRIBUTE13, CR.ATTRIBUTE14, CR.ATTRIBUTE15, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null FROM ar_cash_receipts cr, ar_payment_schedules ps WHERE ps.cash_receipt_id = cr.cash_receipt_id AND ps.CLASS||'' = 'PMT' UNION Select PS.PAYMENT_SCHEDULE_ID, PS.ACCTD_AMOUNT_DUE_REMAINING, PS.AMOUNT_DUE_ORIGINAL, PS.AMOUNT_DUE_REMAINING, PS.CLASS, PS.CREATED_BY, PS.CREATION_DATE, PS.DUE_DATE , PS.GL_DATE, PS.INVOICE_CURRENCY_CODE, PS.LAST_UPDATED_BY, PS.LAST_UPDATE_DATE, PS.NUMBER_OF_DUE_DATES, PS.STATUS, PS.ACTUAL_DATE_CLOSED, PS.ADJUSTMENT_AMOUNT_LAST, PS.ADJUSTMENT_DATE_LAST, PS.ADJUSTMENT_GL_DATE_LAST, PS.ADJUSTMENT_ID_LAST, PS.AMOUNT_ADJUSTED , PS.AMOUNT_ADJUSTED_PENDING , PS.AMOUNT_APPLIED, PS.AMOUNT_CREDITED , PS.AMOUNT_IN_DISPUTE, PS.AMOUNT_LINE_ITEMS_ORIGINAL, PS.AMOUNT_LINE_ITEMS_REMAINING, PS.ASSOCIATED_CASH_RECEIPT_ID, PS.CALL_DATE_LAST, PS.CASH_APPLIED_AMOUNT_LAST, PS.CASH_APPLIED_DATE_LAST, PS.CASH_APPLIED_ID_LAST, PS.CASH_APPLIED_STATUS_LAST, PS.CASH_GL_DATE_LAST, PS.CASH_RECEIPT_AMOUNT_LAST, PS.CASH_RECEIPT_DATE_LAST , PS.CASH_RECEIPT_ID, PS.CASH_RECEIPT_ID_LAST, PS.CASH_RECEIPT_STATUS_LAST, PS.COLLECTOR_LAST , PS.CUSTOMER_ID , PS.CUSTOMER_SITE_USE_ID , PS.CUSTOMER_TRX_ID, PS.CUST_TRX_TYPE_ID, PS.DISCOUNT_DATE, PS.DISCOUNT_ORIGINAL, PS.DISCOUNT_REMAINING, PS.DISCOUNT_TAKEN_EARNED, PS.DISCOUNT_TAKEN_UNEARNED, PS.EXCHANGE_DATE , PS.EXCHANGE_RATE, PS.EXCHANGE_RATE_TYPE, PS.FOLLOW_UP_CODE_LAST , PS.FOLLOW_UP_DATE_LAST , PS.FREIGHT_ORIGINAL, PS.FREIGHT_REMAINING, PS.GL_DATE_CLOSED, PS.IN_COLLECTION, PS.LAST_UPDATE_LOGIN, PS.PROMISE_AMOUNT_LAST, PS.PROMISE_DATE_LAST, PS.RECEIPT_CONFIRMED_FLAG, PS.RECEIVABLES_CHARGES_CHARGED, PS.RECEIVABLES_CHARGES_REMAINING, PS.REVERSED_CASH_RECEIPT_ID, PS.SELECTED_FOR_RECEIPT_BATCH_ID, PS.TAX_ORIGINAL, PS.TAX_REMAINING, PS.TERMS_SEQUENCE_NUMBER, PS.TERM_ID, PS.TRX_DATE, PS.TRX_NUMBER, PS.REQUEST_ID, PS.PROGRAM_APPLICATION_ID, PS.PROGRAM_ID, PS.PROGRAM_UPDATE_DATE, PS.DISPUTE_DATE, PS.LAST_CHARGE_DATE, PS.SECOND_LAST_CHARGE_DATE, CT.DOC_SEQUENCE_VALUE, to_number(Null) , Null, Null, CT.ATTRIBUTE_CATEGORY, CT.ATTRIBUTE1, CT.ATTRIBUTE2, CT.ATTRIBUTE3, CT.ATTRIBUTE4, CT.ATTRIBUTE5, CT.ATTRIBUTE6, CT.ATTRIBUTE7, CT.ATTRIBUTE8, CT.ATTRIBUTE9, CT.ATTRIBUTE10, CT.ATTRIBUTE11, CT.ATTRIBUTE12, CT.ATTRIBUTE13, CT.ATTRIBUTE14, CT.ATTRIBUTE15, CT.PURCHASE_ORDER, CT.DEFAULT_USSGL_TRANSACTION_CODE, CT.DEFAULT_USSGL_TRX_CODE_CONTEXT, CT.INTERFACE_HEADER_ATTRIBUTE1 , CT.INTERFACE_HEADER_ATTRIBUTE2 , CT.INTERFACE_HEADER_ATTRIBUTE3 , CT.INTERFACE_HEADER_ATTRIBUTE4 , CT.INTERFACE_HEADER_ATTRIBUTE5 , CT.INTERFACE_HEADER_ATTRIBUTE6 , CT.INTERFACE_HEADER_ATTRIBUTE7 , CT.INTERFACE_HEADER_ATTRIBUTE8 , CT.INTERFACE_HEADER_ATTRIBUTE9 , CT.INTERFACE_HEADER_ATTRIBUTE10 , CT.INTERFACE_HEADER_ATTRIBUTE11 , CT.INTERFACE_HEADER_ATTRIBUTE12 , CT.INTERFACE_HEADER_ATTRIBUTE13 , CT.INTERFACE_HEADER_ATTRIBUTE14 , CT.INTERFACE_HEADER_ATTRIBUTE15 , CT.INTERFACE_HEADER_CONTEXT FROM AR_PAYMENT_SCHEDULES PS, RA_CUSTOMER_TRX CT WHERE ps.customer_trx_id = ct.customer_trx_id AND ps.CLASS != 'PMT'

View Text - HTML Formatted

SELECT PS.PAYMENT_SCHEDULE_ID
, PS.ACCTD_AMOUNT_DUE_REMAINING
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING
, PS.CLASS
, PS.CREATED_BY
, PS.CREATION_DATE
, PS.DUE_DATE
, PS.GL_DATE
, PS.INVOICE_CURRENCY_CODE
, PS.LAST_UPDATED_BY
, PS.LAST_UPDATE_DATE
, PS.NUMBER_OF_DUE_DATES
, PS.STATUS
, PS.ACTUAL_DATE_CLOSED
, PS.ADJUSTMENT_AMOUNT_LAST
, PS.ADJUSTMENT_DATE_LAST
, PS.ADJUSTMENT_GL_DATE_LAST
, PS.ADJUSTMENT_ID_LAST
, PS.AMOUNT_ADJUSTED
, PS.AMOUNT_ADJUSTED_PENDING
, PS.AMOUNT_APPLIED
, PS.AMOUNT_CREDITED
, PS.AMOUNT_IN_DISPUTE
, PS.AMOUNT_LINE_ITEMS_ORIGINAL
, PS.AMOUNT_LINE_ITEMS_REMAINING
, PS.ASSOCIATED_CASH_RECEIPT_ID
, PS.CALL_DATE_LAST
, PS.CASH_APPLIED_AMOUNT_LAST
, PS.CASH_APPLIED_DATE_LAST
, PS.CASH_APPLIED_ID_LAST
, PS.CASH_APPLIED_STATUS_LAST
, PS.CASH_GL_DATE_LAST
, PS.CASH_RECEIPT_AMOUNT_LAST
, PS.CASH_RECEIPT_DATE_LAST
, PS.CASH_RECEIPT_ID
, PS.CASH_RECEIPT_ID_LAST
, PS.CASH_RECEIPT_STATUS_LAST
, PS.COLLECTOR_LAST
, PS.CUSTOMER_ID
, PS.CUSTOMER_SITE_USE_ID
, PS.CUSTOMER_TRX_ID
, PS.CUST_TRX_TYPE_ID
, PS.DISCOUNT_DATE
, PS.DISCOUNT_ORIGINAL
, PS.DISCOUNT_REMAINING
, PS.DISCOUNT_TAKEN_EARNED
, PS.DISCOUNT_TAKEN_UNEARNED
, PS.EXCHANGE_DATE
, PS.EXCHANGE_RATE
, PS.EXCHANGE_RATE_TYPE
, PS.FOLLOW_UP_CODE_LAST
, PS.FOLLOW_UP_DATE_LAST
, PS.FREIGHT_ORIGINAL
, PS.FREIGHT_REMAINING
, PS.GL_DATE_CLOSED
, PS.IN_COLLECTION
, PS.LAST_UPDATE_LOGIN
, PS.PROMISE_AMOUNT_LAST
, PS.PROMISE_DATE_LAST
, PS.RECEIPT_CONFIRMED_FLAG
, PS.RECEIVABLES_CHARGES_CHARGED
, PS.RECEIVABLES_CHARGES_REMAINING
, PS.REVERSED_CASH_RECEIPT_ID
, PS.SELECTED_FOR_RECEIPT_BATCH_ID
, PS.TAX_ORIGINAL
, PS.TAX_REMAINING
, PS.TERMS_SEQUENCE_NUMBER
, PS.TERM_ID
, PS.TRX_DATE
, PS.TRX_NUMBER
, PS.REQUEST_ID
, PS.PROGRAM_APPLICATION_ID
, PS.PROGRAM_ID
, PS.PROGRAM_UPDATE_DATE
, PS.DISPUTE_DATE
, PS.LAST_CHARGE_DATE
, PS.SECOND_LAST_CHARGE_DATE
, CR.DOC_SEQUENCE_VALUE
, CR.RECEIPT_METHOD_ID
, CR.USSGL_TRANSACTION_CODE
, CR.USSGL_TRANSACTION_CODE_CONTEXT
, CR.ATTRIBUTE_CATEGORY
, CR.ATTRIBUTE1
, CR.ATTRIBUTE2
, CR.ATTRIBUTE3
, CR.ATTRIBUTE4
, CR.ATTRIBUTE5
, CR.ATTRIBUTE6
, CR.ATTRIBUTE7
, CR.ATTRIBUTE8
, CR.ATTRIBUTE9
, CR.ATTRIBUTE10
, CR.ATTRIBUTE11
, CR.ATTRIBUTE12
, CR.ATTRIBUTE13
, CR.ATTRIBUTE14
, CR.ATTRIBUTE15
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM AR_CASH_RECEIPTS CR
, AR_PAYMENT_SCHEDULES PS
WHERE PS.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND PS.CLASS||'' = 'PMT' UNION SELECT PS.PAYMENT_SCHEDULE_ID
, PS.ACCTD_AMOUNT_DUE_REMAINING
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING
, PS.CLASS
, PS.CREATED_BY
, PS.CREATION_DATE
, PS.DUE_DATE
, PS.GL_DATE
, PS.INVOICE_CURRENCY_CODE
, PS.LAST_UPDATED_BY
, PS.LAST_UPDATE_DATE
, PS.NUMBER_OF_DUE_DATES
, PS.STATUS
, PS.ACTUAL_DATE_CLOSED
, PS.ADJUSTMENT_AMOUNT_LAST
, PS.ADJUSTMENT_DATE_LAST
, PS.ADJUSTMENT_GL_DATE_LAST
, PS.ADJUSTMENT_ID_LAST
, PS.AMOUNT_ADJUSTED
, PS.AMOUNT_ADJUSTED_PENDING
, PS.AMOUNT_APPLIED
, PS.AMOUNT_CREDITED
, PS.AMOUNT_IN_DISPUTE
, PS.AMOUNT_LINE_ITEMS_ORIGINAL
, PS.AMOUNT_LINE_ITEMS_REMAINING
, PS.ASSOCIATED_CASH_RECEIPT_ID
, PS.CALL_DATE_LAST
, PS.CASH_APPLIED_AMOUNT_LAST
, PS.CASH_APPLIED_DATE_LAST
, PS.CASH_APPLIED_ID_LAST
, PS.CASH_APPLIED_STATUS_LAST
, PS.CASH_GL_DATE_LAST
, PS.CASH_RECEIPT_AMOUNT_LAST
, PS.CASH_RECEIPT_DATE_LAST
, PS.CASH_RECEIPT_ID
, PS.CASH_RECEIPT_ID_LAST
, PS.CASH_RECEIPT_STATUS_LAST
, PS.COLLECTOR_LAST
, PS.CUSTOMER_ID
, PS.CUSTOMER_SITE_USE_ID
, PS.CUSTOMER_TRX_ID
, PS.CUST_TRX_TYPE_ID
, PS.DISCOUNT_DATE
, PS.DISCOUNT_ORIGINAL
, PS.DISCOUNT_REMAINING
, PS.DISCOUNT_TAKEN_EARNED
, PS.DISCOUNT_TAKEN_UNEARNED
, PS.EXCHANGE_DATE
, PS.EXCHANGE_RATE
, PS.EXCHANGE_RATE_TYPE
, PS.FOLLOW_UP_CODE_LAST
, PS.FOLLOW_UP_DATE_LAST
, PS.FREIGHT_ORIGINAL
, PS.FREIGHT_REMAINING
, PS.GL_DATE_CLOSED
, PS.IN_COLLECTION
, PS.LAST_UPDATE_LOGIN
, PS.PROMISE_AMOUNT_LAST
, PS.PROMISE_DATE_LAST
, PS.RECEIPT_CONFIRMED_FLAG
, PS.RECEIVABLES_CHARGES_CHARGED
, PS.RECEIVABLES_CHARGES_REMAINING
, PS.REVERSED_CASH_RECEIPT_ID
, PS.SELECTED_FOR_RECEIPT_BATCH_ID
, PS.TAX_ORIGINAL
, PS.TAX_REMAINING
, PS.TERMS_SEQUENCE_NUMBER
, PS.TERM_ID
, PS.TRX_DATE
, PS.TRX_NUMBER
, PS.REQUEST_ID
, PS.PROGRAM_APPLICATION_ID
, PS.PROGRAM_ID
, PS.PROGRAM_UPDATE_DATE
, PS.DISPUTE_DATE
, PS.LAST_CHARGE_DATE
, PS.SECOND_LAST_CHARGE_DATE
, CT.DOC_SEQUENCE_VALUE
, TO_NUMBER(NULL)
, NULL
, NULL
, CT.ATTRIBUTE_CATEGORY
, CT.ATTRIBUTE1
, CT.ATTRIBUTE2
, CT.ATTRIBUTE3
, CT.ATTRIBUTE4
, CT.ATTRIBUTE5
, CT.ATTRIBUTE6
, CT.ATTRIBUTE7
, CT.ATTRIBUTE8
, CT.ATTRIBUTE9
, CT.ATTRIBUTE10
, CT.ATTRIBUTE11
, CT.ATTRIBUTE12
, CT.ATTRIBUTE13
, CT.ATTRIBUTE14
, CT.ATTRIBUTE15
, CT.PURCHASE_ORDER
, CT.DEFAULT_USSGL_TRANSACTION_CODE
, CT.DEFAULT_USSGL_TRX_CODE_CONTEXT
, CT.INTERFACE_HEADER_ATTRIBUTE1
, CT.INTERFACE_HEADER_ATTRIBUTE2
, CT.INTERFACE_HEADER_ATTRIBUTE3
, CT.INTERFACE_HEADER_ATTRIBUTE4
, CT.INTERFACE_HEADER_ATTRIBUTE5
, CT.INTERFACE_HEADER_ATTRIBUTE6
, CT.INTERFACE_HEADER_ATTRIBUTE7
, CT.INTERFACE_HEADER_ATTRIBUTE8
, CT.INTERFACE_HEADER_ATTRIBUTE9
, CT.INTERFACE_HEADER_ATTRIBUTE10
, CT.INTERFACE_HEADER_ATTRIBUTE11
, CT.INTERFACE_HEADER_ATTRIBUTE12
, CT.INTERFACE_HEADER_ATTRIBUTE13
, CT.INTERFACE_HEADER_ATTRIBUTE14
, CT.INTERFACE_HEADER_ATTRIBUTE15
, CT.INTERFACE_HEADER_CONTEXT
FROM AR_PAYMENT_SCHEDULES PS
, RA_CUSTOMER_TRX CT
WHERE PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND PS.CLASS != 'PMT'