[Home] [Help]
View: AR_TA_DEDUCTIONS_V
Product: | AR - Receivables |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CTRX.TRX_NUMBER DEDUCTION_NUMBER
, CTRX.TRX_DATE DEDUCTION_DATE
, CTRX.STATUS_TRX STATUS
FROM RA_CUST_TRX_TYPES CTT
, RA_CUSTOMER_TRX CTRX
WHERE CTRX.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND ((CTT.ATTRIBUTE10 = 'DED') OR (CTT.ATTRIBUTE10 = 'UCD'))
Columns
Name |
DEDUCTION_NUMBER |
DEDUCTION_DATE |
STATUS |