VIEW: APPS.AMS_P_LIST_HEADERS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)