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_QUOTE_HEADERS_ALL

Object Details

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

This table holds header level Order Capture quotation data.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ASO_QUOTE_HEADERS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUOTE_NUMBER QUOTE_VERSION
ASO_QUOTE_HEADERS_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUOTE_HEADER_ID
ASO_QUOTE_HDRS_ALL_N998	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("QUOTE_NAME")
ASO_QUOTE_HEADERS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID
ASO_QUOTE_HEADERS_ALL_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PHONE_ID
ASO_QUOTE_HEADERS_ALL_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID
ASO_QUOTE_HEADERS_ALL_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
ASO_QUOTE_HEADERS_ALL_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MAX_VERSION_FLAG QUOTE_NUMBER
ASO_QUOTE_HEADERS_ALL_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
ASO_QUOTE_HEADERS_ALL_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MARKETING_SOURCE_CODE_ID
ASO_QUOTE_HEADERS_ALL_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_PARTY_ID
ASO_QUOTE_HEADERS_ALL_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUOTE_EXPIRATION_DATE
ASO_QUOTE_HEADERS_ALL_N18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUOTE_TYPE
ASO_QUOTE_HEADERS_ALL_N19	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_TO_CUST_ACCOUNT_ID
ASO_QUOTE_HEADERS_ALL_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_CUSTOMER_CUST_ACCOUNT_ID
ASO_QUOTE_HEADERS_ALL_N21	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_CUSTOMER_PARTY_SITE_ID
ASO_QUOTE_HEADERS_ALL_N22	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_CUSTOMER_PARTY_ID
ASO_QUOTE_HEADERS_ALL_N23	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_CUSTOMER_CUST_PARTY_ID
ASO_QUOTE_HEADERS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ACCOUNT_ID
ASO_QUOTE_HEADERS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_ID
ASO_QUOTE_HEADERS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICE_LIST_ID
ASO_QUOTE_HEADERS_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUOTE_STATUS_ID
ASO_QUOTE_HEADERS_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_TYPE_ID
ASO_QUOTE_HEADERS_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
ASO_QUOTE_HEADERS_ALL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUOTE_SOURCE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
QUOTE_HEADER_ID	NUMBER		Yes	Unique identifier for quote
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_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ORG_ID	NUMBER			Organization identifier
QUOTE_NAME	VARCHAR2	(240)		Quote name
QUOTE_NUMBER	NUMBER		Yes	Quote number. Quote number and version uniquely identifies a quote
QUOTE_VERSION	NUMBER		Yes	Quote version. Quote number and quote version uniquely identifies a quote
QUOTE_STATUS_ID	NUMBER		Yes	Quote status
QUOTE_SOURCE_CODE	VARCHAR2	(240)		Source of the quote
QUOTE_EXPIRATION_DATE	DATE			Expiration date of the quote
PRICE_FROZEN_DATE	DATE			Price Frozen Date
QUOTE_PASSWORD	VARCHAR2	(240)		Quote Password
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(240)		Original system reference
PARTY_ID	NUMBER			Party Id of the sold-to party. Can be of type person, organization, or party relationship.
CUST_ACCOUNT_ID	NUMBER			Customer Account Id of the sold-to party, if sold-to party is of type person or organization. If sold-to party happens to be of type relationship, the customer accounr id will be that of the object of the relationship.
ORG_CONTACT_ID	NUMBER			Contact identifier
PHONE_ID	NUMBER			Phone Identifier
INVOICE_TO_PARTY_SITE_ID	NUMBER			Bill to site identifier
INVOICE_TO_PARTY_ID	NUMBER			Bill to contact identifier
ORIG_MKTG_SOURCE_CODE_ID	NUMBER			Campaign from which this quote originates
MARKETING_SOURCE_CODE_ID	NUMBER			Campaign that is applied to this quote
ORDER_TYPE_ID	NUMBER			Order type identifier, determines the type of order to be created
QUOTE_CATEGORY_CODE	VARCHAR2	(240)		QUOTE CATEGORY CODE
ORDERED_DATE	DATE			Date which the quote is turned into an order
ACCOUNTING_RULE_ID	NUMBER			Accounting rule identifier
INVOICING_RULE_ID	NUMBER			Invoicing rule identifier
EMPLOYEE_PERSON_ID	NUMBER			Employee person identifier
PRICE_LIST_ID	NUMBER			Price list identifier
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
TOTAL_LIST_PRICE	NUMBER			Total list price
TOTAL_ADJUSTED_AMOUNT	NUMBER			Total amount after price adjustments
TOTAL_ADJUSTED_PERCENT	NUMBER			Price adjustment percent
TOTAL_TAX	NUMBER			Total tax amount
TOTAL_SHIPPING_CHARGE	NUMBER			Total shipping charge
SURCHARGE	NUMBER			Surcharge
TOTAL_QUOTE_PRICE	NUMBER			Total price quoted
PAYMENT_AMOUNT	NUMBER			Payment amount
EXCHANGE_RATE	NUMBER			Exchange rate
EXCHANGE_TYPE_CODE	VARCHAR2	(15)		Exchange type code
EXCHANGE_RATE_DATE	DATE			Date of exchange rate
CONTRACT_ID	NUMBER			Contract identifier
SALES_CHANNEL_CODE	VARCHAR2	(30)		Sales Channel Code
ORDER_ID	NUMBER			Order Header Idenrtifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
OBJECT_VERSION_NUMBER	NUMBER			Used in hosted environments
INVOICE_TO_CUST_ACCOUNT_ID	NUMBER			Bill to customer account identifier
RESOURCE_ID	NUMBER			RESOURCE Identifier from jtf_rs_srp_vl
CONTRACT_TEMPLATE_ID	NUMBER			Template identifier
CONTRACT_TEMPLATE_MAJOR_VER	NUMBER			TEMPLATE MAJOR VERSION
CONTRACT_REQUESTER_ID	NUMBER			CONTRACT REQUESTER ID
CONTRACT_APPROVAL_LEVEL	VARCHAR2	(30)		CONTRACT APPROVAL LEVEL
PUBLISH_FLAG	VARCHAR2	(1)		PUBLISH FLAG
RESOURCE_GRP_ID	NUMBER			RESOURCE GRP ID
SOLD_TO_PARTY_SITE_ID	NUMBER			SOLD TO PARTY SITE ID
DISPLAY_ARITHMETIC_OPERATOR	VARCHAR2	(30)		DISPLAY ARITHMETIC OPERATOR
MAX_VERSION_FLAG	VARCHAR2	(1)		MAX VERSION FLAG
QUOTE_DESCRIPTION	VARCHAR2	(240)		Description of Quote
QUOTE_TYPE	VARCHAR2	(1)		Flag to Indicate the Quote Template
MINISITE_ID	NUMBER			Minisite ID for iStore
CUST_PARTY_ID	NUMBER			CUSTOMER PARTY IDENTIFIER
INVOICE_TO_CUST_PARTY_ID	NUMBER			INVOICE TO CUST PARTY IDENTIFIER
PRICING_STATUS_INDICATOR	VARCHAR2	(1)		This flag indicates the quote price is complete or incomplete
TAX_STATUS_INDICATOR	VARCHAR2	(1)		This flag indicates the quote tax is complete or incomplete
PRICE_UPDATED_DATE	DATE			Indicates when Quote price was last updated from UI
TAX_UPDATED_DATE	DATE			Indicates when Quote Tax was last updated from UI
RECALCULATE_FLAG	VARCHAR2	(1)		Flag to recalculate the header level price adjustment
PRICE_REQUEST_ID	NUMBER			Stores the request_id of the Concurrent Price Batch request.
CREDIT_UPDATE_DATE	DATE			Credit Update Date for OIC Integration
CUSTOMER_NAME_AND_TITLE	VARCHAR2	(240)		Customer Name and Title Who Signed the Contract
CUSTOMER_SIGNATURE_DATE	DATE			Date when contract is Signed by Customer
SUPPLIER_NAME_AND_TITLE	VARCHAR2	(240)		Supplier Name and Title Who Signed the Contract
SUPPLIER_SIGNATURE_DATE	DATE			Date when contract is Signed by Supplier
END_CUSTOMER_PARTY_ID	NUMBER			End Customer Party Identifier
END_CUSTOMER_PARTY_SITE_ID	NUMBER			End Customer Party Site ID Identifier
END_CUSTOMER_CUST_ACCOUNT_ID	NUMBER			End Customer cust account Id Identifier
END_CUSTOMER_CUST_PARTY_ID	NUMBER			End Customer cust party id identifier
AUTOMATIC_PRICE_FLAG	VARCHAR2	(1)		This flag is used to denote if the quote is in automatic or manual mode of pricing
AUTOMATIC_TAX_FLAG	VARCHAR2	(1)		This flag denotes if the calculation of tax is in automatic or manual mode
ASSISTANCE_REQUESTED	VARCHAR2	(1)		This flag denotes if there is a sales rep assistance requested for the quote or not.
ASSISTANCE_REASON_CODE	VARCHAR2	(30)		Stores the reason for sales rep assistance
HEADER_PAYNOW_CHARGES	NUMBER			Header Paynow Charges
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment

