VIEW: APPS.AR_ADJUSTMENTS_ALL_MRC_V

Source

View Text - Preformatted

SELECT PRIMARY.adjustment_id, mc.set_of_books_id, mc.gl_posted_date, mc.posting_control_id, mc.acctd_amount, PRIMARY.last_updated_by, PRIMARY.last_update_date, PRIMARY.last_update_login, PRIMARY.created_by, PRIMARY.creation_date, amount, apply_date, gl_date, code_combination_id, TYPE, adjustment_type, status, line_adjusted, freight_adjusted, tax_adjusted, receivables_charges_adjusted, associated_cash_receipt_id, chargeback_customer_trx_id, batch_id, customer_trx_id, customer_trx_line_id, subsequent_trx_id, payment_schedule_id, receivables_trx_id, distribution_set_id, comments, automatically_generated, created_from, reason_code, postable, approved_by, attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15, program_application_id, program_id, program_update_date, request_id, adjustment_number, org_id, ussgl_transaction_code, ussgl_transaction_code_context, doc_sequence_value, doc_sequence_id, associated_application_id, cons_inv_id, mrc_gl_posted_date, mrc_posting_control_id, mrc_acctd_amount, adj_tax_acct_rule, global_attribute_category, 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, link_to_trx_hist_id FROM ar_adjustments_all PRIMARY, ar_mc_adjustments mc WHERE PRIMARY.adjustment_id = mc.adjustment_id AND mc.set_of_books_id = NVL (TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO'), 45, 10), ' ')), -99)

View Text - HTML Formatted

SELECT PRIMARY.ADJUSTMENT_ID
, MC.SET_OF_BOOKS_ID
, MC.GL_POSTED_DATE
, MC.POSTING_CONTROL_ID
, MC.ACCTD_AMOUNT
, PRIMARY.LAST_UPDATED_BY
, PRIMARY.LAST_UPDATE_DATE
, PRIMARY.LAST_UPDATE_LOGIN
, PRIMARY.CREATED_BY
, PRIMARY.CREATION_DATE
, AMOUNT
, APPLY_DATE
, GL_DATE
, CODE_COMBINATION_ID
, TYPE
, ADJUSTMENT_TYPE
, STATUS
, LINE_ADJUSTED
, FREIGHT_ADJUSTED
, TAX_ADJUSTED
, RECEIVABLES_CHARGES_ADJUSTED
, ASSOCIATED_CASH_RECEIPT_ID
, CHARGEBACK_CUSTOMER_TRX_ID
, BATCH_ID
, CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID
, SUBSEQUENT_TRX_ID
, PAYMENT_SCHEDULE_ID
, RECEIVABLES_TRX_ID
, DISTRIBUTION_SET_ID
, COMMENTS
, AUTOMATICALLY_GENERATED
, CREATED_FROM
, REASON_CODE
, POSTABLE
, APPROVED_BY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, ADJUSTMENT_NUMBER
, ORG_ID
, USSGL_TRANSACTION_CODE
, USSGL_TRANSACTION_CODE_CONTEXT
, DOC_SEQUENCE_VALUE
, DOC_SEQUENCE_ID
, ASSOCIATED_APPLICATION_ID
, CONS_INV_ID
, MRC_GL_POSTED_DATE
, MRC_POSTING_CONTROL_ID
, MRC_ACCTD_AMOUNT
, ADJ_TAX_ACCT_RULE
, GLOBAL_ATTRIBUTE_CATEGORY
, 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
, LINK_TO_TRX_HIST_ID
FROM AR_ADJUSTMENTS_ALL PRIMARY
, AR_MC_ADJUSTMENTS MC
WHERE PRIMARY.ADJUSTMENT_ID = MC.ADJUSTMENT_ID
AND MC.SET_OF_BOOKS_ID = NVL (TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10)
, ' '))
, -99)