[Home] [Help] [Dependency Information]
Object Name: | ASO_BI_QOT_DISCB_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | ASO_BI_QOT_DISCB_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | TEXTMATCH |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
ASO_BI_DISC_BUK_MV
BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS
ASO_BI_QUOTE_HDRS_ALL
FII_TIME_DAY
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MARKER | VARCHAR2 | (4) | Marker for fast refreshability purpose | |
ROW_TYPE | CHAR | (6) | Marker to identify type of quotes pulled in | |
LOW | NUMBER | The low end of the bucket range | ||
RESOURCE_GRP_ID | NUMBER | Resource group id | ||
RESOURCE_ID | NUMBER | Resource id | ||
NEW_QOT_VAL | NUMBER | New quote amount in Primary Currency | ||
SEC_NEW_QOT_VAL | NUMBER | New quote amount in Secondary Currency | ||
NEW_QOT_CNT | NUMBER | New quote count | ||
OPN_QOT_VAL | NUMBER | Open quote amount in Primary Currency | ||
SEC_OPN_QOT_VAL | NUMBER | Open quote amount in Secondary Currency | ||
OPN_QOT_CNT | NUMBER | Open quote count | ||
CONV_QOT_VAL | NUMBER | Converted quote amount in Primary Currency | ||
SEC_CONV_QOT_VAL | NUMBER | Converted quote amount in Secondary Currency | ||
CONV_QOT_CNT | NUMBER | Converted quote number | ||
NEW_QOT_VAL_CNT | NUMBER | For fast refreshability purpose | ||
SEC_NEW_QOT_VAL_CNT | NUMBER | For fast refreshability purpose | ||
OPN_QOT_VAL_CNT | NUMBER | For fast refreshability purpose | ||
SEC_OPN_QOT_VAL_CNT | NUMBER | For fast refreshability purpose | ||
CNT_ALL | 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 | ||
GRP_ID_CNT | NUMBER | For fast refreshability purpose |
Cut, paste (and edit) the following text to query this object:
SELECT MARKER
, ROW_TYPE
, LOW
, RESOURCE_GRP_ID
, RESOURCE_ID
, NEW_QOT_VAL
, SEC_NEW_QOT_VAL
, NEW_QOT_CNT
, OPN_QOT_VAL
, SEC_OPN_QOT_VAL
, OPN_QOT_CNT
, CONV_QOT_VAL
, SEC_CONV_QOT_VAL
, CONV_QOT_CNT
, NEW_QOT_VAL_CNT
, SEC_NEW_QOT_VAL_CNT
, OPN_QOT_VAL_CNT
, SEC_OPN_QOT_VAL_CNT
, CNT_ALL
, ENT_YEAR_ID
, ENT_QTR_ID
, ENT_PERIOD_ID
, WEEK_ID
, DAY_ID
, GRP_ID_CNT
FROM APPS.ASO_BI_QOT_DISCB_MV;
|
|
|