Table: AMS_QUERY_TEMP_PURPOSE_ASSOC | Oracle EBS ETRM Search

Table: AMS_QUERY_TEMP_PURPOSE_ASSOC 12.1.1 standalone

This table stores the purpose values associated with a query template in Audience Workbench.

AMS.AMS_QUERY_TEMP_PURPOSE_ASSOC·Explore AMS module →

Table: AMS_QUERY_COND_DISP_STRUCT_ALL 12.1.1 standalone

This table contains the body of the condition or in other words, has the non-variant information (condition parts that don't change between Admin and End User) in a query condition in Audience Workbench.

AMS.AMS_QUERY_COND_DISP_STRUCT_ALL·Explore AMS module →

Table: AMS_LIST_QUERIES_ALL 12.1.1 hub-leaning

owner AMS·AMS - Marketing·28 columns

This table stores the predefined criteria for list creation.

AMS.AMS_LIST_QUERIES_ALL·Explore AMS module →

Table: AMS_LIST_QUERIES_ALL 12.2.2 hub-leaning

owner AMS·AMS - Marketing·29 columns

This table stores the predefined criteria for list creation.

AMS.AMS_LIST_QUERIES_ALL·Explore AMS module →

View: AMS_LIST_QUERIES_VL 12.2.2

AMS - Marketing·29 columns

This view stores the list queries.

APPS.AMS_LIST_QUERIES_VL·↳ AMS_LIST_QUERIES_ALL·↳ AMS_LIST_QUERIES_TL·Explore AMS module →

Table: AMS_QUERY_TEMP_PURPOSE_ASSOC 12.2.2 standalone

owner AMS·AMS - Marketing·15 columns

This table stores the purpose values associated with a query template in Audience Workbench.

AMS.AMS_QUERY_TEMP_PURPOSE_ASSOC·Explore AMS module →

Table: AMS_QUERY_COND_DISP_STRUCT_ALL 12.2.2 standalone

owner AMS·AMS - Marketing·24 columns

This table contains the body of the condition or in other words, has the non-variant information (condition parts that don't change between Admin and End User) in a query condition in Audience Workbench.

AMS.AMS_QUERY_COND_DISP_STRUCT_ALL·Explore AMS module →

View: AMS_QUERY_COND_DISP_STRUCT_VL 12.1.1

AMS - Marketing·25 columns

This view stores the body of the condition or in other words, has the non-variant information (condition parts that don't change between Admin and End User) in a query condition in Audience Workbench.

APPS.AMS_QUERY_COND_DISP_STRUCT_VL·↳ AMS_QUERY_COND_DISP_STRUCT_ALL·↳ AMS_QUERY_COND_DISP_STRUCT_TL·Explore AMS module →

View: AMS_QUERY_COND_DISP_STRUCT_VL 12.2.2

AMS - Marketing·25 columns

This view stores the body of the condition or in other words, has the non-variant information (condition parts that don't change between Admin and End User) in a query condition in Audience Workbench.

APPS.AMS_QUERY_COND_DISP_STRUCT_VL·↳ AMS_QUERY_COND_DISP_STRUCT_ALL·↳ AMS_QUERY_COND_DISP_STRUCT_TL·Explore AMS module →

View: AMS_LIST_QUERIES_VL 12.1.1

AMS - Marketing·29 columns

This view stores the list queries.

APPS.AMS_LIST_QUERIES_VL·↳ AMS_LIST_QUERIES_ALL·↳ AMS_LIST_QUERIES_TL·Explore AMS module →

Table: AMS_LIST_HEADERS_ALL 12.1.1 hub-leaning

owner AMS·AMS - Marketing·127 columns

This table stores the name and other details about a target list.

AMS.AMS_LIST_HEADERS_ALL·Explore AMS module →

View: AMS_LIST_HEADERS_VL 12.1.1

AMS - Marketing·128 columns

APPS.AMS_LIST_HEADERS_VL·↳ AMS_LIST_HEADERS_ALL·↳ AMS_LIST_HEADERS_ALL_TL·Explore AMS module →

View: AMS_LIST_HEADERS_VL 12.2.2

AMS - Marketing·128 columns

APPS.AMS_LIST_HEADERS_VL·↳ AMS_LIST_HEADERS_ALL·↳ AMS_LIST_HEADERS_ALL_TL·Explore AMS module →

Table: AMS_LIST_HEADERS_ALL 12.2.2 hub

owner AMS·AMS - Marketing·128 columns

This table stores the name and other details about a target list.

AMS.AMS_LIST_HEADERS_ALL·Explore AMS module →

VIEW: AMS.AMS_LIST_QUERIES_ALL# 12.2.2

VIEW: AMS.AMS_QUERY_COND_DISP_STRUCT_AL# 12.2.2

VIEW: AMS.AMS_QUERY_TEMP_PURPOSE_ASSOC# 12.2.2

owner AMS

APPS.AMS_QUERY_PURP_ASSOC_PKG SQL Statements 12.2.2

APPS.AMS_QUERY_PURP_ASSOC_PKG SQL Statements 12.1.1

TABLE: AMS.AMS_QUERY_TEMP_PURPOSE_ASSOC 12.2.2

owner AMS

TABLE: AMS.AMS_QUERY_COND_DISP_STRUCT_ALL 12.2.2

owner AMS

VIEW: AMS.AMS_LIST_QUERIES_ALL# 12.2.2

owner AMS

VIEW: AMS.AMS_QUERY_COND_DISP_STRUCT_AL# 12.2.2

owner AMS

TABLE: AMS.AMS_QUERY_TEMP_PURPOSE_ASSOC 12.1.1

owner AMS

TABLE: AMS.AMS_LIST_QUERIES_ALL 12.1.1

owner AMS

VIEW: APPS.AMS_QUERY_COND_DISP_STRUCT_VL 12.1.1

VIEW: APPS.AMS_QUERY_COND_DISP_STRUCT_VL 12.2.2

APPS.AMS_LIST_RUNNING_TOTAL_PVT SQL Statements 12.2.2

VIEW: APPS.AMS_LIST_QUERIES_VL 12.1.1

VIEW: APPS.AMS_LIST_QUERIES_VL 12.2.2

TABLE: AMS.AMS_LIST_QUERIES_ALL 12.2.2

owner AMS

TABLE: AMS.AMS_QUERY_COND_DISP_STRUCT_ALL 12.1.1

owner AMS

APPS.AMS_LIST_RUNNING_TOTAL_PVT SQL Statements 12.1.1

VIEW: AMS.AMS_LIST_HEADERS_ALL# 12.2.2

PACKAGE: APPS.AMS_LIST_RUNNING_TOTAL_PVT 12.1.1 PVT API

used by 1

PACKAGE: APPS.AMS_LIST_QUERIES_NEW_PKG 12.2.2

PACKAGE BODY: APPS.AMS_QUERY_PURP_ASSOC_PKG 12.1.1

PACKAGE BODY: APPS.AMS_LIST_RUNNING_TOTAL_PVT 12.2.2 PVT API

used by 1

APPS.AMS_QUERY_COND_DISP_STRUCT_PKG SQL Statements 12.1.1

PACKAGE BODY: APPS.AMS_QUERY_COND_DISP_STRUCT_PKG 12.1.1

PACKAGE BODY: APPS.AMS_LIST_QUERIES_NEW_PKG 12.1.1

PACKAGE: APPS.AMS_LIST_QUERIES_NEW_PKG 12.1.1

PACKAGE: APPS.AMS_QUERY_COND_DISP_STRUCT_PKG 12.2.2

PACKAGE BODY: APPS.AMS_QUERY_COND_DISP_STRUCT_PKG 12.2.2

PACKAGE BODY: APPS.AMS_QUERY_PURP_ASSOC_PKG 12.2.2

APPS.AMS_LIST_QUERIES_NEW_PKG SQL Statements 12.2.2

PACKAGE BODY: APPS.AMS_LIST_RUNNING_TOTAL_PVT 12.1.1 PVT API

used by 1

PACKAGE: APPS.AMS_LIST_RUNNING_TOTAL_PVT 12.2.2 PVT API

used by 1

APPS.AMS_QUERY_COND_DISP_STRUCT_PKG SQL Statements 12.2.2

Results for “query_template_id”