Product: | BIL - Sales Intelligence (Obsolete) |
---|---|
Description: | Quantitative measures related to sales opportunities |
Implementation/DBA Data: | Not implemented in this database |
SELECT HEADER.LEAD_ID
, LINE.LEAD_LINE_ID
, HEADER.ORG_ID
, ACC.SALESFORCE_ID
, ACC.SALES_GROUP_ID
, HEADER.CUSTOMER_ID
, HEADER.ADDRESS_ID
, ATA.TERRITORY_ID
, HEADER.CHANNEL_CODE
, LINE.INTEREST_TYPE_ID
, LINE.PRIMARY_INTEREST_CODE_ID
, LINE.SECONDARY_INTEREST_CODE_ID
, LINE.INVENTORY_ITEM_ID
, HEADER.CREATION_DATE
, HEADER.DECISION_DATE
, HEADER.WIN_PROBABILITY
, HEADER.SALES_STAGE_ID
, HEADER.STATUS
, HEADER.DESCRIPTION
, HEADER.CURRENCY_CODE
, DECODE(OSCT.QUOTA_FLAG
, 'Y'
, ASCR.CREDIT_AMOUNT
, 0)
, DECODE(OSCT.QUOTA_FLAG
, 'Y'
, ASCR.CREDIT_PERCENT
, 0)
, DECODE(OSCT.QUOTA_FLAG
, 'Y'
, 0
, ASCR.CREDIT_AMOUNT)
, DECODE(OSCT.QUOTA_FLAG
, 'Y'
, 0
, ASCR.CREDIT_PERCENT)
, LINE.TOTAL_AMOUNT
, LINE.QUANTITY
, LINE.UOM_CODE
FROM AS_LEADS_ALL HEADER
, AS_LEAD_LINES_ALL LINE
, AS_ACCESSES_ALL ACC
, AS_TERRITORY_ACCESSES ATA
, AS_SALES_CREDITS ASCR
, OE_SALES_CREDIT_TYPES OSCT
WHERE (HEADER.DELETED_FLAG != 'Y' OR HEADER.DELETED_FLAG IS NULL)
AND HEADER.LEAD_ID = LINE.LEAD_ID
AND LINE.LEAD_ID = ACC.LEAD_ID
AND LINE.LEAD_ID = ASCR.LEAD_ID
AND LINE.LEAD_LINE_ID = ASCR.LEAD_LINE_ID
AND ACC.ACCESS_ID = ATA.ACCESS_ID
AND OSCT.SALES_CREDIT_TYPE_ID = ASCR.CREDIT_TYPE_ID WITH READ ONLY