Query Text

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


SELECT QUOTE_HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      QUOTE_NAME
,      QUOTE_NUMBER
,      QUOTE_VERSION
,      QUOTE_STATUS_ID
,      QUOTE_SOURCE_CODE
,      QUOTE_EXPIRATION_DATE
,      PRICE_FROZEN_DATE
,      QUOTE_PASSWORD
,      ORIGINAL_SYSTEM_REFERENCE
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      ORG_CONTACT_ID
,      PHONE_ID
,      INVOICE_TO_PARTY_SITE_ID
,      INVOICE_TO_PARTY_ID
,      ORIG_MKTG_SOURCE_CODE_ID
,      MARKETING_SOURCE_CODE_ID
,      ORDER_TYPE_ID
,      QUOTE_CATEGORY_CODE
,      ORDERED_DATE
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      EMPLOYEE_PERSON_ID
,      PRICE_LIST_ID
,      CURRENCY_CODE
,      TOTAL_LIST_PRICE
,      TOTAL_ADJUSTED_AMOUNT
,      TOTAL_ADJUSTED_PERCENT
,      TOTAL_TAX
,      TOTAL_SHIPPING_CHARGE
,      SURCHARGE
,      TOTAL_QUOTE_PRICE
,      PAYMENT_AMOUNT
,      EXCHANGE_RATE
,      EXCHANGE_TYPE_CODE
,      EXCHANGE_RATE_DATE
,      CONTRACT_ID
,      SALES_CHANNEL_CODE
,      ORDER_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      INVOICE_TO_CUST_ACCOUNT_ID
,      RESOURCE_ID
,      CONTRACT_TEMPLATE_ID
,      CONTRACT_TEMPLATE_MAJOR_VER
,      CONTRACT_REQUESTER_ID
,      CONTRACT_APPROVAL_LEVEL
,      PUBLISH_FLAG
,      RESOURCE_GRP_ID
,      SOLD_TO_PARTY_SITE_ID
,      DISPLAY_ARITHMETIC_OPERATOR
,      MAX_VERSION_FLAG
,      QUOTE_DESCRIPTION
,      QUOTE_TYPE
,      MINISITE_ID
,      CUST_PARTY_ID
,      INVOICE_TO_CUST_PARTY_ID
,      PRICING_STATUS_INDICATOR
,      TAX_STATUS_INDICATOR
,      PRICE_UPDATED_DATE
,      TAX_UPDATED_DATE
,      RECALCULATE_FLAG
,      PRICE_REQUEST_ID
,      CREDIT_UPDATE_DATE
,      CUSTOMER_NAME_AND_TITLE
,      CUSTOMER_SIGNATURE_DATE
,      SUPPLIER_NAME_AND_TITLE
,      SUPPLIER_SIGNATURE_DATE
,      END_CUSTOMER_PARTY_ID
,      END_CUSTOMER_PARTY_SITE_ID
,      END_CUSTOMER_CUST_ACCOUNT_ID
,      END_CUSTOMER_CUST_PARTY_ID
,      AUTOMATIC_PRICE_FLAG
,      AUTOMATIC_TAX_FLAG
,      ASSISTANCE_REQUESTED
,      ASSISTANCE_REASON_CODE
,      HEADER_PAYNOW_CHARGES
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM ASO.ASO_QUOTE_HEADERS_ALL;

Dependencies

[top of page]

ASO.ASO_QUOTE_HEADERS_ALL does not reference any database object

ASO.ASO_QUOTE_HEADERS_ALL is referenced by following:

ASO: ASO_QUOTE_HEADERS_ALL#