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]

VIEW: APPS.ASO_AK_QUOTE_HEADER_V

Object Details

Object Name:	ASO_AK_QUOTE_HEADER_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
Q_QUOTE_HEADER_ID	NUMBER		Yes	Unique identifier for quote
Q_QUOTE_NAME	VARCHAR2	(240)		Quote name
Q_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.
Q_QUOTE_EXPIRATION_DATE	DATE			Expiration date of the quote
Q_QUOTE_STATUS_ID	NUMBER		Yes	Quote status
Q_ORG_ID	NUMBER			Organization identifier
Q_CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
Q_ORDER_TYPE_ID	NUMBER			Order type identifier, determines the type of order to be created
Q_CONTRACT_ID	NUMBER			Contract identifier
Q_PRICE_LIST_ID	NUMBER			Price list identifier
Q_CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
Q_PRICE_FROZEN_DATE	DATE			Price Frozen Date
Q_CONTRACT_TEMPLATE_ID	NUMBER			Template identifier
Q_RESOURCE_ID	NUMBER			RESOURCE Identifier from jtf_rs_srp_vl
Q_RESOURCE_GRP_ID	NUMBER			RESOURCE GRP ID
Q_SALES_CHANNEL_CODE	VARCHAR2	(30)		Sales Channel Code
Q_MKTING_SRC_CODE_ID	NUMBER			Campaign that is applied to this quote
Q_PARTY_ID	NUMBER			Party Id of the sold-to party. Can be of type person, organization, or party relationship.
Q_PHONE_ID	NUMBER			Phone Identifier
Q_SOLD_TO_PARTY_SITE_ID	NUMBER			SOLD TO PARTY SITE ID
Q_INV_TO_CUST_PTY_ID	NUMBER			INVOICE TO CUST PARTY IDENTIFIER
Q_INV_TO_CUST_ACCT_ID	NUMBER			Bill to customer account identifier
Q_INV_TO_PTY_SITE_ID	NUMBER			Bill to site identifier
Q_INV_TO_PTY_ID	NUMBER			Bill to contact identifier
Q_CUST_PARTY_ID	NUMBER			CUSTOMER PARTY IDENTIFIER
Q_END_CUST_CUST_PTY_ID	NUMBER			End Customer cust party id identifier
Q_END_CUST_CUST_ACCT_ID	NUMBER			End Customer cust account Id Identifier
Q_END_CUST_PTY_SITE_ID	NUMBER			End Customer Party Site ID Identifier
Q_END_CUST_PTY_ID	NUMBER			End Customer Party Identifier
Q_AUTOMATIC_PRICE_FLAG	VARCHAR2	(1)		This flag is used to denote if the quote is in automatic or manual mode of pricing
Q_AUTOMATIC_TAX_FLAG	VARCHAR2	(1)		This flag denotes if the calculation of tax is in automatic or manual mode
Q_LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
Q_OBJECT_VERSION_NUMBER	NUMBER			Used in hosted environments
Q_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
Q_ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
Q_ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
Q_SHIP_TO_CUST_PARTY_ID	NUMBER			SHIP TO CUST PARTY IDENTIFIER
Q_SHIP_TO_CUST_ACCT_ID	NUMBER			Ship tp customer account identier
Q_SHIP_TO_PARTY_SITE_ID	NUMBER			Ship to site use identifier
Q_SHIP_TO_PARTY_ID	NUMBER			Ship to contact identifier
Q_PAYMENT_TERM_ID	NUMBER			Payment term identifier
Q_CUST_PO_NUMBER	VARCHAR2	(50)		Customer PO number
Q_CREDIT_CARD_CODE	VARCHAR2	(30)		Credit card code
Q_PAYMENT_REF_NUMBER	VARCHAR2	(240)		Stores the reference number for the selected payment_type_code. For example, if payment type is Credit Card, this column stores the credit card number.
Q_CREDIT_CARD_HLD_NAME	VARCHAR2	(80)		Name of credit card holder
Q_CREDIT_CARD_EXP_DATE	DATE			Credit card expiration date
Q_PAYMENT_TYPE_CODE	VARCHAR2	(30)		Payment type code from ASO_I_PAYMENT_TYPES_V
Q_REQUEST_DATE_TYPE	VARCHAR2	(30)		Request date type
Q_REQUEST_DATE	DATE			Need by date
Q_SHIP_METHOD_CODE	VARCHAR2	(30)		Freight Carrier and method. Foreign key to table Org_Freight
Q_SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)		SHIPMENT PRIORITY CODE
Q_FREIGHT_TERMS_CODE	VARCHAR2	(30)		Freight term. Applicable only at header level
Q_FOB_CODE	VARCHAR2	(30)		Point of ownership transfer
Q_SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)		Special shipping instructions
Q_PACKING_INSTRUCTIONS	VARCHAR2	(2000)		Special packing instructions
Q_DEMAND_CLASS_CODE	VARCHAR2	(30)		Demand Class Code
Q_APPLICATION_TYPE_CODE	VARCHAR2	(30)
Q_QUOTE_CUSTOMER_TYPE	VARCHAR2	(30)

