View: AR_RECEIPT_HISTORY_L_V

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

View Text

SELECT /*+INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, CRH.ATTRIBUTE1 CRH_LN_ATTRIBUTE1
, CRH.ATTRIBUTE10 CRH_LN_ATTRIBUTE10
, CRH.ATTRIBUTE11 CRH_LN_ATTRIBUTE11
, CRH.ATTRIBUTE12 CRH_LN_ATTRIBUTE12
, CRH.ATTRIBUTE13 CRH_LN_ATTRIBUTE13
, CRH.ATTRIBUTE14 CRH_LN_ATTRIBUTE14
, CRH.ATTRIBUTE15 CRH_LN_ATTRIBUTE15
, CRH.ATTRIBUTE2 CRH_LN_ATTRIBUTE2
, CRH.ATTRIBUTE3 CRH_LN_ATTRIBUTE3
, CRH.ATTRIBUTE4 CRH_LN_ATTRIBUTE4
, CRH.ATTRIBUTE5 CRH_LN_ATTRIBUTE5
, CRH.ATTRIBUTE6 CRH_LN_ATTRIBUTE6
, CRH.ATTRIBUTE7 CRH_LN_ATTRIBUTE7
, CRH.ATTRIBUTE8 CRH_LN_ATTRIBUTE8
, CRH.ATTRIBUTE9 CRH_LN_ATTRIBUTE9
, CRH.ATTRIBUTE_CATEGORY CRH_LN_ATTR_CATEGORY
, CRH.BANK_CHARGE_ACCOUNT_CCID CRH_LN_BNK_CHRG_ACC_CCID
, CRH.CASH_RECEIPT_HISTORY_ID CRH_LN_CASH_RECP_HIST_ID
, CRH.GL_DATE CRH_LN_GL_DATE
, CRH.NOTE_STATUS CRH_LN_NOTE_STATUS
, NULL CRH_LN_REVERSAL_GL_DATE
, CRH.STATUS CRH_LN_STATUS
, CRH.TRX_DATE CRH_LN_TRX_DATE
, CRH.ACCOUNT_CODE_COMBINATION_ID CRH_LN_ACCOUNT_CCID
, CRH.PRV_STAT_CASH_RECEIPT_HIST_ID CRH_LN_PRV_CRH_ID
, CRH.REVERSAL_CASH_RECEIPT_HIST_ID CRH_LN_REVERSAL_ID
, CRH1.STATUS CRH_LN_REVERSAL_STATUS
, CRH1.GL_DATE CRH_LN_REV_GL_DATE
FROM AR_XLA_LINES_EXTRACT L
, AR_CASH_RECEIPT_HISTORY_ALL CRH
, AR_CASH_RECEIPT_HISTORY_ALL CRH1
WHERE L.POSTING_ENTITY = 'CRH'
AND L.SOURCE_TABLE = 'CRH'
AND L.LEVEL_FLAG = 'L'
AND L.SOURCE_ID = CRH.CASH_RECEIPT_HISTORY_ID
AND L.EVENT_ID = CRH.EVENT_ID
AND CRH.REVERSAL_CASH_RECEIPT_HIST_ID = CRH1.CASH_RECEIPT_HISTORY_ID(+)
AND L.MFAR_ADDITIONAL_ENTRY = 'N' UNION /* CRH ATTRIBUTES ASSOCIATED TO RA LINES BEING PROCESSED UNDER CURRENT UNPROCESSED EVENT IN EVENTS_GT */ SELECT /*+INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, CRH.ATTRIBUTE1 CRH_LN_ATTRIBUTE1
, CRH.ATTRIBUTE10 CRH_LN_ATTRIBUTE10
, CRH.ATTRIBUTE11 CRH_LN_ATTRIBUTE11
, CRH.ATTRIBUTE12 CRH_LN_ATTRIBUTE12
, CRH.ATTRIBUTE13 CRH_LN_ATTRIBUTE13
, CRH.ATTRIBUTE14 CRH_LN_ATTRIBUTE14
, CRH.ATTRIBUTE15 CRH_LN_ATTRIBUTE15
, CRH.ATTRIBUTE2 CRH_LN_ATTRIBUTE2
, CRH.ATTRIBUTE3 CRH_LN_ATTRIBUTE3
, CRH.ATTRIBUTE4 CRH_LN_ATTRIBUTE4
, CRH.ATTRIBUTE5 CRH_LN_ATTRIBUTE5
, CRH.ATTRIBUTE6 CRH_LN_ATTRIBUTE6
, CRH.ATTRIBUTE7 CRH_LN_ATTRIBUTE7
, CRH.ATTRIBUTE8 CRH_LN_ATTRIBUTE8
, CRH.ATTRIBUTE9 CRH_LN_ATTRIBUTE9
, CRH.ATTRIBUTE_CATEGORY CRH_LN_ATTR_CATEGORY
, CRH.BANK_CHARGE_ACCOUNT_CCID CRH_LN_BNK_CHRG_ACC_CCID
, CRH.CASH_RECEIPT_HISTORY_ID CRH_LN_CASH_RECP_HIST_ID
, CRH.GL_DATE CRH_LN_GL_DATE
, CRH.NOTE_STATUS CRH_LN_NOTE_STATUS
, NULL CRH_LN_REVERSAL_GL_DATE
, CRH.STATUS CRH_LN_STATUS
, CRH.TRX_DATE CRH_LN_TRX_DATE
, CRH.ACCOUNT_CODE_COMBINATION_ID CRH_LN_ACCOUNT_CCID
, CRH.PRV_STAT_CASH_RECEIPT_HIST_ID CRH_LN_PRV_CRH_ID
, CRH.REVERSAL_CASH_RECEIPT_HIST_ID CRH_LN_REVERSAL_ID
, CRH1.STATUS CRH_LN_REVERSAL_STATUS
, CRH1.GL_DATE CRH_LN_REV_GL_DATE
FROM AR_XLA_LINES_EXTRACT L
, AR_RECEIVABLE_APPLICATIONS_ALL RA
, AR_CASH_RECEIPT_HISTORY_ALL CRH
, AR_CASH_RECEIPT_HISTORY_ALL CRH1
WHERE L.POSTING_ENTITY = 'APP'
AND L.SOURCE_TABLE = 'RA'
AND L.LEVEL_FLAG = 'L'
AND L.EVENT_ID = RA.EVENT_ID
AND RA.CASH_RECEIPT_HISTORY_ID = CRH.CASH_RECEIPT_HISTORY_ID
AND CRH.REVERSAL_CASH_RECEIPT_HIST_ID = CRH1.CASH_RECEIPT_HISTORY_ID(+)
AND L.MFAR_ADDITIONAL_ENTRY = 'N'

Columns