VIEW: APPS.AS_SALES_LEAD_UWQ_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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