Product: | BIL - Sales Intelligence |
---|---|
Description: | Quantitative measures related to sales opportunities |
Implementation/DBA Data: | Not implemented in this database |
SELECT ASCD.LEAD_ID
, ASCD.LEAD_NUMBER
, ASCD.LEAD_LINE_ID
, ASCD.SALES_CREDIT_ID
, NULL
, ASCD.ORGANIZATION_ID
, ASCD.SALESFORCE_ID
, ASCD.SALES_GROUP_ID
, ASCD.CUSTOMER_ID
, ASCD.CHANNEL_CODE
, ASCD.INTEREST_TYPE_ID
, ASCD.PRIMARY_INTEREST_CODE_ID
, ASCD.SECONDARY_INTEREST_CODE_ID
, ASCD.ITEM_ID
, ASCD.SALES_STAGE_ID
, ASCD.STATUS_CODE
, ASCD.C1_CURRENCY_CODE
, ASCD.CREATION_DATE
, ASCD.DECISION_DATE
, ASCD.WIN_PROBABILITY
, ASCD.OPP_DESCRIPTION
, ASCD.CREDIT_TYPE_ID
, OSCT.QUOTA_FLAG
, ASCD.C1_SALES_CREDIT_AMOUNT
, NULL
, ASCD.C1_SALES_CREDIT_AMOUNT
, NULL
, NULL
, ASCD.QUANTITY
, ASCD.UOM_CODE
, ASCD.UOM_DESCRIPTION
, NULL
, ASCD.LEAD_SOURCE_CODE
, ASCD.SALES_REP_NAME
, ASCD.CUSTOMER_NAME
FROM AS_SALES_CREDITS_DENORM ASCD
, OE_SALES_CREDIT_TYPES OSCT
WHERE ASCD.OPP_DELETED_FLAG = 'N'
AND ASCD.CREDIT_TYPE_ID = OSCT.SALES_CREDIT_TYPE_ID WITH READ ONLY