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.ASO_BI_QOT_RUL_MV

Object Details

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

M-View Details

Container:	ASO_BI_QOT_RUL_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	TEXTMATCH
Refresh Mode:	DEMAND
Refresh Method:	FAST
Build Mode:	DEFERRED
Fast Refreshable:	DIRLOAD_DML

MV Log Dependencies:


ASO_BI_QOT_RULB_MV
     ASO_BI_APR_RUL_F
     FII_TIME_DAY
ASO_BI_RSG_PRNT_MV
     ASO_BI_TOP_RSG_MV
          JTF_RS_GROUPS_DENORM
          JTF_RS_GROUP_USAGES
     JTF_RS_GROUPS_DENORM
     JTF_RS_GROUP_USAGES
JTF_RS_GROUPS_DENORM

[View Source Query]

Columns

Name	Datatype	Length	Comments
UMARKER	CHAR	(1)	Marker for fast refreshability purpose
PARENT_RESOURCE_GRP_ID	NUMBER		Parent sales group of the group in the Resource_grp_id column
RESOURCE_GRP_ID	NUMBER		Resource group id
RESOURCE_ID	NUMBER		Resource id
RULE_ID	NUMBER		Approval rule id
OPEN_RULES	NUMBER		Rules contributing to open count
NEW_RULES	NUMBER		Rules contributing to new count
OPEN_XRULES	NUMBER		For fast refreshability purpose
NEW_XRULES	NUMBER		For fast refreshability purpose
RULE_XCNT	NUMBER		For fast refreshability purpose
ENT_YEAR_ID	NUMBER		Year id
ENT_QTR_ID	NUMBER		Quarter id
ENT_PERIOD_ID	NUMBER		Period id
WEEK_ID	NUMBER		Week id
DAY_ID	NUMBER		Day id
PERIOD_TYPE_ID	NUMBER		Period type id
TIME_ID	NUMBER		Time id
GRP_XCNT	NUMBER		For fast refreshability purpose

Query Text

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


SELECT UMARKER
,      PARENT_RESOURCE_GRP_ID
,      RESOURCE_GRP_ID
,      RESOURCE_ID
,      RULE_ID
,      OPEN_RULES
,      NEW_RULES
,      OPEN_XRULES
,      NEW_XRULES
,      RULE_XCNT
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      PERIOD_TYPE_ID
,      TIME_ID
,      GRP_XCNT
FROM APPS.ASO_BI_QOT_RUL_MV;

Dependencies

[top of page]

APPS.ASO_BI_QOT_RUL_MV references the following:

APPS: ASO_BI_QOT_RULB_MV; ASO_BI_QOT_RULB_MV; ASO_BI_QOT_RUL_MV; ASO_BI_RSG_PRNT_MV; ASO_BI_RSG_PRNT_MV
JTF: JTF_RS_GROUPS_DENORM

APPS.ASO_BI_QOT_RUL_MV is not referenced by any database object