VIEW: APPS.AR_TRANSACTION_HISTORY_H_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'