VIEW: APPS.AR_BR_HISTORY_V

Source

View Text - Preformatted

SELECT hist.rowid, hist.transaction_history_id, hist.customer_trx_id, hist.status, hist.event, arl.meaning, hist.trx_date, hist.gl_date, hist.comments, hist.maturity_date, hist.creation_date, hist.created_by, hist.last_update_login, hist.last_update_date, hist.last_updated_by from ar_transaction_history hist, ar_lookups arl WHERE hist.event = arl.lookup_code(+) and arl.lookup_type(+) = 'TRANSACTION_HISTORY_EVENT'

View Text - HTML Formatted

SELECT HIST.ROWID
, HIST.TRANSACTION_HISTORY_ID
, HIST.CUSTOMER_TRX_ID
, HIST.STATUS
, HIST.EVENT
, ARL.MEANING
, HIST.TRX_DATE
, HIST.GL_DATE
, HIST.COMMENTS
, HIST.MATURITY_DATE
, HIST.CREATION_DATE
, HIST.CREATED_BY
, HIST.LAST_UPDATE_LOGIN
, HIST.LAST_UPDATE_DATE
, HIST.LAST_UPDATED_BY
FROM AR_TRANSACTION_HISTORY HIST
, AR_LOOKUPS ARL
WHERE HIST.EVENT = ARL.LOOKUP_CODE(+)
AND ARL.LOOKUP_TYPE(+) = 'TRANSACTION_HISTORY_EVENT'