[Home] [Help]
View: AR_BR_HISTORY_V
View Text
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'
Columns
Name |
ROW_ID |
TRANSACTION_HISTORY_ID |
CUSTOMER_TRX_ID |
STATUS |
EVENT |
EVENT_MEANING |
TRX_DATE |
GL_DATE |
COMMENTS |
MATURITY_DATE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |