VIEW: APPS.AR_PAYMENT_SCHEDULES_MRC_V

Source

View Text - Preformatted

SELECT PRIMARY.payment_schedule_id, PRIMARY.staged_dunning_level, PRIMARY.dunning_level_override_date, PRIMARY.last_update_date, PRIMARY.last_updated_by, PRIMARY.creation_date, PRIMARY.created_by, PRIMARY.last_update_login, PRIMARY.due_date, PRIMARY.amount_due_original, PRIMARY.amount_due_remaining, PRIMARY.number_of_due_dates, PRIMARY.status, PRIMARY.invoice_currency_code, PRIMARY.CLASS, PRIMARY.cust_trx_type_id, PRIMARY.customer_id, PRIMARY.customer_site_use_id, PRIMARY.customer_trx_id, PRIMARY.cash_receipt_id, PRIMARY.associated_cash_receipt_id, PRIMARY.term_id, PRIMARY.terms_sequence_number, PRIMARY.gl_date_closed, PRIMARY.actual_date_closed, PRIMARY.discount_date, PRIMARY.amount_line_items_original, PRIMARY.amount_line_items_remaining, PRIMARY.amount_applied, PRIMARY.amount_adjusted, PRIMARY.amount_in_dispute, PRIMARY.amount_credited, PRIMARY.receivables_charges_charged, PRIMARY.receivables_charges_remaining, PRIMARY.freight_original, PRIMARY.freight_remaining, PRIMARY.tax_original, PRIMARY.tax_remaining, PRIMARY.discount_original, PRIMARY.discount_remaining, PRIMARY.discount_taken_earned, PRIMARY.discount_taken_unearned, PRIMARY.in_collection, PRIMARY.cash_applied_id_last, PRIMARY.cash_applied_date_last, PRIMARY.cash_applied_amount_last, PRIMARY.cash_applied_status_last, PRIMARY.cash_gl_date_last, PRIMARY.cash_receipt_id_last, PRIMARY.cash_receipt_date_last, PRIMARY.cash_receipt_amount_last, PRIMARY.cash_receipt_status_last, mc.exchange_rate_type, mc.exchange_date, mc.exchange_rate, PRIMARY.adjustment_id_last, PRIMARY.adjustment_date_last, PRIMARY.adjustment_gl_date_last, PRIMARY.adjustment_amount_last, PRIMARY.follow_up_date_last, PRIMARY.follow_up_code_last, PRIMARY.promise_date_last, PRIMARY.promise_amount_last, PRIMARY.collector_last, PRIMARY.call_date_last, PRIMARY.trx_number, PRIMARY.trx_date, PRIMARY.attribute_category, PRIMARY.attribute1, PRIMARY.attribute2, PRIMARY.attribute3, PRIMARY.attribute4, PRIMARY.attribute5, PRIMARY.attribute6, PRIMARY.attribute7, PRIMARY.attribute8, PRIMARY.attribute9, PRIMARY.attribute10, PRIMARY.reversed_cash_receipt_id, PRIMARY.amount_adjusted_pending, PRIMARY.attribute11, PRIMARY.attribute12, PRIMARY.attribute13, PRIMARY.attribute14, PRIMARY.attribute15, PRIMARY.gl_date, mc.acctd_amount_due_remaining, PRIMARY.program_application_id, PRIMARY.program_id, PRIMARY.program_update_date, PRIMARY.receipt_confirmed_flag, PRIMARY.request_id, PRIMARY.selected_for_receipt_batch_id, PRIMARY.last_charge_date, PRIMARY.second_last_charge_date, PRIMARY.dispute_date, PRIMARY.org_id, PRIMARY.global_attribute1, PRIMARY.global_attribute2, PRIMARY.global_attribute3, PRIMARY.global_attribute4, PRIMARY.global_attribute5, PRIMARY.global_attribute6, PRIMARY.global_attribute7, PRIMARY.global_attribute8, PRIMARY.global_attribute9, PRIMARY.global_attribute10, PRIMARY.global_attribute11, PRIMARY.global_attribute12, PRIMARY.global_attribute13, PRIMARY.global_attribute14, PRIMARY.global_attribute15, PRIMARY.global_attribute16, PRIMARY.global_attribute17, PRIMARY.global_attribute18, PRIMARY.global_attribute19, PRIMARY.global_attribute20, PRIMARY.global_attribute_category, PRIMARY.cons_inv_id, PRIMARY.cons_inv_id_rev, PRIMARY.exclude_from_dunning_flag, PRIMARY.br_amount_assigned, PRIMARY.reserved_type, PRIMARY.reserved_value, PRIMARY.active_claim_flag, PRIMARY.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 NVL(PRIMARY.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99) 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.STAGED_DUNNING_LEVEL
, PRIMARY.DUNNING_LEVEL_OVERRIDE_DATE
, PRIMARY.LAST_UPDATE_DATE
, PRIMARY.LAST_UPDATED_BY
, PRIMARY.CREATION_DATE
, PRIMARY.CREATED_BY
, PRIMARY.LAST_UPDATE_LOGIN
, PRIMARY.DUE_DATE
, PRIMARY.AMOUNT_DUE_ORIGINAL
, PRIMARY.AMOUNT_DUE_REMAINING
, PRIMARY.NUMBER_OF_DUE_DATES
, PRIMARY.STATUS
, PRIMARY.INVOICE_CURRENCY_CODE
, PRIMARY.CLASS
, PRIMARY.CUST_TRX_TYPE_ID
, PRIMARY.CUSTOMER_ID
, PRIMARY.CUSTOMER_SITE_USE_ID
, PRIMARY.CUSTOMER_TRX_ID
, PRIMARY.CASH_RECEIPT_ID
, PRIMARY.ASSOCIATED_CASH_RECEIPT_ID
, PRIMARY.TERM_ID
, PRIMARY.TERMS_SEQUENCE_NUMBER
, PRIMARY.GL_DATE_CLOSED
, PRIMARY.ACTUAL_DATE_CLOSED
, PRIMARY.DISCOUNT_DATE
, PRIMARY.AMOUNT_LINE_ITEMS_ORIGINAL
, PRIMARY.AMOUNT_LINE_ITEMS_REMAINING
, PRIMARY.AMOUNT_APPLIED
, PRIMARY.AMOUNT_ADJUSTED
, PRIMARY.AMOUNT_IN_DISPUTE
, PRIMARY.AMOUNT_CREDITED
, PRIMARY.RECEIVABLES_CHARGES_CHARGED
, PRIMARY.RECEIVABLES_CHARGES_REMAINING
, PRIMARY.FREIGHT_ORIGINAL
, PRIMARY.FREIGHT_REMAINING
, PRIMARY.TAX_ORIGINAL
, PRIMARY.TAX_REMAINING
, PRIMARY.DISCOUNT_ORIGINAL
, PRIMARY.DISCOUNT_REMAINING
, PRIMARY.DISCOUNT_TAKEN_EARNED
, PRIMARY.DISCOUNT_TAKEN_UNEARNED
, PRIMARY.IN_COLLECTION
, PRIMARY.CASH_APPLIED_ID_LAST
, PRIMARY.CASH_APPLIED_DATE_LAST
, PRIMARY.CASH_APPLIED_AMOUNT_LAST
, PRIMARY.CASH_APPLIED_STATUS_LAST
, PRIMARY.CASH_GL_DATE_LAST
, PRIMARY.CASH_RECEIPT_ID_LAST
, PRIMARY.CASH_RECEIPT_DATE_LAST
, PRIMARY.CASH_RECEIPT_AMOUNT_LAST
, PRIMARY.CASH_RECEIPT_STATUS_LAST
, MC.EXCHANGE_RATE_TYPE
, MC.EXCHANGE_DATE
, MC.EXCHANGE_RATE
, PRIMARY.ADJUSTMENT_ID_LAST
, PRIMARY.ADJUSTMENT_DATE_LAST
, PRIMARY.ADJUSTMENT_GL_DATE_LAST
, PRIMARY.ADJUSTMENT_AMOUNT_LAST
, PRIMARY.FOLLOW_UP_DATE_LAST
, PRIMARY.FOLLOW_UP_CODE_LAST
, PRIMARY.PROMISE_DATE_LAST
, PRIMARY.PROMISE_AMOUNT_LAST
, PRIMARY.COLLECTOR_LAST
, PRIMARY.CALL_DATE_LAST
, PRIMARY.TRX_NUMBER
, PRIMARY.TRX_DATE
, PRIMARY.ATTRIBUTE_CATEGORY
, PRIMARY.ATTRIBUTE1
, PRIMARY.ATTRIBUTE2
, PRIMARY.ATTRIBUTE3
, PRIMARY.ATTRIBUTE4
, PRIMARY.ATTRIBUTE5
, PRIMARY.ATTRIBUTE6
, PRIMARY.ATTRIBUTE7
, PRIMARY.ATTRIBUTE8
, PRIMARY.ATTRIBUTE9
, PRIMARY.ATTRIBUTE10
, PRIMARY.REVERSED_CASH_RECEIPT_ID
, PRIMARY.AMOUNT_ADJUSTED_PENDING
, PRIMARY.ATTRIBUTE11
, PRIMARY.ATTRIBUTE12
, PRIMARY.ATTRIBUTE13
, PRIMARY.ATTRIBUTE14
, PRIMARY.ATTRIBUTE15
, PRIMARY.GL_DATE
, MC.ACCTD_AMOUNT_DUE_REMAINING
, PRIMARY.PROGRAM_APPLICATION_ID
, PRIMARY.PROGRAM_ID
, PRIMARY.PROGRAM_UPDATE_DATE
, PRIMARY.RECEIPT_CONFIRMED_FLAG
, PRIMARY.REQUEST_ID
, PRIMARY.SELECTED_FOR_RECEIPT_BATCH_ID
, PRIMARY.LAST_CHARGE_DATE
, PRIMARY.SECOND_LAST_CHARGE_DATE
, PRIMARY.DISPUTE_DATE
, PRIMARY.ORG_ID
, PRIMARY.GLOBAL_ATTRIBUTE1
, PRIMARY.GLOBAL_ATTRIBUTE2
, PRIMARY.GLOBAL_ATTRIBUTE3
, PRIMARY.GLOBAL_ATTRIBUTE4
, PRIMARY.GLOBAL_ATTRIBUTE5
, PRIMARY.GLOBAL_ATTRIBUTE6
, PRIMARY.GLOBAL_ATTRIBUTE7
, PRIMARY.GLOBAL_ATTRIBUTE8
, PRIMARY.GLOBAL_ATTRIBUTE9
, PRIMARY.GLOBAL_ATTRIBUTE10
, PRIMARY.GLOBAL_ATTRIBUTE11
, PRIMARY.GLOBAL_ATTRIBUTE12
, PRIMARY.GLOBAL_ATTRIBUTE13
, PRIMARY.GLOBAL_ATTRIBUTE14
, PRIMARY.GLOBAL_ATTRIBUTE15
, PRIMARY.GLOBAL_ATTRIBUTE16
, PRIMARY.GLOBAL_ATTRIBUTE17
, PRIMARY.GLOBAL_ATTRIBUTE18
, PRIMARY.GLOBAL_ATTRIBUTE19
, PRIMARY.GLOBAL_ATTRIBUTE20
, PRIMARY.GLOBAL_ATTRIBUTE_CATEGORY
, PRIMARY.CONS_INV_ID
, PRIMARY.CONS_INV_ID_REV
, PRIMARY.EXCLUDE_FROM_DUNNING_FLAG
, PRIMARY.BR_AMOUNT_ASSIGNED
, PRIMARY.RESERVED_TYPE
, PRIMARY.RESERVED_VALUE
, PRIMARY.ACTIVE_CLAIM_FLAG
, PRIMARY.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 NVL(PRIMARY.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND MC.SET_OF_BOOKS_ID = NVL (TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10)
, ' '))
, -99)