AR_TRANSACTION_HISTORY_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
TRX_HIST_ATTR1 TRX_HIST_ATTR10 TRX_HIST_ATTR11 TRX_HIST_ATTR12 TRX_HIST_ATTR13 TRX_HIST_ATTR14 TRX_HIST_ATTR15 TRX_HIST_ATTR2 TRX_HIST_ATTR3 TRX_HIST_ATTR4 TRX_HIST_ATTR5 TRX_HIST_ATTR6 TRX_HIST_ATTR7 TRX_HIST_ATTR8 TRX_HIST_ATTR9 TRX_HIST_ATTR_CAT TRX_HIST_COMMENTS TRX_HIST_EVENT TRX_HIST_GL_DATE TRX_HIST_MATURITY_DATE TRX_HIST_TRX_DATE TRX_HIST_TRX_HISTORY_ID EVENT_ID

Query

SQL_Statement

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'