eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPS.ASO_BI_QOT_DISCB_MV

Object Details

Object Name:	ASO_BI_QOT_DISCB_MV
Object Type:	TABLE
Owner:	APPS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

APPS.ASO_BI_QOT_DISCB_MV does not reference any database object

APPS.ASO_BI_QOT_DISCB_MV is referenced by following:

APPS: ASO_BI_QOT_DISCB_MV; ASO_BI_QOT_DISC_MV