VIEW: APPS.AST_SALESOPP_UWQ_REF_SUB_V

Source

View Text - Preformatted

SELECT v1.resource_id, opp.lead_id, opp.last_update_date, opp.org_id, opp.decision_date, opp.status, opp.last_updated_by from as_leads_all opp, ( 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 ) V1 where opp.lead_id = v1.lead_id

View Text - HTML Formatted

SELECT V1.RESOURCE_ID
, OPP.LEAD_ID
, OPP.LAST_UPDATE_DATE
, OPP.ORG_ID
, OPP.DECISION_DATE
, OPP.STATUS
, OPP.LAST_UPDATED_BY
FROM AS_LEADS_ALL OPP
, ( 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 ) V1
WHERE OPP.LEAD_ID = V1.LEAD_ID