Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_PLIST_REF_UWQ_V |
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
FROM AMS_LIST_HEADERS_ALL ALH
, AMS_LIST_ENTRIES ALE
WHERE ALH.LIST_HEADER_ID = ALE.LIST_HEADER_ID
AND ALH.LIST_HEADER_ID +0 = ALE.LIST_HEADER_ID
AND ALE.OUTCOME_ID IS NULL