eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AR_RGW_CASH_MANAGEMENT_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'