eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.OZF_AR_DEDUCTIONS_V

Object Details

Object Name:	OZF_AR_DEDUCTIONS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view returns the deductions and overpayments in Trade Management.

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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;

Dependencies

[top of page]

APPS.OZF_AR_DEDUCTIONS_V references the following:

APPS: OZF_CLAIMS

APPS.OZF_AR_DEDUCTIONS_V is not referenced by any database object