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

VIEW: APPS.OZF_FUNDS_PAID

Object Details
Object Name: OZF_FUNDS_PAID
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOZF.OZF_FUNDS_PAID
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Funds paid details


[View Source]

Columns
Name Datatype Length Mandatory Comments
UTILIZATION_ID NUMBER
Yes Fund Utilization Identifier
FUND_ID NUMBER
Yes Fund Identifier
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 (30)
Object Type
CLAIM_NUM VARCHAR2 (30)
Claim Number for the paid details if exists
CLAIM_DATE DATE
Yes Claim Date for the paid details if exists
CURRENCY VARCHAR2 (15)
Currency fo the paid amount.
CLAIM_ID NUMBER
Yes Claim Id for the paid details if exists
CLAIM_LINE_ID NUMBER

Claim Line Id for the paid details if exists
CUST_NAME VARCHAR2 (240)
Customer Name
PAYMENT_METHOD VARCHAR2 (30)
Payment Method for the paid details if exists
AMOUNT NUMBER

Paid Amount
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
,      CURRENCY
,      CLAIM_ID
,      CLAIM_LINE_ID
,      CUST_NAME
,      PAYMENT_METHOD
,      AMOUNT
FROM APPS.OZF_FUNDS_PAID;

Dependencies

[top of page]

APPS.OZF_FUNDS_PAID references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymOZF_CLAIMS
SynonymOZF_CLAIM_LINES
SynonymOZF_FUNDS_UTILIZED_ALL_B

APPS.OZF_FUNDS_PAID is not referenced by any database object