View: AR_RECEIPT_HISTORY_H_V

Product:	AR - Receivables
Description:	cash receipt history header extract
Implementation/DBA Data:	APPS.AR_RECEIPT_HISTORY_H_V

View Text

SELECT /*+INDEX(HE AR_XLA_LINES_EXTRACT_N1)*/ CRH.ATTRIBUTE1 CRH_ATTRIBUTE1
, CRH.ATTRIBUTE10 CRH_ATTRIBUTE10
, CRH.ATTRIBUTE11 CRH_ATTRIBUTE11
, CRH.ATTRIBUTE12 CRH_ATTRIBUTE12
, CRH.ATTRIBUTE13 CRH_ATTRIBUTE13
, CRH.ATTRIBUTE14 CRH_ATTRIBUTE14
, CRH.ATTRIBUTE15 CRH_ATTRIBUTE15
, CRH.ATTRIBUTE2 CRH_ATTRIBUTE2
, CRH.ATTRIBUTE3 CRH_ATTRIBUTE3
, CRH.ATTRIBUTE4 CRH_ATTRIBUTE4
, CRH.ATTRIBUTE5 CRH_ATTRIBUTE5
, CRH.ATTRIBUTE6 CRH_ATTRIBUTE6
, CRH.ATTRIBUTE7 CRH_ATTRIBUTE7
, CRH.ATTRIBUTE8 CRH_ATTRIBUTE8
, CRH.ATTRIBUTE9 CRH_ATTRIBUTE9
, CRH.ATTRIBUTE_CATEGORY CRH_ATTRIBUTE_CATEGORY
, CRH.BANK_CHARGE_ACCOUNT_CCID CRH_BANK_CHARGE_ACCOUNT_CCID
, CRH.CASH_RECEIPT_HISTORY_ID CRH_CASH_RECEIPT_HISTORY_ID
, CRH.GL_DATE CRH_GL_DATE
, CRH.NOTE_STATUS CRH_NOTE_STATUS
, CRH1.GL_DATE CRH_REVERSAL_GL_DATE
, CRH.STATUS CRH_STATUS
, CRH.TRX_DATE CRH_TRX_DATE
, CRH.ACCOUNT_CODE_COMBINATION_ID CRH_ACCOUNT_CCID
, CRH.PRV_STAT_CASH_RECEIPT_HIST_ID CRH_PRV_CRH_ID
, CRH.REVERSAL_CASH_RECEIPT_HIST_ID CRH_REVERSAL_ID
, CRH1.STATUS CRH_REVERSAL_STATUS
, HE.EVENT_ID EVENT_ID
FROM AR_XLA_LINES_EXTRACT HE
, (SELECT /*+ INDEX(L AR_XLA_LINES_EXTRACT_N1)*/ MAX(DECODE(L.CRH_STATUS
, ''
, C.EVENT_ID
, L.EVENT_ID)) O_EVENT_ID
, L.EVENT_ID I_EVENT_ID
FROM AR_XLA_LINES_EXTRACT L
, AR_RECEIVABLE_APPLICATIONS_ALL RA
, AR_CASH_RECEIPT_HISTORY_ALL C
WHERE L.LEVEL_FLAG = 'H'
AND L.EVENT_ID = RA.EVENT_ID(+)
AND RA.CASH_RECEIPT_HISTORY_ID = C.CASH_RECEIPT_HISTORY_ID(+) GROUP BY L.EVENT_ID ) EV
, AR_CASH_RECEIPT_HISTORY_ALL CRH
, AR_CASH_RECEIPT_HISTORY_ALL CRH1
WHERE HE.LEVEL_FLAG = 'H'
AND HE.EVENT_ID = EV.I_EVENT_ID
AND CRH.EVENT_ID = EV.O_EVENT_ID
AND CRH.REVERSAL_CASH_RECEIPT_HIST_ID = CRH1.CASH_RECEIPT_HISTORY_ID(+)

Columns