VIEW: APPS.AST_MYTEAM_SALESOPP_UWQ_REF_V

Source

View Text - Preformatted

SELECT distinct ACC.LEAD_ID, ACC.SALESFORCE_ID RESOURCE_ID , ACC.OPEN_FLAG FROM AS_ACCESSES_ALL ACC WHERE ACC.LEAD_ID IS NOT NULL AND ACC.OPEN_FLAG = 'Y'

View Text - HTML Formatted

SELECT DISTINCT ACC.LEAD_ID
, ACC.SALESFORCE_ID RESOURCE_ID
, ACC.OPEN_FLAG
FROM AS_ACCESSES_ALL ACC
WHERE ACC.LEAD_ID IS NOT NULL
AND ACC.OPEN_FLAG = 'Y'