DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.ASO_OA_QUOTE_HEADERS_ALL_V

Object Details
Object Name: ASO_OA_QUOTE_HEADERS_ALL_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
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
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
HEADER_PAYNOW_CHARGES NUMBER

Header Paynow Charges
QUOTE_DISCRIMINATOR CHAR (1)
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
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      HEADER_PAYNOW_CHARGES
,      QUOTE_DISCRIMINATOR
FROM APPS.ASO_OA_QUOTE_HEADERS_ALL_V;

Dependencies

[top of page]

APPS.ASO_OA_QUOTE_HEADERS_ALL_V references the following:

SchemaAPPS
SynonymASO_QUOTE_HEADERS_ALL

APPS.ASO_OA_QUOTE_HEADERS_ALL_V is not referenced by any database object