Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_PLIST_NAMES_UWQ_V |
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