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_ALL

Object Details

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

This is the base table used for Summarizing Quote header level information by period , by Sales Group and Sales Person. The table pulls in data from ASO_QUOTE_HEADERS_ALL and is used for Daily Business Inelligence for Quoting.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ASO_BI_QUOTE_HDRS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	QUOTE_NUMBER
ASO_BI_QUOTE_HDRS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CONVERSION_RATE
ASO_BI_QUOTE_HDRS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RESOURCE_GRP_ID RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	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 on 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 code
REPORTING_CURRENCY	VARCHAR2	(15)		Primary Reporting Currency derived from DBI Global Setups
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 Price including Adjustments
TOTAL_ADJUSTED_AMOUNT	NUMBER			Adjustment Amount
ORDER_ID	NUMBER			Order Header Identifier
ORDER_CREATION_DATE	DATE			Order Creation Date 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
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	NUMBER			Security Group id
TOTAL_ADJUSTED_PERCENT	NUMBER			Total Adjusted Percent
SEC_CONVERSION_RATE	NUMBER			Secondary Conversion Rate
QUOTE_AMOUNT_FIRST	NUMBER			Quote Amount on the first version of the 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
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      TOTAL_ADJUSTED_PERCENT
,      SEC_CONVERSION_RATE
,      QUOTE_AMOUNT_FIRST
,      QUOTE_NAME
,      RECURRING_CHARGE_FLAG
FROM ASO.ASO_BI_QUOTE_HDRS_ALL;

Dependencies

[top of page]

ASO.ASO_BI_QUOTE_HDRS_ALL does not reference any database object

ASO.ASO_BI_QUOTE_HDRS_ALL is referenced by following:

APPS: ASO_BI_QOT_DISCB_MV; ASO_BI_QOT_L1_MV; ASO_BI_QUOTE_HDRS_ALL; ASO_BI_TOP_QOTB_MV