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: ASO.ASO_BI_QUOTE_IDS

Object Details

Object Name:	ASO_BI_QUOTE_IDS
Object Type:	TABLE
Owner:	ASO
FND Design Data:	ASO.ASO_BI_QUOTE_IDS
Subobject Name:
Status:	VALID

This table is used to divide the quotes into batches. Batch size is determined by the profile BIS_TXN_COMPLEXITY_LOW

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ASO_BI_QUOTE_IDS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID QUOTE_HEADER_ID

Columns

Name	Datatype	Comments
QUOTE_HEADER_ID	NUMBER	Unique identifier for the highest version of a quote
QUOTE_NUMBER	NUMBER	Quote Number
MAX_QUOTE_VERSION	NUMBER	Highest Quote Version
QUOTE_CREATION_DATE	DATE	Creation date of the first version of the Quote
BATCH_ID	NUMBER	Unique ID of a Batch used in Incremental Collection of Quotes
QUOTE_AMOUNT_FIRST	NUMBER	Quote Amount on first version of Quote

Query Text

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


SELECT QUOTE_HEADER_ID
,      QUOTE_NUMBER
,      MAX_QUOTE_VERSION
,      QUOTE_CREATION_DATE
,      BATCH_ID
,      QUOTE_AMOUNT_FIRST
FROM ASO.ASO_BI_QUOTE_IDS;

Dependencies

[top of page]

ASO.ASO_BI_QUOTE_IDS does not reference any database object

ASO.ASO_BI_QUOTE_IDS is referenced by following:

APPS: ASO_BI_QUOTE_IDS