FND Design Data [Home] [Help]

View: ARBV_CREDIT_MEMO_APPLICATIONS

Product: AR - Receivables
Description:
Implementation/DBA Data: ViewAPPS.ARBV_CREDIT_MEMO_APPLICATIONS
View Text

SELECT /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID
, /* REGULAR ATTRIBUTES */ RA.AMOUNT_APPLIED
, RA.ACCTD_AMOUNT_APPLIED_TO
, RA.ACCTD_AMOUNT_APPLIED_FROM
, RA.APPLY_DATE
, RA.LINE_APPLIED
, RA.TAX_APPLIED
, RA.FREIGHT_APPLIED
, RA.RECEIVABLES_CHARGES_APPLIED
, RA.DAYS_LATE
, RA.USSGL_TRANSACTION_CODE
, RA.COMMENTS
, /* IDS */ RA.ORG_ID
, RA.CUSTOMER_TRX_ID
, RA.APPLIED_PAYMENT_SCHEDULE_ID
, RA.APPLIED_CUSTOMER_TRX_LINE_ID
, /* WHO COLUMNS */ RA.LAST_UPDATE_DATE
, RA.LAST_UPDATED_BY
, RA.CREATION_DATE
, RA.CREATED_BY
FROM AR_RECEIVABLE_APPLICATIONS RA
WHERE RA.APPLICATION_TYPE = 'CM' WITH READ ONLY

Columns

Name
RECEIVABLE_APPLICATION_ID
AMOUNT_APPLIED
AMOUNT_APPLIED_BASE
ALLOCATED_RECEIPT_AMOUNT_BASE
APPLY_DATE
LINE_AMOUNT_APPLIED
TAX_AMOUNT_APPLIED
FREIGHT_AMOUNT_APPLIED
RECEIVABLES_CHARGES_APPLIED
DAYS_LATE
USSGL_TRANSACTION_CODE
COMMENTS
ORG_ID
CUSTOMER_TRX_ID
APPLIED_PAYMENT_SCHEDULE_ID
TRANSACTION_LINE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY