VIEW: APPS.AST_MYTEAM_SALESLEAD_UWQ_S_V

Source

View Text - Preformatted

SELECT ACC.SALESFORCE_ID RESOURCE_ID , ACC.SALES_LEAD_ID SALES_LEAD_ID , ACC.object_creation_date CREATION_DATE ,LEAD.STATUS_CODE STATUS_CODE FROM AS_ACCESSES_ALL ACC ,AS_SALES_LEADS LEAD WHERE ACC.SALES_LEAD_ID IS NOT NULL AND ACC.OPEN_FLAG = 'Y' AND ACC.SALES_LEAD_ID = LEAD.SALES_LEAD_ID

View Text - HTML Formatted

SELECT ACC.SALESFORCE_ID RESOURCE_ID
, ACC.SALES_LEAD_ID SALES_LEAD_ID
, ACC.OBJECT_CREATION_DATE CREATION_DATE
, LEAD.STATUS_CODE STATUS_CODE
FROM AS_ACCESSES_ALL ACC
, AS_SALES_LEADS LEAD
WHERE ACC.SALES_LEAD_ID IS NOT NULL
AND ACC.OPEN_FLAG = 'Y'
AND ACC.SALES_LEAD_ID = LEAD.SALES_LEAD_ID