VIEW: APPS.AR_PAYMENT_SCHEDULES_ALL_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)