View: BIL_DIMV_OPTY

Product:	BIL - Sales Intelligence
Description:	Opportunities View for ID, Name
Implementation/DBA Data:	APPS.BIL_DIMV_OPTY

View Text

SELECT ALA.LEAD_ID
, ALA.LEAD_NUMBER
, ALA.STATUS
, NVL(ALA.DESCRIPTION
, ALA.LEAD_NUMBER)
FROM AS_LEADS_ALL ALA UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) LEAD_ID
, FL.MEANING LEAD_NUMBER
, NULL
, FL.DESCRIPTION DESCRIPTION
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns