View: AMS_P_LIST_HEADERS_V

Product:	AMS - Marketing
Description:	This public view returns the general information about marketing list.
Implementation/DBA Data:	APPS.AMS_P_LIST_HEADERS_V

View Text

SELECT AMS_UTILITY_PVT.GET_OBJECT_NAME(L.ARC_LIST_USED_BY
, L.LIST_USED_BY_ID) ACTIVITY_NAME
, LK.MEANING ACTIVITY_TYPE
, L.LIST_HEADER_ID
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_LOGIN
, L.OBJECT_VERSION_NUMBER
, L.REQUEST_ID
, L.PROGRAM_ID
, L.PROGRAM_APPLICATION_ID
, L.PROGRAM_UPDATE_DATE
, L.VIEW_APPLICATION_ID
, L.LIST_NAME
, L.LIST_USED_BY_ID
, L.ARC_LIST_USED_BY
, L.LIST_TYPE
, L.STATUS_CODE
, L.STATUS_DATE
, L.GENERATION_TYPE
, L.ROW_SELECTION_TYPE
, L.OWNER_USER_ID
, RES.FULL_NAME OWNER_NAME
, RES.EMAIL OWNER_EMAIL_ADDRESS
, RES.EMPLOYEE_NUMBER OWNER_EMPLOYEE_ID
, L.ACCESS_LEVEL
, LK2.MEANING ACCESS_LEVEL_MEANING
, L.ENABLE_LOG_FLAG
, L.ENABLE_WORD_REPLACEMENT_FLAG
, L.ENABLE_PARALLEL_DML_FLAG
, L.DEDUPE_DURING_GENERATION_FLAG
, L.GENERATE_CONTROL_GROUP_FLAG
, L.LAST_GENERATION_SUCCESS_FLAG
, L.FORECASTED_START_DATE
, L.FORECASTED_END_DATE
, L.ACTUAL_END_DATE
, L.SENT_OUT_DATE
, L.DEDUPE_START_DATE
, L.LAST_DEDUPE_DATE
, L.LAST_DEDUPED_BY_USER_ID
, L.WORKFLOW_ITEM_KEY
, L.NO_OF_ROWS_DUPLICATES
, L.NO_OF_ROWS_MIN_REQUESTED
, L.NO_OF_ROWS_MAX_REQUESTED
, L.NO_OF_ROWS_IN_LIST
, L.NO_OF_ROWS_IN_CTRL_GROUP
, L.NO_OF_ROWS_ACTIVE
, L.ORG_ID
, L.TIMEZONE_ID
, L.USER_ENTERED_START_TIME
, L.MAIN_GEN_START_TIME
, L.MAIN_GEN_END_TIME
, L.MAIN_RANDOM_NTH_ROW_SELECTION
, L.MAIN_RANDOM_PCT_ROW_SELECTION
, L.CTRL_RANDOM_NTH_ROW_SELECTION
, L.CTRL_RANDOM_PCT_ROW_SELECTION
, L.RESULT_TEXT
, L.KEYWORDS
, L.DESCRIPTION
, L.ATTRIBUTE_CATEGORY
, L.ATTRIBUTE1
, L.ATTRIBUTE2
, L.ATTRIBUTE3
, L.ATTRIBUTE4
, L.ATTRIBUTE5
, L.ATTRIBUTE6
, L.ATTRIBUTE7
, L.ATTRIBUTE8
, L.ATTRIBUTE9
, L.ATTRIBUTE10
, L.ATTRIBUTE11
, L.ATTRIBUTE12
, L.ATTRIBUTE13
, L.ATTRIBUTE14
, L.ATTRIBUTE15
, L.REPEAT_SOURCE_LIST_HEADER_ID
, R.LIST_NAME ROOT_LIST_NAME
, L.ENABLED_FLAG
, L.REPEAT_EXCLUDE_TYPE
, L.ASSIGNED_TO
, L.ARCHIVED_BY
, L.ARCHIVED_DATE
, RU.LIST_RULE_ID
, RU.LIST_RULE_NAME
FROM AMS_LIST_HEADERS_ALL L
, AMS_LOOKUPS LK
, AMS_LOOKUPS LK2
, AMS_LIST_HEADERS_ALL R
, AMS_P_LIST_RULES_V RU
, JTF_RS_RES_EMP_VL RES
WHERE RES.RESOURCE_ID = L.OWNER_USER_ID
AND L.ARC_LIST_USED_BY = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'AMS_SYS_ARC_QUALIFIER'
AND L.ACCESS_LEVEL = LK2.LOOKUP_CODE
AND LK2.LOOKUP_TYPE = 'AMS_ACCESS_TYPE'
AND L.REPEAT_SOURCE_LIST_HEADER_ID = R.LIST_HEADER_ID(+)
AND L.LIST_HEADER_ID = RU.LIST_HEADER_ID(+)

Columns