View: ARBV_ON_ACCOUNT_CREDIT_MEMOS

Product:	AR - Receivables
Description:	This shows information about credits that you assign to your customer's account that are not related to a specific invoice.
Implementation/DBA Data:	APPS.ARBV_ON_ACCOUNT_CREDIT_MEMOS

View Text

SELECT /* UNIQUE ATTRIBUTES */ CT.CUSTOMER_TRX_ID
, /* REGULAR ATTRIBUTES */ CT.TRX_NUMBER
, CT.DOC_SEQUENCE_VALUE
, CT.TRX_DATE
, CT.EXCHANGE_RATE
, CT.EXCHANGE_RATE_TYPE
, CT.EXCHANGE_DATE
, '_LA:CT.COMPLETE_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CT.STATUS_TRX:AR_LOOKUPS:INVOICE_TRX_STATUS:MEANING'
, CT.PURCHASE_ORDER
, CT.PURCHASE_ORDER_DATE
, CT.PURCHASE_ORDER_REVISION
, CT.CUSTOMER_REFERENCE
, '_LA:CT.FINANCE_CHARGES:AR_LOOKUPS:YES/NO:MEANING'
, CT.TERM_DUE_DATE
, '_LA:CT.DEFAULT_TAX_EXEMPT_FLAG:AR_LOOKUPS:TAX_CONTROL_FLAG:MEANING'
, CT.SHIP_VIA
, CT.SHIP_DATE_ACTUAL
, CT.WAYBILL_NUMBER
, '_LA:CT.FOB_POINT:AR_LOOKUPS:FOB:MEANING'
, '_LA:CT.EDI_PROCESSED_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, CT.PRINTING_ORIGINAL_DATE
, CT.PRINTING_LAST_PRINTED
, '_LA:CT.PRINTING_PENDING:AR_LOOKUPS:YES/NO:MEANING'
, CT.PRINTING_COUNT
, CT.ORIG_SYSTEM_BATCH_NAME
, /* IDS */ CT.BATCH_ID
, CT.TERM_ID
, CT.BILL_TO_CONTACT_ID
, CT.SHIP_TO_CONTACT_ID
, CT.SOLD_TO_CONTACT_ID
, CT.BILL_TO_CUSTOMER_ID
, CT.SHIP_TO_CUSTOMER_ID
, CT.SOLD_TO_CUSTOMER_ID
, CT.PAYING_CUSTOMER_ID
, CT.CUST_TRX_TYPE_ID
, CT.PRIMARY_SALESREP_ID
, CT.BILL_TO_SITE_USE_ID
, CT.SHIP_TO_SITE_USE_ID
, CT.SOLD_TO_SITE_USE_ID
, CT.PAYING_SITE_USE_ID
, CT.REMIT_TO_ADDRESS_ID
, CT.CUSTOMER_BANK_ACCOUNT_ID
, CT.RECEIPT_METHOD_ID
, CT.ORG_ID
, /* WHO COLUMNS */ CT.LAST_UPDATE_DATE
, CT.LAST_UPDATED_BY
, CT.CREATION_DATE
, CT.CREATED_BY
FROM RA_CUSTOMER_TRX CT
, RA_CUST_TRX_TYPES CTT
WHERE CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND ((CT.CUST_TRX_TYPE_ID IS NULL) OR (CT.CUST_TRX_TYPE_ID IS NOT NULL
AND NVL(CT.ORG_ID
, -12345) = NVL(CTT.ORG_ID
, -12345)))
AND CTT.TYPE = 'CM'
AND CT.PREVIOUS_CUSTOMER_TRX_ID IS NULL WITH READ ONLY

Columns