[Home] [Help]
View: ASO_SEARCH_QUOTES_V
Product: | ASO - Order Capture |
Description: | ASO_SEARCH_QUOTES_V is a view with all the columns in this view coming from Aso_Quote_Headers_V. |
Implementation/DBA Data: |
APPS.ASO_SEARCH_QUOTES_V
|
View Text
SELECT QHDR.QUOTE_HEADER_ID QUOTE_HEADER_ID
, QHDR.QUOTE_NAME QUOTE_NAME
, QHDR.ORGANIZATION_NAME COMPANY
, QHDR.ACCOUNT_NUMBER ACCOUNT
, QHDR.QUOTE_CATEGORY_CODE CATEGORY
, QHDR.PERSON_FIRST_NAME FIRST_NAME
, QHDR.PERSON_LAST_NAME LAST_NAME
, QHDR.QUOTE_NUMBER QUOTE_NUMBER
, QHDR.QUOTE_VERSION VERSION
, QHDR.QUOTE_STATUS STATUS
, QHDR.QUOTE_EXPIRATION_DATE EXP_DATE
, QHDR.TOTAL_QUOTE_PRICE QUOTE_PRICE
FROM ASO_QUOTE_HEADERS_V QHDR
Columns
Name |
QUOTE_HEADER_ID |
QUOTE_NAME |
COMPANY |
ACCOUNT |
CATEGORY |
FIRST_NAME |
LAST_NAME |
QUOTE_NUMBER |
VERSION |
STATUS |
EXP_DATE |
QUOTE_PRICE |