[Home] [Help]
View: AS_QUOTE_PRINT_V
Product: | AS - Sales Foundation |
Description: | Quotes for printing view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AQ.ROWID ROW_ID
, AQ.CUSTOMER_ID
, AQ.QUOTE_ID
, AQ.QUOTE_NAME
, AQ.QUOTE_NUMBER
, AQ.QUOTE_VERSION
, AL.MEANING
, AQ.QUOTE_END_DATE
, LEAD.LEAD_NUMBER
, AQ.TOTAL_QUOTE_PRICE
FROM AS_QUOTES AQ
, AS_LOOKUPS AL
, AS_LEADS LEAD
WHERE AL.LOOKUP_TYPE (+) = 'QUOTE_STATUS'
AND AL.LOOKUP_CODE (+) = AQ.QUOTE_STATUS
AND LEAD.LEAD_ID = AQ.LEAD_ID
Columns
Name |
ROW_ID |
CUSTOMER_ID |
QUOTE_ID |
QUOTE_NAME |
QUOTE_NUMBER |
QUOTE_VERSION |
MEANING |
QUOTE_END_DATE |
LEAD_NUMBER |
TOTAL_QUOTE_PRICE |