VIEW: APPS.AR_RECEIVABLE_APPS_MRC_V

Source

View Text - Preformatted

SELECT PRIMARY.receivable_application_id, PRIMARY.amount_applied, PRIMARY.amount_applied_from, mc.set_of_books_id, PRIMARY.display, PRIMARY.status, PRIMARY.payment_schedule_id, PRIMARY.cash_receipt_id, mc.gl_posted_date, mc.posting_control_id, mc.acctd_amount_applied_from, mc.acctd_amount_applied_to, mc.acctd_earned_discount_taken, mc.acctd_unearned_discount_taken, PRIMARY.last_updated_by, PRIMARY.last_update_date, PRIMARY.created_by, PRIMARY.creation_date, PRIMARY.trans_to_receipt_rate, PRIMARY.gl_date, PRIMARY.code_combination_id, PRIMARY.apply_date, PRIMARY.application_type, PRIMARY.last_update_login, PRIMARY.applied_customer_trx_id, PRIMARY.applied_customer_trx_line_id, PRIMARY.applied_payment_schedule_id, PRIMARY.customer_trx_id, PRIMARY.line_applied, PRIMARY.tax_applied, PRIMARY.freight_applied, PRIMARY.receivables_charges_applied, PRIMARY.on_account_customer, PRIMARY.receivables_trx_id, PRIMARY.earned_discount_taken, PRIMARY.unearned_discount_taken, PRIMARY.days_late, PRIMARY.application_rule, PRIMARY.comments, PRIMARY.attribute_category, PRIMARY.attribute1, PRIMARY.attribute2, PRIMARY.attribute3, PRIMARY.attribute4, PRIMARY.attribute5, PRIMARY.attribute6, PRIMARY.attribute7, PRIMARY.attribute8, PRIMARY.attribute9, PRIMARY.attribute10, PRIMARY.postable, PRIMARY.attribute11, PRIMARY.attribute12, PRIMARY.attribute13, PRIMARY.attribute14, PRIMARY.attribute15, PRIMARY.confirmed_flag, PRIMARY.program_application_id, PRIMARY.program_id, PRIMARY.program_update_date, PRIMARY.request_id, PRIMARY.ussgl_transaction_code, PRIMARY.ussgl_transaction_code_context, PRIMARY.earned_discount_ccid, PRIMARY.unearned_discount_ccid, PRIMARY.reversal_gl_date, PRIMARY.cash_receipt_history_id, PRIMARY.org_id, PRIMARY.tax_code, 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_to, PRIMARY.rule_set_id, PRIMARY.line_ediscounted, PRIMARY.tax_ediscounted, PRIMARY.freight_ediscounted, PRIMARY.charges_ediscounted, PRIMARY.line_uediscounted, PRIMARY.tax_uediscounted, PRIMARY.freight_uediscounted, PRIMARY.charges_uediscounted, PRIMARY.edisc_tax_acct_rule, PRIMARY.unedisc_tax_acct_rule, PRIMARY.link_to_trx_hist_id, PRIMARY.link_to_customer_trx_id, PRIMARY.APPLICATION_REF_ID, PRIMARY.APPLICATION_REF_NUM, PRIMARY.APPLICATION_REF_REASON, PRIMARY.APPLICATION_REF_TYPE, PRIMARY.CHARGEBACK_CUSTOMER_TRX_ID, PRIMARY.CUSTOMER_REFERENCE, PRIMARY.PAYMENT_SET_ID, PRIMARY.SECONDARY_APPLICATION_REF_ID , primary.customer_reason, primary.applied_rec_app_id , PRIMARY.SECONDARY_APPLICATION_REF_TYPE , PRIMARY.SECONDARY_APPLICATION_REF_NUM FROM ar_receivable_applications PRIMARY, ar_mc_receivable_apps mc WHERE PRIMARY.receivable_application_id = mc.receivable_application_id AND mc.set_of_books_id = NVL (TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO'), 45, 10), ' ')), -99)

View Text - HTML Formatted

SELECT PRIMARY.RECEIVABLE_APPLICATION_ID
, PRIMARY.AMOUNT_APPLIED
, PRIMARY.AMOUNT_APPLIED_FROM
, MC.SET_OF_BOOKS_ID
, PRIMARY.DISPLAY
, PRIMARY.STATUS
, PRIMARY.PAYMENT_SCHEDULE_ID
, PRIMARY.CASH_RECEIPT_ID
, MC.GL_POSTED_DATE
, MC.POSTING_CONTROL_ID
, MC.ACCTD_AMOUNT_APPLIED_FROM
, MC.ACCTD_AMOUNT_APPLIED_TO
, MC.ACCTD_EARNED_DISCOUNT_TAKEN
, MC.ACCTD_UNEARNED_DISCOUNT_TAKEN
, PRIMARY.LAST_UPDATED_BY
, PRIMARY.LAST_UPDATE_DATE
, PRIMARY.CREATED_BY
, PRIMARY.CREATION_DATE
, PRIMARY.TRANS_TO_RECEIPT_RATE
, PRIMARY.GL_DATE
, PRIMARY.CODE_COMBINATION_ID
, PRIMARY.APPLY_DATE
, PRIMARY.APPLICATION_TYPE
, PRIMARY.LAST_UPDATE_LOGIN
, PRIMARY.APPLIED_CUSTOMER_TRX_ID
, PRIMARY.APPLIED_CUSTOMER_TRX_LINE_ID
, PRIMARY.APPLIED_PAYMENT_SCHEDULE_ID
, PRIMARY.CUSTOMER_TRX_ID
, PRIMARY.LINE_APPLIED
, PRIMARY.TAX_APPLIED
, PRIMARY.FREIGHT_APPLIED
, PRIMARY.RECEIVABLES_CHARGES_APPLIED
, PRIMARY.ON_ACCOUNT_CUSTOMER
, PRIMARY.RECEIVABLES_TRX_ID
, PRIMARY.EARNED_DISCOUNT_TAKEN
, PRIMARY.UNEARNED_DISCOUNT_TAKEN
, PRIMARY.DAYS_LATE
, PRIMARY.APPLICATION_RULE
, PRIMARY.COMMENTS
, PRIMARY.ATTRIBUTE_CATEGORY
, PRIMARY.ATTRIBUTE1
, PRIMARY.ATTRIBUTE2
, PRIMARY.ATTRIBUTE3
, PRIMARY.ATTRIBUTE4
, PRIMARY.ATTRIBUTE5
, PRIMARY.ATTRIBUTE6
, PRIMARY.ATTRIBUTE7
, PRIMARY.ATTRIBUTE8
, PRIMARY.ATTRIBUTE9
, PRIMARY.ATTRIBUTE10
, PRIMARY.POSTABLE
, PRIMARY.ATTRIBUTE11
, PRIMARY.ATTRIBUTE12
, PRIMARY.ATTRIBUTE13
, PRIMARY.ATTRIBUTE14
, PRIMARY.ATTRIBUTE15
, PRIMARY.CONFIRMED_FLAG
, PRIMARY.PROGRAM_APPLICATION_ID
, PRIMARY.PROGRAM_ID
, PRIMARY.PROGRAM_UPDATE_DATE
, PRIMARY.REQUEST_ID
, PRIMARY.USSGL_TRANSACTION_CODE
, PRIMARY.USSGL_TRANSACTION_CODE_CONTEXT
, PRIMARY.EARNED_DISCOUNT_CCID
, PRIMARY.UNEARNED_DISCOUNT_CCID
, PRIMARY.REVERSAL_GL_DATE
, PRIMARY.CASH_RECEIPT_HISTORY_ID
, PRIMARY.ORG_ID
, PRIMARY.TAX_CODE
, 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_TO
, PRIMARY.RULE_SET_ID
, PRIMARY.LINE_EDISCOUNTED
, PRIMARY.TAX_EDISCOUNTED
, PRIMARY.FREIGHT_EDISCOUNTED
, PRIMARY.CHARGES_EDISCOUNTED
, PRIMARY.LINE_UEDISCOUNTED
, PRIMARY.TAX_UEDISCOUNTED
, PRIMARY.FREIGHT_UEDISCOUNTED
, PRIMARY.CHARGES_UEDISCOUNTED
, PRIMARY.EDISC_TAX_ACCT_RULE
, PRIMARY.UNEDISC_TAX_ACCT_RULE
, PRIMARY.LINK_TO_TRX_HIST_ID
, PRIMARY.LINK_TO_CUSTOMER_TRX_ID
, PRIMARY.APPLICATION_REF_ID
, PRIMARY.APPLICATION_REF_NUM
, PRIMARY.APPLICATION_REF_REASON
, PRIMARY.APPLICATION_REF_TYPE
, PRIMARY.CHARGEBACK_CUSTOMER_TRX_ID
, PRIMARY.CUSTOMER_REFERENCE
, PRIMARY.PAYMENT_SET_ID
, PRIMARY.SECONDARY_APPLICATION_REF_ID
, PRIMARY.CUSTOMER_REASON
, PRIMARY.APPLIED_REC_APP_ID
, PRIMARY.SECONDARY_APPLICATION_REF_TYPE
, PRIMARY.SECONDARY_APPLICATION_REF_NUM
FROM AR_RECEIVABLE_APPLICATIONS PRIMARY
, AR_MC_RECEIVABLE_APPS MC
WHERE PRIMARY.RECEIVABLE_APPLICATION_ID = MC.RECEIVABLE_APPLICATION_ID
AND MC.SET_OF_BOOKS_ID = NVL (TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10)
, ' '))
, -99)