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]

MATERIALIZED VIEW: APPS.OZF_CUST_FUND_SUMMARY_MV

Object Details

Object Name:	OZF_CUST_FUND_SUMMARY_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	OZF_CUST_FUND_SUMMARY_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	NONE
Refresh Mode:	DEMAND
Refresh Method:	FORCE
Build Mode:	IMMEDIATE
Fast Refreshable:	NO

MV Log Dependencies:


HZ_PARTIES

[View Source Query]

Columns

Name	Datatype	Length
TIME_ID	NUMBER
PERIOD_TYPE_ID	NUMBER
PARTY_ID	NUMBER	(15)
CUST_ACCOUNT_ID	NUMBER
BILL_TO_SITE_USE_ID	NUMBER
SHIP_TO_SITE_USE_ID	NUMBER
PRODUCT_LEVEL_TYPE	VARCHAR2	(30)
PRODUCT_ID	NUMBER
PLAN_TYPE	VARCHAR2	(30)
PLAN_ID	NUMBER
FUND_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
STATUS_CODE	VARCHAR2	(30)
OWNER	NUMBER
CATEGORY_ID	NUMBER
ORG_ID	NUMBER
UTILIZED_AMT	NUMBER
EARNED_AMT	NUMBER
PAID_AMT	NUMBER
FUNC_CURR_UTILIZED_AMT	NUMBER
FUNC_CURR_EARNED_AMT	NUMBER
FUNC_CURR_PAID_AMT	NUMBER
PLAN_CURR_UTILIZED_AMT	NUMBER
PLAN_CURR_EARNED_AMT	NUMBER
PLAN_CURR_PAID_AMT	NUMBER
UNIV_CURR_UTILIZED_AMT	NUMBER
UNIV_CURR_EARNED_AMT	NUMBER
UNIV_CURR_PAID_AMT	NUMBER

Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      PRODUCT_LEVEL_TYPE
,      PRODUCT_ID
,      PLAN_TYPE
,      PLAN_ID
,      FUND_ID
,      CURRENCY_CODE
,      STATUS_CODE
,      OWNER
,      CATEGORY_ID
,      ORG_ID
,      UTILIZED_AMT
,      EARNED_AMT
,      PAID_AMT
,      FUNC_CURR_UTILIZED_AMT
,      FUNC_CURR_EARNED_AMT
,      FUNC_CURR_PAID_AMT
,      PLAN_CURR_UTILIZED_AMT
,      PLAN_CURR_EARNED_AMT
,      PLAN_CURR_PAID_AMT
,      UNIV_CURR_UTILIZED_AMT
,      UNIV_CURR_EARNED_AMT
,      UNIV_CURR_PAID_AMT
FROM APPS.OZF_CUST_FUND_SUMMARY_MV;

Dependencies

[top of page]

APPS.OZF_CUST_FUND_SUMMARY_MV 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_B; OZF_CLAIM_TYPES_ALL_TL; OZF_CLAIM_TYPES_ALL_VL; OZF_CUST_FUND_SUMMARY_MV; OZF_FUNDS_ALL_B; OZF_FUNDS_PAID_V; OZF_FUNDS_UTILIZED_ALL_B; OZF_TIME_DAY
AR: HZ_CUST_ACCOUNTS; HZ_PARTIES
OZF: OZF_CLAIMS_ALL; OZF_CLAIM_LINES_ALL; OZF_CLAIM_LINES_UTIL_ALL; OZF_CLAIM_TYPES_ALL_B; OZF_CLAIM_TYPES_ALL_TL; OZF_FUNDS_ALL_B; OZF_FUNDS_UTILIZED_ALL_B; OZF_TIME_DAY

APPS.OZF_CUST_FUND_SUMMARY_MV is not referenced by any database object