[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 |