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_LINE_IDS

Object Details

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

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

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

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
QUOTE_LINE_ID	NUMBER	Unique Identifier of a Quote Line
BATCH_ID	NUMBER	Unique ID of a Batch used in Incremental Collection of Lines

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
,      QUOTE_LINE_ID
,      BATCH_ID
FROM ASO.ASO_BI_LINE_IDS;

Dependencies

[top of page]

ASO.ASO_BI_LINE_IDS does not reference any database object

ASO.ASO_BI_LINE_IDS is referenced by following:

APPS: ASO_BI_LINE_IDS