View: IGI_CBR_ARC_RECONCILE_V

Product:	IGI - Public Sector Financials International
Description:	This is an intermediate view for the AR reconciliation process. Used by IGI_CBR_ARC_V.
Implementation/DBA Data:	APPS.IGI_CBR_ARC_RECONCILE_V

View Text

SELECT REP.REFERENCE25 TRANS_NUM
, (SUM(DECODE(REP.REFERENCE30||REP.REFERENCE29
, 'RA_CUST_TRX_LINE_GL_DISTINV_REV'
, NVL(REP.ACCOUNTED_CR
, 0)-NVL(REP.ACCOUNTED_DR
, 0)
, 'RA_CUST_TRX_LINE_GL_DISTINV_TAX'
, NVL(REP.ACCOUNTED_CR
, 0)-NVL(REP.ACCOUNTED_DR
, 0)
, 'RA_CUST_TRX_LINE_GL_DISTCM_TAX'
, NVL(REP.ACCOUNTED_DR
, 0)-NVL(REP.ACCOUNTED_CR
, 0)
, 'RA_CUST_TRX_LINE_GL_DISTCM_REV'
, NVL(REP.ACCOUNTED_DR-TO_NUMBER(NVL(REP.REFERENCE20
, 0))
, 0)
, 0)) - SUM(DECODE(REP.REFERENCE30||REP.REFERENCE29
, 'AR_CASH_BASIS_DISTRIBUTIONSCMAPP_APP'
, NVL(REP.ACCOUNTED_CR
, 0)-NVL(REP.ACCOUNTED_DR
, 0)
, 'AR_CASH_BASIS_DISTRIBUTIONSTRADE_APP'
, NVL(REP.ACCOUNTED_CR
, 0)-NVL(REP.ACCOUNTED_DR
, 0)
, 0))) DIFF
FROM IGI_AR_JOURNAL_INTERIM REP
, GL_CODE_COMBINATIONS C
, AR_LOOKUPS L
WHERE REP.CODE_COMBINATION_ID = C.CODE_COMBINATION_ID(+)
AND L.LOOKUP_TYPE = 'ARRGTA_CATEGORIES'
AND REP.REFERENCE28 = L.LOOKUP_CODE
AND REP.REFERENCE25 IS NOT NULL GROUP BY REP.REFERENCE25 HAVING SUM(DECODE(REP.REFERENCE30||REP.REFERENCE29
, 'RA_CUST_TRX_LINE_GL_DISTINV_REV'
, NVL(REP.ACCOUNTED_CR
, 0)-NVL(REP.ACCOUNTED_DR
, 0)
, 'RA_CUST_TRX_LINE_GL_DISTINV_TAX'
, NVL(REP.ACCOUNTED_CR
, 0)-NVL(REP.ACCOUNTED_DR
, 0)
, 'RA_CUST_TRX_LINE_GL_DISTCM_TAX'
, NVL(REP.ACCOUNTED_DR
, 0)-NVL(REP.ACCOUNTED_CR
, 0)
, 'RA_CUST_TRX_LINE_GL_DISTCM_REV'
, NVL(REP.ACCOUNTED_DR-TO_NUMBER(NVL(REP.REFERENCE20
, 0))
, 0)
, 0))- SUM(DECODE(REP.REFERENCE30||REP.REFERENCE29
, 'AR_CASH_BASIS_DISTRIBUTIONSCMAPP_APP'
, NVL(REP.ACCOUNTED_CR
, 0)-NVL(REP.ACCOUNTED_DR
, 0)
, 'AR_CASH_BASIS_DISTRIBUTIONSTRADE_APP'
, NVL(REP.ACCOUNTED_CR
, 0)-NVL(REP.ACCOUNTED_DR
, 0)
, 0)) <> 0

Columns