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]

TABLE: APPS.OZF_CUST_FUND_SUMMARY_MV

Object Details

Object Name:	OZF_CUST_FUND_SUMMARY_MV
Object Type:	TABLE
Owner:	APPS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

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 does not reference any database object

APPS.OZF_CUST_FUND_SUMMARY_MV is referenced by following:

APPS: OZF_CUST_FACTS_PVT - show dependent code; OZF_CUST_FUND_SUMMARY_MV