View: AS_SALES_LEAD_UWQ_V

Product:	AS - Sales Foundation
Description:	This view is used for Universal Work Queue
Implementation/DBA Data:	APPS.AS_SALES_LEAD_UWQ_V

View Text

SELECT LEAD.SALES_LEAD_ID
, LEAD.DESCRIPTION
, LEAD.CUSTOMER_ID
, PARTY.PARTY_NAME
, LEAD.STATUS_CODE
, STT.MEANING
, LEAD.ASSIGN_TO_SALESFORCE_ID
, LEAD.ASSIGN_SALES_GROUP_ID
, LEAD.BUDGET_AMOUNT
, LEAD.CURRENCY_CODE
, 'LEAD'
, DECODE(RES.CATEGORY
, 'EMPLOYEE'
, 'RS_EMPLOYEE'
, 'PARTNER'
, 'RS_PARTNER'
, NULL)
FROM AS_SALES_LEADS LEAD
, JTF_RS_RESOURCE_EXTNS RES
, HZ_PARTIES PARTY
, AS_STATUSES_B STB
, AS_STATUSES_TL STT
WHERE LEAD.STATUS_CODE = STB.STATUS_CODE
AND STT.STATUS_CODE = STB.STATUS_CODE
AND STT.LANGUAGE = USERENV('LANG')
AND LEAD.CUSTOMER_ID = PARTY.PARTY_ID
AND LEAD.ASSIGN_TO_SALESFORCE_ID = RES.RESOURCE_ID

Columns