View: AST_SALESOPP_UWQ_REF_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_SALESOPP_UWQ_REF_V

View Text

SELECT /*+ NO_MERGE */ DISTINCT SCD.LEAD_ID
, ACC.SALESFORCE_ID RESOURCE_ID
FROM AS_ACCESSES_ALL ACC
, AS_SALES_CREDITS SCD
WHERE ACC.OPEN_FLAG = 'Y'
AND ACC.SALESFORCE_ID = SCD.SALESFORCE_ID
AND SCD.LEAD_ID = ACC.LEAD_ID

Columns