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;

Dependencies

[top of page]

APPS.ASO_AK_QUOTE_HEADER_V references the following:

SchemaAPPS
SynonymASO_PAYMENTS
SynonymASO_QUOTE_HEADERS
SynonymASO_SHIPMENTS
APPS.ASO_AK_QUOTE_HEADER_V is referenced by following:

SchemaAPPS
Package BodyASO_DEFAULTING_INT - show dependent code
PL/SQL PackageASO_DEFAULTING_UTIL - show dependent code
Package BodyASO_DEFAULTING_UTIL - show dependent code
PL/SQL PackageASO_QUOTE_HEADER_DEF_HDLR - show dependent code
PL/SQL PackageASO_QUOTE_HEADER_DEP_HDLR - show dependent code
PL/SQL PackageOE_QUOTE_HEADER_SECURITY - show dependent code
Package BodyQOT_DEFAULT_PVT - show dependent code