[Home] [Help]
View: BIL_FCTV_QUOTES
Product: | BIL - Sales Intelligence |
Description: | Quantatative measures related to sales quotes |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AQH.QUOTE_HEADER_ID
, AQL.QUOTE_LINE_ID
, AQH.QUOTE_NUMBER
, AQH.PARTY_ID
, JRS.RESOURCE_ID
, NULL
, AQH.SALES_CHANNEL_CODE
, AQL.INVENTORY_ITEM_ID
, NULL
, AQH.ORDER_ID
, AQH.CREATION_DATE
, AQH.QUOTE_STATUS_ID
FROM ASO_QUOTE_HEADERS AQH
, ASO_QUOTE_LINES AQL
, JTF_RS_SALESREPS JRS
WHERE AQL.QUOTE_HEADER_ID = AQH.QUOTE_HEADER_ID
AND JRS.PERSON_ID = AQH.EMPLOYEE_PERSON_ID WITH READ ONLY
Columns
Name |
QUOTE_HEADER_ID |
QUOTE_LINE_ID |
QUOTE_NUMBER |
CUSTOMER_FK |
SALESREP_FK |
SALES_GROUP_ID |
CHANNEL_FK |
INVENTORY_ITEM_FK |
ORG_FK |
ORDER_ID |
CREATION_DATE |
QUOTE_STATUS_ID |