VIEW: APPS.OZF_AR_DEDUCTIONS_V

Source

View Text - Preformatted

SELECT C.CLAIM_ID, C.CLAIM_NUMBER, C.STATUS_CODE, C.CUST_ACCOUNT_ID, 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.CUSTOMER_REASON, 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 WHERE C.CLAIM_CLASS in ( 'DEDUCTION', 'OVERPAYMENT')

View Text - HTML Formatted

SELECT C.CLAIM_ID
, C.CLAIM_NUMBER
, C.STATUS_CODE
, C.CUST_ACCOUNT_ID
, 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.CUSTOMER_REASON
, 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
WHERE C.CLAIM_CLASS IN ( 'DEDUCTION'
, 'OVERPAYMENT')