Product: | AS - Sales Foundation |
---|---|
Description: | Sales opportunity summary view |
Implementation/DBA Data: | Not implemented in this database |
SELECT LEAD.LEAD_ID
, LEAD.CREATION_DATE
, LEAD.LEAD_NUMBER
, LEAD.STATUS
, LOOK1.MEANING
, LEAD.CUSTOMER_ID
, LEAD.ADDRESS_ID
, LEAD.SALES_STAGE_ID
, STAGE.NAME
, LEAD.TOTAL_AMOUNT
, LEAD.DESCRIPTION
, LEAD.RANK
, LOOK2.MEANING
, LEAD.ATTRIBUTE_CATEGORY
, LEAD.ATTRIBUTE1
, LEAD.ATTRIBUTE2
, LEAD.ATTRIBUTE3
, LEAD.ATTRIBUTE4
, LEAD.ATTRIBUTE5
, LEAD.ATTRIBUTE6
, LEAD.ATTRIBUTE7
, LEAD.ATTRIBUTE8
, LEAD.ATTRIBUTE9
, LEAD.ATTRIBUTE10
, LEAD.ATTRIBUTE11
, LEAD.ATTRIBUTE12
, LEAD.ATTRIBUTE13
, LEAD.ATTRIBUTE14
, LEAD.ATTRIBUTE15
FROM AS_OPPORTUNITIES LEAD
, AS_SALES_STAGES_VL STAGE
, AS_LOOKUPS LOOK1
, AS_LOOKUPS LOOK2
WHERE LEAD.SALES_STAGE_ID = STAGE.SALES_STAGE_ID(+)
AND LEAD.STATUS = LOOK1.LOOKUP_CODE
AND LOOK1.LOOKUP_TYPE = 'LEAD_STATUS'
AND LEAD.RANK = LOOK2.LOOKUP_CODE(+)
AND LOOK2.LOOKUP_TYPE(+) = 'RANK'