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

TABLE: APPS.ASO_BI_QOT_RUL_MV

Object Details
Object Name: ASO_BI_QOT_RUL_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ASO_BI_QOT_RUL_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnPARENT_RESOURCE_GRP_ID
ColumnTIME_ID
ColumnPERIOD_TYPE_ID
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
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 does not reference any database object

APPS.ASO_BI_QOT_RUL_MV is referenced by following:

SchemaAPPS
Materialized ViewASO_BI_QOT_RUL_MV