[Home] [Help] [Dependency Information]
Object Name: | ASO_BI_QOT_DISC_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ASO_BI_QOT_DISC_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
PERIOD_TYPE_ID RESOURCE_GRP_ID RESOURCE_ID |
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 |
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;
APPS.ASO_BI_QOT_DISC_MV does not reference any database object
APPS.ASO_BI_QOT_DISC_MV is referenced by following:
|
|
|