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_HDRS_STG

Object Details

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

This interface table is used as a staging table for ASO_BI_QUOTE_HDRS_ALL. The main purpose of this staging table is to stop processing if any of the Currency Conversion from Transactional to Primary DBI currency is missing.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ASO_BI_QUOTE_HDRS_STG_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	QUOTE_NUMBER
ASO_BI_QUOTE_HDRS_STG_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	CONVERSION_RATE

Columns

Name	Datatype	Length	Comments
QUOTE_NUMBER	NUMBER		Quote Number
QUOTE_VERSION	NUMBER		Quote Version
QUOTE_HEADER_ID	NUMBER		Unique identifier for the highest version of a quote
QUOTE_CREATION_DATE	DATE		Creation Date of the first version of the quote
QUOTE_LAST_UPDATE_DATE	DATE		Last Update Date of the Quote
RESOURCE_ID	NUMBER		Resource Identifier
RESOURCE_GRP_ID	NUMBER		Resource/sales Group Identifier
QUOTE_EXPIRATION_DATE	DATE		Expiration Date of the Quote
CURRENCY_CODE	VARCHAR2	(15)	Transactional Currency
REPORTING_CURRENCY	VARCHAR2	(15)	Primary Reporting Currency derived from Global DBI setup
CONVERSION_RATE	NUMBER		Conversion rate from Currency Code to the Reporting Currency on the last update date of the Quote. DBI Global Conversion Type is used for getting conversion rate
QUOTE_VALUE	NUMBER		Total Quote Amount including adjustments
TOTAL_ADJUSTED_AMOUNT	NUMBER		Adjusted Amount
ORDER_ID	NUMBER		Order Identifier
ORDER_CREATION_DATE	DATE		Creation Date of the Order from OE_ORDER_HEADERS_ALL
LEAD_ID	NUMBER		Lead/Opportunity Identifier for a quote converted from an opportunity
PARTY_ID	NUMBER		Sold to Party identifier
MARKETING_SOURCE_CODE_ID	NUMBER		Marketing Source Code Identifier
TOTAL_ADJUSTED_PERCENT	NUMBER		Total Adjusted Percent
SEC_CONVERSION_RATE	NUMBER		Secondary Conversion Rate
QUOTE_AMOUNT_FIRST	NUMBER		Quote Amount on first version of Quote
QUOTE_NAME	VARCHAR2	(240)	Quote Name
RECURRING_CHARGE_FLAG	VARCHAR2	(1)	Indicates whether the item has a recurring charge or not.

Query Text

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


SELECT QUOTE_NUMBER
,      QUOTE_VERSION
,      QUOTE_HEADER_ID
,      QUOTE_CREATION_DATE
,      QUOTE_LAST_UPDATE_DATE
,      RESOURCE_ID
,      RESOURCE_GRP_ID
,      QUOTE_EXPIRATION_DATE
,      CURRENCY_CODE
,      REPORTING_CURRENCY
,      CONVERSION_RATE
,      QUOTE_VALUE
,      TOTAL_ADJUSTED_AMOUNT
,      ORDER_ID
,      ORDER_CREATION_DATE
,      LEAD_ID
,      PARTY_ID
,      MARKETING_SOURCE_CODE_ID
,      TOTAL_ADJUSTED_PERCENT
,      SEC_CONVERSION_RATE
,      QUOTE_AMOUNT_FIRST
,      QUOTE_NAME
,      RECURRING_CHARGE_FLAG
FROM ASO.ASO_BI_QUOTE_HDRS_STG;

Dependencies

[top of page]

ASO.ASO_BI_QUOTE_HDRS_STG does not reference any database object

ASO.ASO_BI_QUOTE_HDRS_STG is referenced by following:

APPS: ASO_BI_QUOTE_HDRS_STG