[Home] [Help]
View: AS_OPPORTUNITY_LINE_TOTALS_V
Product: | AS - Sales Foundation |
Description: | Sales opportunity lines total view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT LL.LEAD_ID
, SC.PERSON_ID
, SC.PARTNER_CUSTOMER_ID
, SC.PARTNER_ADDRESS_ID
, SUM(DECODE(SC.REVENUE_PERCENT
, ''
, NVL(SC.REVENUE_AMOUNT
, 0)
, ( (SC.REVENUE_PERCENT * 1.00) / 100) * LL.TOTAL_AMOUNT))
, SUM(DECODE(SC.QUOTA_CREDIT_PERCENT
, ''
, NVL(SC.QUOTA_CREDIT_AMOUNT
, 0)
, ( (SC.QUOTA_CREDIT_PERCENT * 1.00) / 100) *LL.TOTAL_AMOUNT) )
FROM AS_SALES_CREDITS SC
, AS_OPPORTUNITY_LINES LL
WHERE SC.LEAD_LINE_ID = LL.LEAD_LINE_ID GROUP BY LL.LEAD_ID
, SC.PERSON_ID
, SC.PARTNER_CUSTOMER_ID
, SC.PARTNER_ADDRESS_ID
Columns
Name |
LEAD_ID |
PERSON_ID |
PARTNER_CUSTOMER_ID |
PARTNER_ADDRESS_ID |
REVENUE_TOTAL |
QUOTA_CREDIT_TOTAL |