Product: | AR - Receivables |
---|---|
Description: | Descriptive Flexfields for payment schedules |
Implementation/DBA Data: | APPS.AR_PAYMENT_SCHEDULES_FLEX_VIEW |
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'