VIEW: APPS.AR_RECEIPT_HISTORY_L_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'