VIEW: APPS.AST_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_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'

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_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'