Product: | AR - Receivables |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.ARBV_RECEIPT_HISTORIES |
SELECT /* UNIQUE ATTRIBUTES */ CRH.CASH_RECEIPT_HISTORY_ID
, /* REGULAR ATTRIBUTES */ CRH.AMOUNT
, CRH.FACTOR_DISCOUNT_AMOUNT
, CRH.ACCTD_AMOUNT
, CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT
, '_LA:CRH.STATUS:AR_LOOKUPS:RECEIPT_CREATION_STATUS:MEANING'
, CRH.EXCHANGE_DATE
, CRH.EXCHANGE_RATE
, CRH.EXCHANGE_RATE_TYPE
, '_LA:CRH.CURRENT_RECORD_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CRH.FACTOR_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CRH.NOTE_STATUS:AR_LOOKUPS:AR_NOTE_STATUS:MEANING'
, /* IDS */ CRH.ORG_ID
, CRH.CASH_RECEIPT_ID
, CRH.BATCH_ID
, /* WHO COLUMNS */ CRH.LAST_UPDATE_DATE
, CRH.LAST_UPDATED_BY
, CRH.CREATION_DATE
, CRH.CREATED_BY
FROM AR_CASH_RECEIPT_HISTORY CRH WITH READ ONLY