VIEW: APPS.ARFV_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' , /* 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 CRH, HR_ALL_ORGANIZATION_UNITS AOU, AR_CASH_RECEIPTS CR, AR_BATCHES 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

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'
, /* 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 CRH
, HR_ALL_ORGANIZATION_UNITS AOU
, AR_CASH_RECEIPTS CR
, AR_BATCHES 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