VIEW: APPS.AMS_CAMPAIGN_TEAM_V

Source

View Text - Preformatted

SELECT a.activity_access_id, b.full_name , nvl(a.admin_flag,'N'), a.active_from_date, b.phone, b.email, a.object_version_number, a.act_access_to_object_id, a.arc_act_access_to_object, a.user_or_role_id, a.arc_user_or_role_type, a.creation_date, d. meaning, a.delete_flag, a.owner_flag from ams_act_access a, ams_jtf_rs_emp_v b , ams_lookups d WHERE a.user_or_role_id = b.resource_id and a.arc_user_or_role_type = 'USER' and d.lookup_type = 'AMS_ACCESS_TYPE' and d.lookup_code = a.arc_user_or_role_type union all SELECT a.activity_access_id, c.group_name full_name, nvl(a.admin_flag,'N'), a.active_from_date, '', c.email_address, a.object_version_number, a.act_access_to_object_id, a.arc_act_access_to_object, a.user_or_role_id, a.arc_user_or_role_type, a.creation_date, d.meaning, a.delete_flag, a.owner_flag from ams_act_access a, jtf_rs_groups_vl c , ams_lookups d WHERE a.arc_user_or_role_type = 'GROUP' and a.user_or_role_id = c.group_id and d.lookup_type = 'AMS_ACCESS_TYPE' and d.lookup_code = a.arc_user_or_role_type

View Text - HTML Formatted

SELECT A.ACTIVITY_ACCESS_ID
, B.FULL_NAME
, NVL(A.ADMIN_FLAG
, 'N')
, A.ACTIVE_FROM_DATE
, B.PHONE
, B.EMAIL
, A.OBJECT_VERSION_NUMBER
, A.ACT_ACCESS_TO_OBJECT_ID
, A.ARC_ACT_ACCESS_TO_OBJECT
, A.USER_OR_ROLE_ID
, A.ARC_USER_OR_ROLE_TYPE
, A.CREATION_DATE
, D. MEANING
, A.DELETE_FLAG
, A.OWNER_FLAG
FROM AMS_ACT_ACCESS A
, AMS_JTF_RS_EMP_V B
, AMS_LOOKUPS D
WHERE A.USER_OR_ROLE_ID = B.RESOURCE_ID
AND A.ARC_USER_OR_ROLE_TYPE = 'USER'
AND D.LOOKUP_TYPE = 'AMS_ACCESS_TYPE'
AND D.LOOKUP_CODE = A.ARC_USER_OR_ROLE_TYPE UNION ALL SELECT A.ACTIVITY_ACCESS_ID
, C.GROUP_NAME FULL_NAME
, NVL(A.ADMIN_FLAG
, 'N')
, A.ACTIVE_FROM_DATE
, ''
, C.EMAIL_ADDRESS
, A.OBJECT_VERSION_NUMBER
, A.ACT_ACCESS_TO_OBJECT_ID
, A.ARC_ACT_ACCESS_TO_OBJECT
, A.USER_OR_ROLE_ID
, A.ARC_USER_OR_ROLE_TYPE
, A.CREATION_DATE
, D.MEANING
, A.DELETE_FLAG
, A.OWNER_FLAG
FROM AMS_ACT_ACCESS A
, JTF_RS_GROUPS_VL C
, AMS_LOOKUPS D
WHERE A.ARC_USER_OR_ROLE_TYPE = 'GROUP'
AND A.USER_OR_ROLE_ID = C.GROUP_ID
AND D.LOOKUP_TYPE = 'AMS_ACCESS_TYPE'
AND D.LOOKUP_CODE = A.ARC_USER_OR_ROLE_TYPE