Product: | AMS - Marketing |
---|---|
Description: | This view returns information on associations of resources to marketing objects like Events, Campaigns. |
Implementation/DBA Data: | APPS.AMS_ACT_RESOURCES_V |
SELECT AAR.ACTIVITY_RESOURCE_ID
, AAR.OBJECT_VERSION_NUMBER
, AAR.ACT_RESOURCE_USED_BY_ID
, AAR.ARC_ACT_RESOURCE_USED_BY
, AAR.RESOURCE_ID
, HZ.PARTY_NAME
, AAR.ROLE_RELATE_ID
, AAR.ROLE_CD
, LK.MEANING
, AAR.USER_STATUS_ID
, AUS.NAME
, AAR.SYSTEM_STATUS_CODE
, AAR.START_DATE_TIME
, AAR.END_DATE_TIME
, AAR.DESCRIPTION
FROM AMS_ACT_RESOURCES AAR
, AMS_USER_STATUSES_V AUS
, HZ_PARTIES HZ
, AMS_LOOKUPS LK
WHERE AAR.USER_STATUS_ID=AUS.USER_STATUS_ID
AND AAR.RESOURCE_ID=HZ.PARTY_ID
AND AAR.ROLE_CD = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'AMS_EVENT_ROLE'