Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
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'
, /* RESOLVED FK RESOLUTIONS */ AOU.NAME
, CR.RECEIPT_NUMBER
, BAT.NAME
, /* 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_ALL CRH
, HR_ALL_ORGANIZATION_UNITS AOU
, AR_CASH_RECEIPTS_ALL CR
, AR_BATCHES_ALL BAT
WHERE CRH.ORG_ID = AOU.ORGANIZATION_ID(+)
AND CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND CRH.BATCH_ID = BAT.BATCH_ID (+) WITH READ ONLY