[Home] [Help]
View: AMS_AR_DEDUCTIONS_V
Product: | AMS - Marketing |
Description: | Deductions |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
CLAIM_ID |
CLAIM_NUMBER |
STATUS_CODE |
CUST_ACCOUNT_ID |
ACCOUNT_NAME |
ACCOUNT_NUMBER |
CURRENCY_CODE |
AMOUNT |
EXCHANGE_RATE_TYPE |
EXCHANGE_RATE |
EXCHANGE_RATE_DATE |
RECEIPT_ID |
RECEIPT_NUMBER |
SOURCE_OBJECT_ID |
SOURCE_OBJECT_CLASS |
SOURCE_OBJECT_TYPE_ID |
SOURCE_OBJECT_NUMBER |
SET_OF_BOOKS_ID |
ORG_ID |
DEDUCTION_ATTRIBUTE_CATEGORY |
DEDUCTION_ATTRIBUTE1 |
DEDUCTION_ATTRIBUTE2 |
DEDUCTION_ATTRIBUTE3 |
DEDUCTION_ATTRIBUTE4 |
DEDUCTION_ATTRIBUTE5 |
DEDUCTION_ATTRIBUTE6 |
DEDUCTION_ATTRIBUTE7 |
DEDUCTION_ATTRIBUTE8 |
DEDUCTION_ATTRIBUTE9 |
DEDUCTION_ATTRIBUTE10 |
DEDUCTION_ATTRIBUTE11 |
DEDUCTION_ATTRIBUTE12 |
DEDUCTION_ATTRIBUTE13 |
DEDUCTION_ATTRIBUTE14 |
DEDUCTION_ATTRIBUTE15 |