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_TOP_QOT_MV

Object Details

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

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ASO_BI_TOP_QOT_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PARENT_GROUP_ID PARTY_ID UMARKER STATUS RESOURCE_ID

Columns

Name	Datatype	Length	Comments
UMARKER	CHAR	(6)	Marker column used for identifying Sales Group and Sales Rep rows
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
PARENT_GROUP_ID	NUMBER		Parent group id
RESOURCE_GRP_ID	NUMBER		Resource Group id
RESOURCE_ID	NUMBER		Resource id
QUOTE_AMNT	NUMBER		Last Version Quote Amount in terms of Primary Currency
SEC_QUOTE_AMNT	NUMBER		Last Version Quote Amount in terms of Secondary Currency
QUOTE_AMOUNT_FIRST	NUMBER		First Version Quote Amount in terms of Primary Currency
SEC_QUOTE_AMOUNT_FIRST	NUMBER		First Version Quote Amount in terms of Secondary Currency
NUM_APPROVERS	NUMBER		Number Of Approvers
STATUS	VARCHAR2	(4)	Status
EFFECTIVE_DATE	DATE		Effective Date
YEAR	NUMBER		Period Type Year
QUARTER	NUMBER		Period Type Quarter
PERIOD	NUMBER		Period Type Month
WEEK	NUMBER		Period Type Week
YEAR_RANK	NUMBER		Year Rank with respect to Primary Currency
QUARTER_RANK	NUMBER		Quarter Rank with respect to Primary Currency
PERIOD_RANK	NUMBER		Period Rank with respect to Primary Currency
WEEK_RANK	NUMBER		Week Rank with respect to Primary Currency

Query Text

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


SELECT UMARKER
,      QUOTE_NAME
,      QUOTE_NUMBER
,      PARTY_ID
,      QUOTE_CREATION_DATE
,      QUOTE_EXPIRATION_DATE
,      ORDER_CREATION_DATE
,      QUOTE_AGE
,      PARENT_GROUP_ID
,      RESOURCE_GRP_ID
,      RESOURCE_ID
,      QUOTE_AMNT
,      SEC_QUOTE_AMNT
,      QUOTE_AMOUNT_FIRST
,      SEC_QUOTE_AMOUNT_FIRST
,      NUM_APPROVERS
,      STATUS
,      EFFECTIVE_DATE
,      YEAR
,      QUARTER
,      PERIOD
,      WEEK
,      YEAR_RANK
,      QUARTER_RANK
,      PERIOD_RANK
,      WEEK_RANK
FROM APPS.ASO_BI_TOP_QOT_MV;

Dependencies

[top of page]

APPS.ASO_BI_TOP_QOT_MV does not reference any database object

APPS.ASO_BI_TOP_QOT_MV is referenced by following:

APPS: ASO_BI_TOP_QOT_MV