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: TableASO.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: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ASO_BI_QUOTE_HDRS_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnQUOTE_NUMBER
ASO_BI_QUOTE_HDRS_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnCONVERSION_RATE
ASO_BI_QUOTE_HDRS_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnRESOURCE_GRP_ID
ColumnRESOURCE_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:

SchemaAPPS
Materialized ViewASO_BI_QOT_DISCB_MV
Materialized ViewASO_BI_QOT_L1_MV
SynonymASO_BI_QUOTE_HDRS_ALL
Materialized ViewASO_BI_TOP_QOTB_MV