View: AST_SALES_LEAD_UWQ_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_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_INDIVIDUAL'
, 'PARTNER'
, 'RS_PARTNER'
, NULL)
, LEAD.LEAD_NUMBER
, LEAD.PARENT_PROJECT PROJECT_NAME
, LEAD.CHANNEL_CODE
, LEAD.DECISION_TIMEFRAME_CODE TIMEFRAME
, LEAD.BUDGET_STATUS_CODE
, LEAD.CREATION_DATE
, LEAD.LAST_UPDATE_DATE
, LEAD.LAST_UPDATED_BY LAST_UPDATE_BY
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
AND STB.OPP_OPEN_STATUS_FLAG = 'Y'

Columns