View: AR_PAYMENT_SCHEDULES_ALL_MRC_V

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

View Text

SELECT PRIMARY.PAYMENT_SCHEDULE_ID
, PRIMARY.CUSTOMER_TRX_ID
, MC.EXCHANGE_RATE_TYPE
, MC.EXCHANGE_DATE
, MC.EXCHANGE_RATE
, MC.ACCTD_AMOUNT_DUE_REMAINING
, STAGED_DUNNING_LEVEL
, DUNNING_LEVEL_OVERRIDE_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DUE_DATE
, AMOUNT_DUE_ORIGINAL
, PRIMARY.AMOUNT_DUE_REMAINING
, NUMBER_OF_DUE_DATES
, STATUS
, INVOICE_CURRENCY_CODE
, CLASS
, CUST_TRX_TYPE_ID
, CUSTOMER_ID
, CUSTOMER_SITE_USE_ID
, CASH_RECEIPT_ID
, ASSOCIATED_CASH_RECEIPT_ID
, TERM_ID
, TERMS_SEQUENCE_NUMBER
, GL_DATE_CLOSED
, ACTUAL_DATE_CLOSED
, DISCOUNT_DATE
, AMOUNT_LINE_ITEMS_ORIGINAL
, AMOUNT_LINE_ITEMS_REMAINING
, AMOUNT_APPLIED
, AMOUNT_ADJUSTED
, AMOUNT_IN_DISPUTE
, AMOUNT_CREDITED
, RECEIVABLES_CHARGES_CHARGED
, RECEIVABLES_CHARGES_REMAINING
, FREIGHT_ORIGINAL
, FREIGHT_REMAINING
, TAX_ORIGINAL
, TAX_REMAINING
, DISCOUNT_ORIGINAL
, DISCOUNT_REMAINING
, DISCOUNT_TAKEN_EARNED
, DISCOUNT_TAKEN_UNEARNED
, IN_COLLECTION
, CASH_APPLIED_ID_LAST
, CASH_APPLIED_DATE_LAST
, CASH_APPLIED_AMOUNT_LAST
, CASH_APPLIED_STATUS_LAST
, CASH_GL_DATE_LAST
, CASH_RECEIPT_ID_LAST
, CASH_RECEIPT_DATE_LAST
, CASH_RECEIPT_AMOUNT_LAST
, CASH_RECEIPT_STATUS_LAST
, ADJUSTMENT_ID_LAST
, ADJUSTMENT_DATE_LAST
, ADJUSTMENT_GL_DATE_LAST
, ADJUSTMENT_AMOUNT_LAST
, FOLLOW_UP_DATE_LAST
, FOLLOW_UP_CODE_LAST
, PROMISE_DATE_LAST
, PROMISE_AMOUNT_LAST
, COLLECTOR_LAST
, CALL_DATE_LAST
, TRX_NUMBER
, TRX_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, REVERSED_CASH_RECEIPT_ID
, AMOUNT_ADJUSTED_PENDING
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, GL_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, RECEIPT_CONFIRMED_FLAG
, REQUEST_ID
, SELECTED_FOR_RECEIPT_BATCH_ID
, LAST_CHARGE_DATE
, SECOND_LAST_CHARGE_DATE
, DISPUTE_DATE
, ORG_ID
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, CONS_INV_ID
, CONS_INV_ID_REV
, EXCLUDE_FROM_DUNNING_FLAG
, MRC_EXCHANGE_RATE_TYPE
, MRC_EXCHANGE_DATE
, MRC_EXCHANGE_RATE
, MRC_ACCTD_AMOUNT_DUE_REMAINING
, MRC_CUSTOMER_TRX_ID
, BR_AMOUNT_ASSIGNED
, RESERVED_TYPE
, RESERVED_VALUE
, ACTIVE_CLAIM_FLAG
, EXCLUDE_FROM_CONS_BILL_FLAG
FROM AR_PAYMENT_SCHEDULES_ALL PRIMARY
, AR_MC_PAYMENT_SCHEDULES MC
WHERE PRIMARY.PAYMENT_SCHEDULE_ID = MC.PAYMENT_SCHEDULE_ID
AND MC.SET_OF_BOOKS_ID = NVL (TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10)
, ' '))
, -99)

Columns