Skip to content

DBA Data[Home] [Help] [Dependency Information]

MATERIALIZED VIEW: APPS.ASO_BI_QOT_APR_MV

Object Details
Object Name: ASO_BI_QOT_APR_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ASO_BI_QOT_APR_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_APRB_MV
     ASO_BI_APR_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 Mandatory 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 references the following:

SchemaAPPS
Materialized ViewASO_BI_QOT_APRB_MV
TableASO_BI_QOT_APRB_MV
TableASO_BI_QOT_APR_MV
TableASO_BI_RSG_PRNT_MV
Materialized ViewASO_BI_RSG_PRNT_MV
SchemaJTF
TableJTF_RS_GROUPS_DENORM

APPS.ASO_BI_QOT_APR_MV is not referenced by any database object