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

MATERIALIZED VIEW: APPS.ASO_BI_QOT_DISC_MV

Object Details
Object Name: ASO_BI_QOT_DISC_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ASO_BI_QOT_DISC_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_DISCB_MV
     ASO_BI_DISC_BUK_MV
          BIS_BUCKET
          BIS_BUCKET_CUSTOMIZATIONS
     ASO_BI_QUOTE_HDRS_ALL
     FII_TIME_DAY
JTF_RS_GROUPS_DENORM
JTF_RS_GROUP_USAGES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
UMARKER CHAR (1)
Marker for fast refreshability purpose
LOW NUMBER

The low end of the bucket range
RESOURCE_GRP_ID NUMBER

Resource group id
RESOURCE_ID NUMBER

Resource id
RESOURCE_GRP_FLAG CHAR (1)
Marker used to indicate group or resource
NEW_VAL NUMBER

New quote amount in Primary Currency
SEC_NEW_VAL NUMBER

New quote amount in Secondary Currency
OPN_VAL NUMBER

Open quote amount in Primary Currency
SEC_OPN_VAL NUMBER

Open quote amount in Secondary Currency
CONV_VAL NUMBER

Converted quote amount in Primary Currency
SEC_CONV_VAL NUMBER

Converted quote amount in Secondary Currency
NEW_VAL_CNT NUMBER

For fast refreshability purpose
SEC_NEW_VAL_CNT NUMBER

For fast refreshability purpose
OPN_VAL_CNT NUMBER

For fast refreshability purpose
SEC_OPN_VAL_CNT NUMBER

For fast refreshability purpose
CONV_VAL_CNT NUMBER

For fast refreshability purpose
SEC_CONV_VAL_CNT NUMBER

For fast refreshability purpose
NEW_CNT NUMBER

New quote count
OPN_CNT NUMBER

Open quote count
CONV_CNT NUMBER

Converted quote number
NEW_CNT_CNT NUMBER

For fast refreshability purpose
OPN_CNT_CNT NUMBER

For fast refreshability purpose
CONV_CNT_CNT NUMBER

For fast refreshability purpose
ALL_COUNT 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
TIME_ID NUMBER

Time id
PERIOD_TYPE_ID NUMBER

Period type id
GRP_ID NUMBER

For fast refreshability purpose
Query Text

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


SELECT UMARKER
,      LOW
,      RESOURCE_GRP_ID
,      RESOURCE_ID
,      RESOURCE_GRP_FLAG
,      NEW_VAL
,      SEC_NEW_VAL
,      OPN_VAL
,      SEC_OPN_VAL
,      CONV_VAL
,      SEC_CONV_VAL
,      NEW_VAL_CNT
,      SEC_NEW_VAL_CNT
,      OPN_VAL_CNT
,      SEC_OPN_VAL_CNT
,      CONV_VAL_CNT
,      SEC_CONV_VAL_CNT
,      NEW_CNT
,      OPN_CNT
,      CONV_CNT
,      NEW_CNT_CNT
,      OPN_CNT_CNT
,      CONV_CNT_CNT
,      ALL_COUNT
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      GRP_ID
FROM APPS.ASO_BI_QOT_DISC_MV;

Dependencies

[top of page]

APPS.ASO_BI_QOT_DISC_MV references the following:

SchemaAPPS
TableASO_BI_QOT_DISCB_MV
Materialized ViewASO_BI_QOT_DISCB_MV
TableASO_BI_QOT_DISC_MV
SchemaJTF
TableJTF_RS_GROUPS_DENORM
TableJTF_RS_GROUP_USAGES

APPS.ASO_BI_QOT_DISC_MV is not referenced by any database object