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_FUNDS_PAID_V

Object Details

Object Name:	OZF_FUNDS_PAID_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OZF.OZF_FUNDS_PAID_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
UTILIZATION_ID	NUMBER		Internal identifier for fund utilization
FUND_ID	NUMBER		Fund against which the amount is being paid
PLAN_TYPE	VARCHAR2	(30)	Plan Type for eg. 'CAMP','EVEH'
PLAN_ID	NUMBER		Plan Identifier for eg. Campaign Id , Event Id
COMPONENT_TYPE	VARCHAR2	(30)	Component Type for eg. 'CSCH'
COMPONENT_ID	NUMBER		Component Identifier
OBJECT_TYPE	VARCHAR2	(120)	Object Type
CLAIM_NUM	VARCHAR2	(30)	Claim Number for the paid details if exists
CLAIM_DATE	DATE		Claim Date for the paid details if exists
CUST_NAME	VARCHAR2	(360)	Customer Name
PAYMENT_METHOD	VARCHAR2	(30)	Payment Method for the paid details if exists
AMOUNT	NUMBER		Paid Amount
CLAIM_ID	NUMBER		Internal identifier for the settlement id.
CLAIM_LINE_ID	NUMBER		Internal identifier for the settlement line.
CUSTOM_SETUP_ID	NUMBER		Custom Setup Identifier
FUND_CURRENCY	VARCHAR2	(15)
AMOUNT_IN_BUDGET	NUMBER
CLAIM_LINE_UTIL_ID	NUMBER		id for claim line util table
DOC_TYPE	VARCHAR2	(30)	Document type such as 'ORDER','INVOICE','TP_ORDER'
DOC_ID	NUMBER		Document id
PRODUCT_LEVEL_TYPE	VARCHAR2	(30)	Product type: 'PRODUCT','FAMILY'
PRODUCT_ID	NUMBER		Product Id
GL_POSTED_FLAG	VARCHAR2	(1)	gl_posted_flag. 'Y', 'N','F',Null
UNIV_CURR_AMOUNT	NUMBER		Amount in TM reporting currency
ACCTD_AMOUNT	NUMBER		Amount in Functional Currency

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT UTILIZATION_ID
,      FUND_ID
,      PLAN_TYPE
,      PLAN_ID
,      COMPONENT_TYPE
,      COMPONENT_ID
,      OBJECT_TYPE
,      CLAIM_NUM
,      CLAIM_DATE
,      CUST_NAME
,      PAYMENT_METHOD
,      AMOUNT
,      CLAIM_ID
,      CLAIM_LINE_ID
,      CUSTOM_SETUP_ID
,      FUND_CURRENCY
,      AMOUNT_IN_BUDGET
,      CLAIM_LINE_UTIL_ID
,      DOC_TYPE
,      DOC_ID
,      PRODUCT_LEVEL_TYPE
,      PRODUCT_ID
,      GL_POSTED_FLAG
,      UNIV_CURR_AMOUNT
,      ACCTD_AMOUNT
FROM APPS.OZF_FUNDS_PAID_V;

Dependencies

[top of page]

APPS.OZF_FUNDS_PAID_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_PARTIES; OZF_CLAIMS_ALL; OZF_CLAIM_LINES_ALL; OZF_CLAIM_LINES_UTIL_ALL; OZF_CLAIM_TYPES_ALL_VL; OZF_FUNDS_UTILIZED_ALL_B

APPS.OZF_FUNDS_PAID_V is referenced by following:

APPS: OZF_CUST_FUND_SUMMARY_MV