View: AR_TRANSACTION_HISTORY_H_V

Product:	AR - Receivables
Description:	transaction history header extract
Implementation/DBA Data:	APPS.AR_TRANSACTION_HISTORY_H_V

View Text

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ TH.ATTRIBUTE1 TRX_HIST_ATTR1
, TH.ATTRIBUTE10 TRX_HIST_ATTR10
, TH.ATTRIBUTE11 TRX_HIST_ATTR11
, TH.ATTRIBUTE12 TRX_HIST_ATTR12
, TH.ATTRIBUTE13 TRX_HIST_ATTR13
, TH.ATTRIBUTE14 TRX_HIST_ATTR14
, TH.ATTRIBUTE15 TRX_HIST_ATTR15
, TH.ATTRIBUTE2 TRX_HIST_ATTR2
, TH.ATTRIBUTE3 TRX_HIST_ATTR3
, TH.ATTRIBUTE4 TRX_HIST_ATTR4
, TH.ATTRIBUTE5 TRX_HIST_ATTR5
, TH.ATTRIBUTE6 TRX_HIST_ATTR6
, TH.ATTRIBUTE7 TRX_HIST_ATTR7
, TH.ATTRIBUTE8 TRX_HIST_ATTR8
, TH.ATTRIBUTE9 TRX_HIST_ATTR9
, TH.ATTRIBUTE_CATEGORY TRX_HIST_ATTR_CAT
, TH.COMMENTS TRX_HIST_COMMENTS
, TH.EVENT TRX_HIST_EVENT
, TH.GL_DATE TRX_HIST_GL_DATE
, TH.MATURITY_DATE TRX_HIST_MATURITY_DATE
, TH.TRX_DATE TRX_HIST_TRX_DATE
, TH.TRANSACTION_HISTORY_ID TRX_HIST_TRX_HISTORY_ID
, HE.EVENT_ID EVENT_ID
FROM AR_TRANSACTION_HISTORY_ALL TH
, AR_XLA_LINES_EXTRACT HE
WHERE TH.EVENT_ID = HE.EVENT_ID
AND HE.LEVEL_FLAG = 'H'

Columns