Query Text

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


SELECT Q_QUOTE_HEADER_ID
,      Q_QUOTE_NAME
,      Q_CUST_ACCOUNT_ID
,      Q_QUOTE_EXPIRATION_DATE
,      Q_QUOTE_STATUS_ID
,      Q_ORG_ID
,      Q_CREATED_BY
,      Q_ORDER_TYPE_ID
,      Q_CONTRACT_ID
,      Q_PRICE_LIST_ID
,      Q_CURRENCY_CODE
,      Q_PRICE_FROZEN_DATE
,      Q_CONTRACT_TEMPLATE_ID
,      Q_RESOURCE_ID
,      Q_RESOURCE_GRP_ID
,      Q_SALES_CHANNEL_CODE
,      Q_MKTING_SRC_CODE_ID
,      Q_PARTY_ID
,      Q_PHONE_ID
,      Q_SOLD_TO_PARTY_SITE_ID
,      Q_INV_TO_CUST_PTY_ID
,      Q_INV_TO_CUST_ACCT_ID
,      Q_INV_TO_PTY_SITE_ID
,      Q_INV_TO_PTY_ID
,      Q_CUST_PARTY_ID
,      Q_END_CUST_CUST_PTY_ID
,      Q_END_CUST_CUST_ACCT_ID
,      Q_END_CUST_PTY_SITE_ID
,      Q_END_CUST_PTY_ID
,      Q_AUTOMATIC_PRICE_FLAG
,      Q_AUTOMATIC_TAX_FLAG
,      Q_LAST_UPDATE_DATE
,      Q_OBJECT_VERSION_NUMBER
,      Q_ATTRIBUTE_CATEGORY
,      Q_ATTRIBUTE1
,      Q_ATTRIBUTE2
,      Q_ATTRIBUTE3
,      Q_ATTRIBUTE4
,      Q_ATTRIBUTE5
,      Q_ATTRIBUTE6
,      Q_ATTRIBUTE7
,      Q_ATTRIBUTE8
,      Q_ATTRIBUTE9
,      Q_ATTRIBUTE10
,      Q_ATTRIBUTE11
,      Q_ATTRIBUTE12
,      Q_ATTRIBUTE13
,      Q_ATTRIBUTE14
,      Q_ATTRIBUTE15
,      Q_ATTRIBUTE16
,      Q_ATTRIBUTE17
,      Q_ATTRIBUTE18
,      Q_ATTRIBUTE19
,      Q_ATTRIBUTE20
,      Q_SHIP_TO_CUST_PARTY_ID
,      Q_SHIP_TO_CUST_ACCT_ID
,      Q_SHIP_TO_PARTY_SITE_ID
,      Q_SHIP_TO_PARTY_ID
,      Q_PAYMENT_TERM_ID
,      Q_CUST_PO_NUMBER
,      Q_CREDIT_CARD_CODE
,      Q_PAYMENT_REF_NUMBER
,      Q_CREDIT_CARD_HLD_NAME
,      Q_CREDIT_CARD_EXP_DATE
,      Q_PAYMENT_TYPE_CODE
,      Q_REQUEST_DATE_TYPE
,      Q_REQUEST_DATE
,      Q_SHIP_METHOD_CODE
,      Q_SHIPMENT_PRIORITY_CODE
,      Q_FREIGHT_TERMS_CODE
,      Q_FOB_CODE
,      Q_SHIPPING_INSTRUCTIONS
,      Q_PACKING_INSTRUCTIONS
,      Q_DEMAND_CLASS_CODE
,      Q_APPLICATION_TYPE_CODE
,      Q_QUOTE_CUSTOMER_TYPE
FROM APPS.ASO_AK_QUOTE_HEADER_V;