[Home] [Help]
| Product: | AMS - Marketing |
|---|---|
| Description: | Deductions |
| Implementation/DBA Data: | Not implemented in this database |
SELECT C.CLAIM_ID
, C.CLAIM_NUMBER
, C.STATUS_CODE
, C.CUST_ACCOUNT_ID
, A.ACCOUNT_NAME
, A.ACCOUNT_NUMBER
, C.CURRENCY_CODE
, C.AMOUNT
, C.EXCHANGE_RATE_TYPE
, C.EXCHANGE_RATE
, C.EXCHANGE_RATE_DATE
, C.RECEIPT_ID
, C.RECEIPT_NUMBER
, C.SOURCE_OBJECT_ID
, C.SOURCE_OBJECT_CLASS
, C.SOURCE_OBJECT_TYPE_ID
, C.SOURCE_OBJECT_NUMBER
, C.SET_OF_BOOKS_ID
, C.ORG_ID
, C.DEDUCTION_ATTRIBUTE_CATEGORY
, C.DEDUCTION_ATTRIBUTE1
, C.DEDUCTION_ATTRIBUTE2
, C.DEDUCTION_ATTRIBUTE3
, C.DEDUCTION_ATTRIBUTE4
, C.DEDUCTION_ATTRIBUTE5
, C.DEDUCTION_ATTRIBUTE6
, C.DEDUCTION_ATTRIBUTE7
, C.DEDUCTION_ATTRIBUTE8
, C.DEDUCTION_ATTRIBUTE9
, C.DEDUCTION_ATTRIBUTE10
, C.DEDUCTION_ATTRIBUTE11
, C.DEDUCTION_ATTRIBUTE12
, C.DEDUCTION_ATTRIBUTE13
, C.DEDUCTION_ATTRIBUTE14
, C.DEDUCTION_ATTRIBUTE15
FROM OZF_CLAIMS C
, HZ_CUST_ACCOUNTS A
WHERE C.CLAIM_CLASS = 'DEDUCTION'
AND C. CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID