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: PREBUILT
Fast Refreshable: NO
MV Log Dependencies:

OZF_OFFERS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
CUST_ACCOUNT_ID NUMBER

ITEM_CATEGORY_ID NUMBER

OFFER_TYPE VARCHAR2 (30)
OBJECT_TYPE VARCHAR2 (30)
ACTIVITY_TYPE NUMBER

ORG_ID NUMBER

AMOUNT_EARNED NUMBER

AMOUNT_EARNED_CNT NUMBER

AMOUNT_PAID NUMBER

AMOUNT_PAID_CNT NUMBER

AMOUNT_BALANCE NUMBER

AMOUNT_BALANCE_CNT NUMBER

ALL_CNT NUMBER

GRP_CUST_ACCOUNT_ID NUMBER

GRP_ITEM_CATEGORY_ID NUMBER

GRP_OFFER_TYPE NUMBER

GRP_OBJECT_TYPE NUMBER

GRP_ACTIVITY_TYPE NUMBER

PERIOD_TYPE_ID NUMBER

TIME_ID NUMBER

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:

SchemaAPPLSYS
TableFND_LOOKUP_VALUES
TableFND_PROFILE_OPTIONS
TableFND_PROFILE_OPTION_VALUES
SchemaAPPS
TableOZF_EARNING_SUMMARY_MV
SchemaINV
TableMTL_CATEGORIES_B
TableMTL_CATEGORY_SETS_B
TableMTL_CATEGORY_SETS_TL
TableMTL_DEFAULT_CATEGORY_SETS
TableMTL_ITEM_CATEGORIES
SchemaOZF
TableOZF_FUNDS_UTILIZED_ALL_B
TableOZF_OFFERS
TableOZF_TIME_DAY

APPS.OZF_EARNING_SUMMARY_MV is not referenced by any database object