VIEW: APPS.ARBV_RECEIPT_HISTORIES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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