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_APR_MV

Object Details

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

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ASO_BI_QOT_APR_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID PERIOD_TYPE_ID PARENT_RESOURCE_GRP_ID RESOURCE_ID

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
OPEN_APPROVALS	NUMBER		Open approval count
NEW_APPROVALS	NUMBER		New approvals count
COMPLETE_APPROVALS	NUMBER		Completed approvals count
APPROVED_APPROVALS	NUMBER		Approved approvals count
DAYS_FOR_APPROVAL	NUMBER		Number of days for approval
NUMBER_OF_APPROVERS	NUMBER		Number of approvers
OPEN_APPROVALS_XCNT	NUMBER		For fast refreshability purpose
NEW_APPROVALS_XCNT	NUMBER		For fast refreshability purpose
COMPLETE_APPROVALS_XCNT	NUMBER		For fast refreshability purpose
APPROVED_APPROVALS_XCNT	NUMBER		For fast refreshability purpose
DAYS_FOR_APPROVAL_XCNT	NUMBER		For fast refreshability purpose
NUMBER_OF_APPROVERS_XCNT	NUMBER		For fast refreshability purpose
ALL_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_XID	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
,      OPEN_APPROVALS
,      NEW_APPROVALS
,      COMPLETE_APPROVALS
,      APPROVED_APPROVALS
,      DAYS_FOR_APPROVAL
,      NUMBER_OF_APPROVERS
,      OPEN_APPROVALS_XCNT
,      NEW_APPROVALS_XCNT
,      COMPLETE_APPROVALS_XCNT
,      APPROVED_APPROVALS_XCNT
,      DAYS_FOR_APPROVAL_XCNT
,      NUMBER_OF_APPROVERS_XCNT
,      ALL_XCNT
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      PERIOD_TYPE_ID
,      TIME_ID
,      GRP_XID
FROM APPS.ASO_BI_QOT_APR_MV;

Dependencies

[top of page]

APPS.ASO_BI_QOT_APR_MV does not reference any database object

APPS.ASO_BI_QOT_APR_MV is referenced by following:

APPS: ASO_BI_QOT_APR_MV