VIEW: APPS.RA_TRX_LINE_GL_DIST_MRC_V

Source

View Text - Preformatted

SELECT primary.cust_trx_line_gl_dist_id, mc.set_of_books_id, primary.account_class, primary.customer_trx_id, mc.amount, mc.gl_posted_date, mc.posting_control_id, mc.acctd_amount, primary.customer_trx_line_id, primary.code_combination_id, primary.last_update_date, primary.last_updated_by, primary.creation_date, primary.created_by, primary.last_update_login, primary.PERCENT, primary.gl_date, primary.cust_trx_line_salesrep_id, 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.request_id, primary.program_application_id, primary.program_id, primary.program_update_date, primary.concatenated_segments, primary.original_gl_date, primary.post_request_id, primary.ra_post_loop_number, primary.account_set_flag, primary.ussgl_transaction_code, primary.ussgl_transaction_code_context, primary.attribute11, primary.attribute12, primary.attribute13, primary.attribute14, primary.attribute15, primary.latest_rec_flag, primary.org_id, primary.collected_tax_ccid, primary.collected_tax_concat_seg, primary.revenue_adjustment_id, primary.rev_adj_class_temp, primary.rec_offset_flag FROM ra_cust_trx_line_gl_dist_all PRIMARY, ra_mc_trx_line_gl_dist mc WHERE PRIMARY.cust_trx_line_gl_dist_id = mc.cust_trx_line_gl_dist_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.CUST_TRX_LINE_GL_DIST_ID
, MC.SET_OF_BOOKS_ID
, PRIMARY.ACCOUNT_CLASS
, PRIMARY.CUSTOMER_TRX_ID
, MC.AMOUNT
, MC.GL_POSTED_DATE
, MC.POSTING_CONTROL_ID
, MC.ACCTD_AMOUNT
, PRIMARY.CUSTOMER_TRX_LINE_ID
, PRIMARY.CODE_COMBINATION_ID
, PRIMARY.LAST_UPDATE_DATE
, PRIMARY.LAST_UPDATED_BY
, PRIMARY.CREATION_DATE
, PRIMARY.CREATED_BY
, PRIMARY.LAST_UPDATE_LOGIN
, PRIMARY.PERCENT
, PRIMARY.GL_DATE
, PRIMARY.CUST_TRX_LINE_SALESREP_ID
, 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.REQUEST_ID
, PRIMARY.PROGRAM_APPLICATION_ID
, PRIMARY.PROGRAM_ID
, PRIMARY.PROGRAM_UPDATE_DATE
, PRIMARY.CONCATENATED_SEGMENTS
, PRIMARY.ORIGINAL_GL_DATE
, PRIMARY.POST_REQUEST_ID
, PRIMARY.RA_POST_LOOP_NUMBER
, PRIMARY.ACCOUNT_SET_FLAG
, PRIMARY.USSGL_TRANSACTION_CODE
, PRIMARY.USSGL_TRANSACTION_CODE_CONTEXT
, PRIMARY.ATTRIBUTE11
, PRIMARY.ATTRIBUTE12
, PRIMARY.ATTRIBUTE13
, PRIMARY.ATTRIBUTE14
, PRIMARY.ATTRIBUTE15
, PRIMARY.LATEST_REC_FLAG
, PRIMARY.ORG_ID
, PRIMARY.COLLECTED_TAX_CCID
, PRIMARY.COLLECTED_TAX_CONCAT_SEG
, PRIMARY.REVENUE_ADJUSTMENT_ID
, PRIMARY.REV_ADJ_CLASS_TEMP
, PRIMARY.REC_OFFSET_FLAG
FROM RA_CUST_TRX_LINE_GL_DIST_ALL PRIMARY
, RA_MC_TRX_LINE_GL_DIST MC
WHERE PRIMARY.CUST_TRX_LINE_GL_DIST_ID = MC.CUST_TRX_LINE_GL_DIST_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)