VIEW: APPS.AR_TRX_HISTORY_ALL_MRC_V

Source

View Text - Preformatted

SELECT PRIMARY.TRANSACTION_HISTORY_ID, PRIMARY.CUSTOMER_TRX_ID, PRIMARY.STATUS, PRIMARY.EVENT, PRIMARY.BATCH_ID, PRIMARY.TRX_DATE, PRIMARY.GL_DATE, PRIMARY.CURRENT_RECORD_FLAG, PRIMARY.CURRENT_ACCOUNTED_FLAG, PRIMARY.POSTABLE_FLAG, PRIMARY.FIRST_POSTED_RECORD_FLAG, MC.posting_control_id, MC.gl_posted_date, PRIMARY.PRV_TRX_HISTORY_ID, MC.created_from, 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.ATTRIBUTE11, PRIMARY.ATTRIBUTE12, PRIMARY.ATTRIBUTE13, PRIMARY.ATTRIBUTE14, PRIMARY.ATTRIBUTE15, PRIMARY.PROGRAM_APPLICATION_ID, PRIMARY.PROGRAM_ID, PRIMARY.PROGRAM_UPDATE_DATE, PRIMARY.REQUEST_ID, PRIMARY.CREATION_DATE, PRIMARY.CREATED_BY, PRIMARY.LAST_UPDATE_LOGIN, PRIMARY.LAST_UPDATE_DATE, PRIMARY.LAST_UPDATED_BY, PRIMARY.ORG_ID, PRIMARY.MRC_POSTING_CONTROL_ID, PRIMARY.MRC_GL_POSTED_DATE, PRIMARY.MRC_CREATED_FROM, PRIMARY.MATURITY_DATE FROM AR_TRANSACTION_HISTORY_ALL PRIMARY, AR_MC_TRANSACTION_HISTORY MC WHERE PRIMARY.transaction_history_id = MC.transaction_history_id AND mc.set_of_books_id = NVL(TO_NUMBER (RTRIM(SUBSTRB(USERENV('CLIENT_INFO'),45, 10),' ')), -99)

View Text - HTML Formatted

SELECT PRIMARY.TRANSACTION_HISTORY_ID
, PRIMARY.CUSTOMER_TRX_ID
, PRIMARY.STATUS
, PRIMARY.EVENT
, PRIMARY.BATCH_ID
, PRIMARY.TRX_DATE
, PRIMARY.GL_DATE
, PRIMARY.CURRENT_RECORD_FLAG
, PRIMARY.CURRENT_ACCOUNTED_FLAG
, PRIMARY.POSTABLE_FLAG
, PRIMARY.FIRST_POSTED_RECORD_FLAG
, MC.POSTING_CONTROL_ID
, MC.GL_POSTED_DATE
, PRIMARY.PRV_TRX_HISTORY_ID
, MC.CREATED_FROM
, 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.ATTRIBUTE11
, PRIMARY.ATTRIBUTE12
, PRIMARY.ATTRIBUTE13
, PRIMARY.ATTRIBUTE14
, PRIMARY.ATTRIBUTE15
, PRIMARY.PROGRAM_APPLICATION_ID
, PRIMARY.PROGRAM_ID
, PRIMARY.PROGRAM_UPDATE_DATE
, PRIMARY.REQUEST_ID
, PRIMARY.CREATION_DATE
, PRIMARY.CREATED_BY
, PRIMARY.LAST_UPDATE_LOGIN
, PRIMARY.LAST_UPDATE_DATE
, PRIMARY.LAST_UPDATED_BY
, PRIMARY.ORG_ID
, PRIMARY.MRC_POSTING_CONTROL_ID
, PRIMARY.MRC_GL_POSTED_DATE
, PRIMARY.MRC_CREATED_FROM
, PRIMARY.MATURITY_DATE
FROM AR_TRANSACTION_HISTORY_ALL PRIMARY
, AR_MC_TRANSACTION_HISTORY MC
WHERE PRIMARY.TRANSACTION_HISTORY_ID = MC.TRANSACTION_HISTORY_ID
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER (RTRIM(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10)
, ' '))
, -99)