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_TOP_QOTB_MV

Object Details

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

M-View Details

Container:	ASO_BI_TOP_QOTB_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	NONE
Refresh Mode:	DEMAND
Refresh Method:	FORCE
Build Mode:	DEFERRED
Fast Refreshable:	NO

MV Log Dependencies:


FII_TIME_DAY

[View Source Query]

Columns

Name	Datatype	Length	Comments
QUOTE_NAME	VARCHAR2	(240)	Quote Name
QUOTE_NUMBER	NUMBER		Quote Number
PARTY_ID	NUMBER		Party Id
QUOTE_CREATION_DATE	DATE		Quote Creation date
QUOTE_EXPIRATION_DATE	DATE		Quote Expiration date
ORDER_CREATION_DATE	DATE		Order Creation date
QUOTE_AGE	NUMBER		Quote Age in terms of days
RESOURCE_GRP_ID	NUMBER		Resource Group id
RESOURCE_ID	NUMBER		Resource id
NUM_APPROVERS	NUMBER		Number Of Approvers
QUOTE_AMNT	NUMBER		Last Version Quote Amount in terms of Primary Currency
QUOTE_AMOUNT_FIRST	NUMBER		First Version Quote Amount in terms of Primary Currency
STATUS	VARCHAR2	(4)	Status
EFFECTIVE_DATE	DATE		Effective Date
CONVERSION_RATE	NUMBER		Primary Conversion Rate
SEC_CONVERSION_RATE	NUMBER		Secondary Conversion Rate
YEAR	NUMBER		Period Type Year
QUARTER	NUMBER		Period Type Quarter
PERIOD	NUMBER		Period Type Month
WEEK	NUMBER		Period Type Week

Query Text

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


SELECT QUOTE_NAME
,      QUOTE_NUMBER
,      PARTY_ID
,      QUOTE_CREATION_DATE
,      QUOTE_EXPIRATION_DATE
,      ORDER_CREATION_DATE
,      QUOTE_AGE
,      RESOURCE_GRP_ID
,      RESOURCE_ID
,      NUM_APPROVERS
,      QUOTE_AMNT
,      QUOTE_AMOUNT_FIRST
,      STATUS
,      EFFECTIVE_DATE
,      CONVERSION_RATE
,      SEC_CONVERSION_RATE
,      YEAR
,      QUARTER
,      PERIOD
,      WEEK
FROM APPS.ASO_BI_TOP_QOTB_MV;

Dependencies

[top of page]

APPS.ASO_BI_TOP_QOTB_MV references the following:

APPS: ASO_BI_APR_F; ASO_BI_QUOTE_HDRS_ALL; ASO_BI_TOP_QOTB_MV; FII_TIME_DAY
ASO: ASO_BI_APR_F; ASO_BI_QUOTE_HDRS_ALL
FII: FII_TIME_DAY

APPS.ASO_BI_TOP_QOTB_MV is referenced by following:

APPS: ASO_BI_TOP_QOT_MV