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_EARNING_SUMMARY_MV

Object Details

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

M-View Details

Container:	OZF_EARNING_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:


OZF_OFFERS

[View Source Query]

Columns

Name	Datatype	Length	Comments
CUST_ACCOUNT_ID	NUMBER		Customer Account Identifier
ITEM_CATEGORY_ID	NUMBER		Inventory Item Category Identifier
OFFER_TYPE	VARCHAR2	(30)	Offer Type
OBJECT_TYPE	VARCHAR2	(30)	Direct or Indirect Sales Identifier
ACTIVITY_TYPE	NUMBER		Marketing Activity Type Identifier
ORG_ID	NUMBER		Operating Unit Identifier
AMOUNT_EARNED	NUMBER		Earned Amount in Accounted Currency
AMOUNT_EARNED_CNT	NUMBER		Row count used in materialized views
AMOUNT_PAID	NUMBER		Paid Amount in Accounted Currency
AMOUNT_PAID_CNT	NUMBER		Row count used in materialized views
AMOUNT_BALANCE	NUMBER		Balance Amount in Accounted Currency
AMOUNT_BALANCE_CNT	NUMBER		Row count used in materialized views
ALL_CNT	NUMBER		Row count used in materialized views
GRP_CUST_ACCOUNT_ID	NUMBER		Dimension identifier used in materialized views
GRP_ITEM_CATEGORY_ID	NUMBER		Dimension identifier used in materialized views
GRP_OFFER_TYPE	NUMBER		Dimension identifier used in materialized views
GRP_OBJECT_TYPE	NUMBER		Dimension identifier used in materialized views
GRP_ACTIVITY_TYPE	NUMBER		Dimension identifier used in materialized views
PERIOD_TYPE_ID	NUMBER		Period Type Identifier. Valid values are 1 for Day. 16 for Week. 32 for Month. 64 for Quarter and 128 for Year.
TIME_ID	NUMBER		Time dimention Identifier. This column along with the PERIOD_TYPE_ID column uniquely identify a time dimention.

Query Text

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


SELECT CUST_ACCOUNT_ID
,      ITEM_CATEGORY_ID
,      OFFER_TYPE
,      OBJECT_TYPE
,      ACTIVITY_TYPE
,      ORG_ID
,      AMOUNT_EARNED
,      AMOUNT_EARNED_CNT
,      AMOUNT_PAID
,      AMOUNT_PAID_CNT
,      AMOUNT_BALANCE
,      AMOUNT_BALANCE_CNT
,      ALL_CNT
,      GRP_CUST_ACCOUNT_ID
,      GRP_ITEM_CATEGORY_ID
,      GRP_OFFER_TYPE
,      GRP_OBJECT_TYPE
,      GRP_ACTIVITY_TYPE
,      PERIOD_TYPE_ID
,      TIME_ID
FROM APPS.OZF_EARNING_SUMMARY_MV;

Dependencies

[top of page]

APPS.OZF_EARNING_SUMMARY_MV references the following:

APPS: FND_PROFILE - show dependent code; MTL_DEFAULT_CATEGORY_SETS; MTL_ITEM_CATEGORIES; OZF_EARNING_SUMMARY_MV; OZF_FUNDS_UTILIZED_ALL_B; OZF_OFFERS; OZF_TIME_DAY
INV: MTL_DEFAULT_CATEGORY_SETS; MTL_ITEM_CATEGORIES
OZF: OZF_FUNDS_UTILIZED_ALL_B; OZF_OFFERS; OZF_TIME_DAY

APPS.OZF_EARNING_SUMMARY_MV is not referenced by any database object