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]

MATERIALIZED VIEW: APPS.ASO_BI_QOT_L1_MV

Object Details

Object Name:	ASO_BI_QOT_L1_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	ASO_BI_QOT_L1_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_QUOTE_HDRS_ALL
FII_TIME_DAY

[View Source Query]

Columns

Name	Datatype	Length	Comments
UMARKER	VARCHAR2	(4)	Marker for fast refreshability purpose
RESOURCE_GRP_ID	NUMBER		Resource group id
RESOURCE_ID	NUMBER		Resource id
PARTY_ID	NUMBER		Party id
NEWQOT_AMNT	NUMBER		New quote amount in Primary Currency
SEC_NEWQOT_AMNT	NUMBER		New quote amount in Secondary Currency
NEWQOT_NUMBER	NUMBER		New quote count
OPENQOT_AMNT	NUMBER		Open quote amount in Primary Currency
SEC_OPENQOT_AMNT	NUMBER		Open quote amount in Secondary Currency
OPENQOT_NUMBER	NUMBER		Open quote count
CONVQOT_AMNT	NUMBER		Converted quote amount in Primary Currency
SEC_CONVQOT_AMNT	NUMBER		Converted quote amount in Secondary Currency
CONVQOT_NUMBER	NUMBER		Converted quote number
ALL_CNT	NUMBER		For fast refreshability purpose
CONV_DAYS	NUMBER		Days for conversion
ROW_TYPE	CHAR	(6)	Marker to identify type of quotes pulled in
CONV_DAYS_CNT	NUMBER		For fast refreshability purpose
NEWQOT_AMNT_CNT	NUMBER		For fast refreshability purpose
SEC_NEWQOT_AMNT_CNT	NUMBER		For fast refreshability purpose
OPENQOT_AMNT_CNT	NUMBER		For fast refreshability purpose
SEC_OPENQOT_AMNT_CNT	NUMBER		For fast refreshability purpose
OPENQOT_NUMBER_CNT	NUMBER		For fast refreshability purpose
CONVQOT_AMNT_CNT	NUMBER		For fast refreshability purpose
SEC_CONVQOT_AMNT_CNT	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	NUMBER		For fast refreshability purpose

Query Text

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


SELECT UMARKER
,      RESOURCE_GRP_ID
,      RESOURCE_ID
,      PARTY_ID
,      NEWQOT_AMNT
,      SEC_NEWQOT_AMNT
,      NEWQOT_NUMBER
,      OPENQOT_AMNT
,      SEC_OPENQOT_AMNT
,      OPENQOT_NUMBER
,      CONVQOT_AMNT
,      SEC_CONVQOT_AMNT
,      CONVQOT_NUMBER
,      ALL_CNT
,      CONV_DAYS
,      ROW_TYPE
,      CONV_DAYS_CNT
,      NEWQOT_AMNT_CNT
,      SEC_NEWQOT_AMNT_CNT
,      OPENQOT_AMNT_CNT
,      SEC_OPENQOT_AMNT_CNT
,      OPENQOT_NUMBER_CNT
,      CONVQOT_AMNT_CNT
,      SEC_CONVQOT_AMNT_CNT
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      GRP_ID
FROM APPS.ASO_BI_QOT_L1_MV;

Dependencies

[top of page]

APPS.ASO_BI_QOT_L1_MV references the following:

APPS: ASO_BI_QOT_L1_MV
ASO: ASO_BI_QUOTE_HDRS_ALL
FII: FII_TIME_DAY

APPS.ASO_BI_QOT_L1_MV is referenced by following:

APPS: ASO_BI_QOT_CUSTB_MV; ASO_BI_QOT_SG_MV