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

Object Details

Object Name:	ASO_BI_QOT_RULB_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	Comments
UMARKER	CHAR	(6)	Marker for fast refreshability purpose
RESOURCE_GRP_ID	NUMBER		Resource group id
RESOURCE_ID	NUMBER		Resource id
OAM_RULE_ID	NUMBER		Approval rule id
OPEN	NUMBER		Open approval count
NEW	NUMBER		New approvals count
DAY_ID	NUMBER		Day id
WEEK_ID	NUMBER		Week id
ENT_PERIOD_ID	NUMBER		Period id
ENT_QTR_ID	NUMBER		Quarter id
ENT_YEAR_ID	NUMBER		Year id

Query Text

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


SELECT UMARKER
,      RESOURCE_GRP_ID
,      RESOURCE_ID
,      OAM_RULE_ID
,      OPEN
,      NEW
,      DAY_ID
,      WEEK_ID
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      ENT_YEAR_ID
FROM APPS.ASO_BI_QOT_RULB_MV;

Dependencies

[top of page]

APPS.ASO_BI_QOT_RULB_MV does not reference any database object

APPS.ASO_BI_QOT_RULB_MV is referenced by following:

APPS: ASO_BI_QOT_RULB_MV; ASO_BI_QOT_RUL_MV