View: AR_RGW_RECEIPT_HISTORY_V

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

View Text

SELECT /* PURPOSE: THE VIEW AR_RGW_RECEIPT_HISTORY_V IS USED IN THE */ /* RECEIPT HISTORY WINDOW OF THE RECEIPT GATEWAY */ CRH.ROWID ROW_ID
, CRH.CASH_RECEIPT_ID CASH_RECEIPT_ID
, CRH.CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID
, CRH.STATUS STATUS
, L.MEANING STATUS_DSP
, CRH.TRX_DATE TRX_DATE
, CRH.GL_DATE GL_DATE
, CRH.AMOUNT AMOUNT
, CRH.EXCHANGE_RATE EXCHANGE_RATE
, CRH.ACCTD_AMOUNT ACCTD_AMOUNT
FROM AR_CASH_RECEIPT_HISTORY CRH
, AR_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'RECEIPT_CREATION_STATUS'
AND L.LOOKUP_CODE = CRH.STATUS

Columns