[Home] [Help]
View: BIC_SALES_QUOTES_SUMMARY_V
Product: | BIC - Customer Intelligence (obsolete) |
Description: | Sales quotes summary information |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT QU.CUSTOMER_ID
, QU.ORG_ID
, QU.QUOTE_NAME
, QU.QUOTE_NUMBER
, QU.QUOTE_STATUS
, QU.DESCRIPTION
, QU.TOTAL_QUOTE_PRICE
, QU.QUOTE_START_DATE
, QU.QUOTE_END_DATE
, QU.APPROVAL_FLAG
, QU.APPROVAL_DATE
FROM AS_QUOTES_ALL QU WITH READ ONLY
Columns
Name |
CUSTOMER_ID |
ORG_ID |
QUOTE_NAME |
QUOTE_NUMBER |
QUOTE_STATUS |
DESCRIPTION |
TOTAL_QUOTE_PRICE |
QUOTE_START_DATE |
QUOTE_END_DATE |
APPROVAL_FLAG |
APPROVAL_DATE |