[Home] [Help] [Dependency Information]
Object Name: | OZF_AR_DEDUCTIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view returns the deductions and overpayments in Trade Management.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLAIM_ID | NUMBER | Yes | ||
CLAIM_NUMBER | VARCHAR2 | (30) | ||
STATUS_CODE | VARCHAR2 | (30) | ||
CUST_ACCOUNT_ID | NUMBER | Yes | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
AMOUNT | NUMBER | |||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
EXCHANGE_RATE | NUMBER | |||
EXCHANGE_RATE_DATE | DATE | |||
RECEIPT_ID | NUMBER | |||
RECEIPT_NUMBER | VARCHAR2 | (30) | ||
SOURCE_OBJECT_ID | NUMBER | |||
SOURCE_OBJECT_CLASS | VARCHAR2 | (15) | ||
SOURCE_OBJECT_TYPE_ID | NUMBER | |||
SOURCE_OBJECT_NUMBER | VARCHAR2 | (30) | ||
CUSTOMER_REASON | VARCHAR2 | (30) | ||
SET_OF_BOOKS_ID | NUMBER | Yes | ||
ORG_ID | NUMBER | Yes | ||
DEDUCTION_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
DEDUCTION_ATTRIBUTE1 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE2 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE3 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE4 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE5 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE6 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE7 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE8 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE9 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE10 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE11 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE12 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE13 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE14 | VARCHAR2 | (150) | ||
DEDUCTION_ATTRIBUTE15 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT CLAIM_ID
, CLAIM_NUMBER
, STATUS_CODE
, CUST_ACCOUNT_ID
, 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
, CUSTOMER_REASON
, 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
FROM APPS.OZF_AR_DEDUCTIONS_V;
APPS.OZF_AR_DEDUCTIONS_V is not referenced by any database object
|
|
|