View: AST_PLIST_REF_OPP_UWQ_V

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

View Text

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

Columns