Product: | AR - Receivables |
---|---|
Description: | This shows information about cash applied to customer transactions. |
Implementation/DBA Data: | APPS.ARBV_CASH_APPLICATIONS |
SELECT /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID
, /* REGULAR ATTRIBUTES */ RA.AMOUNT_APPLIED
, RA.ACCTD_AMOUNT_APPLIED_TO
, RA.AMOUNT_APPLIED_FROM
, RA.ACCTD_AMOUNT_APPLIED_FROM
, RA.TRANS_TO_RECEIPT_RATE
, RA.APPLY_DATE
, '_LA:RA.STATUS:AR_LOOKUPS:PAYMENT_TYPE:MEANING'
, RA.LINE_APPLIED
, RA.TAX_APPLIED
, RA.FREIGHT_APPLIED
, RA.RECEIVABLES_CHARGES_APPLIED
, RA.EARNED_DISCOUNT_TAKEN
, RA.UNEARNED_DISCOUNT_TAKEN
, RA.ACCTD_EARNED_DISCOUNT_TAKEN
, RA.ACCTD_UNEARNED_DISCOUNT_TAKEN
, RA.LINE_EDISCOUNTED
, RA.TAX_EDISCOUNTED
, RA.FREIGHT_EDISCOUNTED
, RA.CHARGES_EDISCOUNTED
, RA.LINE_UEDISCOUNTED
, RA.TAX_UEDISCOUNTED
, RA.FREIGHT_UEDISCOUNTED
, RA.CHARGES_UEDISCOUNTED
, RA.DAYS_LATE
, '_LA:RA.CONFIRMED_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, RA.USSGL_TRANSACTION_CODE
, RA.COMMENTS
, /* IDS */ RA.ORG_ID
, RA.CASH_RECEIPT_ID
, RA.APPLIED_PAYMENT_SCHEDULE_ID
, RA.APPLIED_CUSTOMER_TRX_LINE_ID
, RA.SET_OF_BOOKS_ID
, /* WHO COLUMNS */ RA.LAST_UPDATE_DATE
, RA.LAST_UPDATED_BY
, RA.CREATION_DATE
, RA.CREATED_BY
, RA.STATUS
, RA.APPLIED_CUSTOMER_TRX_ID
FROM AR_RECEIVABLE_APPLICATIONS RA
WHERE RA.APPLICATION_TYPE = 'CASH' WITH READ ONLY