View: AR_RGW_CASH_MANAGEMENT_V

Product:	AR - Receivables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AR_RGW_CASH_MANAGEMENT_V

View Text

SELECT H.STATEMENT_NUMBER
, H.STATEMENT_DATE
, L.LINE_NUMBER
, R.CASH_RECEIPT_ID
FROM AR_CASH_RECEIPTS R
, AR_CASH_RECEIPT_HISTORY RH
, CE_STATEMENT_HEADERS H
, CE_STATEMENT_LINES L
, CE_STATEMENT_RECONCILIATIONS SR
WHERE H.STATEMENT_HEADER_ID = L.STATEMENT_HEADER_ID
AND L.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
AND R.CASH_RECEIPT_ID = RH.CASH_RECEIPT_ID
AND SR.REFERENCE_ID = RH.CASH_RECEIPT_HISTORY_ID
AND SR.REFERENCE_TYPE = 'RECEIPT'
AND SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'

Columns