VIEW: APPS.AST_PLIST_REF_OPP_UWQ_V

Source

View Text - Preformatted

SELECT DISTINCT alH.owner_user_id resource_id, alh.list_name, alh.list_header_id, alh.list_source_type, alh.list_type, alh.list_source, alh.enabled_flag, ale.list_entry_id, ale.creation_date, ale.last_update_date, ale.marked_as_duplicate_flag, ale.part_of_control_group_flag, ale.col250 customer_id, ale.lead_id, opp.org_id FROM ams_list_headers_all alh, ams_list_entries ale, as_leads_all opp WHERE alh.list_header_id = ale.list_header_id AND alh.list_header_id +0 = ale.list_header_id AND opp.lead_id = ale.lead_id AND ale.outcome_id is null

View Text - HTML Formatted

SELECT DISTINCT ALH.OWNER_USER_ID RESOURCE_ID
, ALH.LIST_NAME
, ALH.LIST_HEADER_ID
, ALH.LIST_SOURCE_TYPE
, ALH.LIST_TYPE
, ALH.LIST_SOURCE
, ALH.ENABLED_FLAG
, ALE.LIST_ENTRY_ID
, ALE.CREATION_DATE
, ALE.LAST_UPDATE_DATE
, ALE.MARKED_AS_DUPLICATE_FLAG
, ALE.PART_OF_CONTROL_GROUP_FLAG
, ALE.COL250 CUSTOMER_ID
, ALE.LEAD_ID
, OPP.ORG_ID
FROM AMS_LIST_HEADERS_ALL ALH
, AMS_LIST_ENTRIES ALE
, AS_LEADS_ALL OPP
WHERE ALH.LIST_HEADER_ID = ALE.LIST_HEADER_ID
AND ALH.LIST_HEADER_ID +0 = ALE.LIST_HEADER_ID
AND OPP.LEAD_ID = ALE.LEAD_ID
AND ALE.OUTCOME_ID IS NULL