VIEW: APPS.AR_RGW_RECEIPT_HISTORY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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