VIEW: APPS.IEX_PLIST_NAMES_UWQ_V

Source

View Text - Preformatted

SELECT null IEU_OBJECT_FUNCTION, null IEU_OBJECT_PARAMETERS, null IEU_MEDIA_TYPE_UUID, null IEU_PARAM_PK_COL, null IEU_PARAM_PK_VALUE, 'RS_INDIVIDUAL' resource_type, owner_user_id resource_id, LIST_HEADER_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, VIEW_APPLICATION_ID, LIST_NAME, LIST_USED_BY_ID, ARC_LIST_USED_BY, LIST_TYPE, USER_STATUS_ID, STATUS_CODE, STATUS_DATE, GENERATION_TYPE, REPEAT_EXCLUDE_TYPE, ROW_SELECTION_TYPE, OWNER_USER_ID, CUSTOM_SETUP_ID, COUNTRY, ACCESS_LEVEL, ENABLE_LOG_FLAG, ENABLE_WORD_REPLACEMENT_FLAG, ENABLE_PARALLEL_DML_FLAG, DEDUPE_DURING_GENERATION_FLAG, GENERATE_CONTROL_GROUP_FLAG, LAST_GENERATION_SUCCESS_FLAG, FORECASTED_START_DATE, FORECASTED_END_DATE, ACTUAL_END_DATE, SENT_OUT_DATE, NO_OF_ROWS_DUPLICATES, NO_OF_ROWS_IN_LIST, NO_OF_ROWS_ACTIVE, NO_OF_ROWS_INACTIVE, ORG_ID, DESCRIPTION, LIST_PRIORITY, ASSIGN_PERSON_ID, LIST_SOURCE, LIST_SOURCE_TYPE, ENABLED_FLAG, ASSIGNED_TO, QUERY_ID, OWNER_PERSON_ID, PURGE_FLAG FROM ams_list_headers_vl alh

View Text - HTML Formatted

SELECT NULL IEU_OBJECT_FUNCTION
, NULL IEU_OBJECT_PARAMETERS
, NULL IEU_MEDIA_TYPE_UUID
, NULL IEU_PARAM_PK_COL
, NULL IEU_PARAM_PK_VALUE
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, OWNER_USER_ID RESOURCE_ID
, LIST_HEADER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, VIEW_APPLICATION_ID
, LIST_NAME
, LIST_USED_BY_ID
, ARC_LIST_USED_BY
, LIST_TYPE
, USER_STATUS_ID
, STATUS_CODE
, STATUS_DATE
, GENERATION_TYPE
, REPEAT_EXCLUDE_TYPE
, ROW_SELECTION_TYPE
, OWNER_USER_ID
, CUSTOM_SETUP_ID
, COUNTRY
, ACCESS_LEVEL
, ENABLE_LOG_FLAG
, ENABLE_WORD_REPLACEMENT_FLAG
, ENABLE_PARALLEL_DML_FLAG
, DEDUPE_DURING_GENERATION_FLAG
, GENERATE_CONTROL_GROUP_FLAG
, LAST_GENERATION_SUCCESS_FLAG
, FORECASTED_START_DATE
, FORECASTED_END_DATE
, ACTUAL_END_DATE
, SENT_OUT_DATE
, NO_OF_ROWS_DUPLICATES
, NO_OF_ROWS_IN_LIST
, NO_OF_ROWS_ACTIVE
, NO_OF_ROWS_INACTIVE
, ORG_ID
, DESCRIPTION
, LIST_PRIORITY
, ASSIGN_PERSON_ID
, LIST_SOURCE
, LIST_SOURCE_TYPE
, ENABLED_FLAG
, ASSIGNED_TO
, QUERY_ID
, OWNER_PERSON_ID
, PURGE_FLAG
FROM AMS_LIST_HEADERS_VL ALH