Table: AMS_PROGRAMS_ALL_TL | Oracle EBS ETRM Search

Table: AMS_PROGRAMS_ALL_TL 12.2.2 satellite-leaning

owner AMS·AMS - Marketing·11 columns

Stores all translated columns.

AMS.AMS_PROGRAMS_ALL_TL·Explore AMS module →

Table: AMS_PROGRAMS_ALL_TL 12.1.1 satellite-leaning

owner AMS·AMS - Marketing·11 columns

Stores all translated columns.

AMS.AMS_PROGRAMS_ALL_TL·Explore AMS module →

Table: AMS_ACT_PROGRAMS 12.2.2 link

owner AMS·AMS - Marketing·28 columns

Stores programs for a specific activity such as an event.

AMS.AMS_ACT_PROGRAMS·Explore AMS module →

View: AMS_LEAD_CONTACTS_V 12.2.2

AMS - Marketing·36 columns

This view is used by Discoverer Business Area: List generation folders.Contains contacts linked to sales opportunities

APPS.AMS_LEAD_CONTACTS_V·↳ AS_LEAD_CONTACTS_ALL·Explore AMS module →

View: AMS_LEAD_CONTACTS_V 12.1.1

AMS - Marketing·36 columns

This view is used by Discoverer Business Area: List generation folders.Contains contacts linked to sales opportunities

APPS.AMS_LEAD_CONTACTS_V·↳ AS_LEAD_CONTACTS_ALL·Explore AMS module →

Table: AMS_QUERY_ALIAS 12.1.1 standalone

owner AMS·AMS - Marketing·15 columns

This table stores the information about the data source which was cloned (self-join) in Audience Workbench.

AMS.AMS_QUERY_ALIAS·Explore AMS module →

Table: AMS_ATTB_LOV_VALUES_B 12.1.1 standalone

owner AMS·AMS - Marketing·15 columns

This table stores the values for lovs based on manually entered values created in Audience Workbench.

AMS.AMS_ATTB_LOV_VALUES_B·Explore AMS module →

View: AMS_PROGRAM_COMPONENTS_V 12.1.1

AMS - Marketing·31 columns

This view is created for giving general information about progam Components

APPS.AMS_PROGRAM_COMPONENTS_V·↳ AMS_CAMPAIGNS_ALL_B·↳ AMS_CAMPAIGNS_VL·↳ AMS_EVENT_HEADERS_VL·Explore AMS module →

Table: AMS_QUERY_CONDITION_VALUE 12.1.1 standalone

owner AMS·AMS - Marketing·16 columns

This table stores the values; default in case of admin and user supplied in case of an end user in Audience Workbench.

AMS.AMS_QUERY_CONDITION_VALUE·Explore AMS module →

Table: AMS_PROGRAMS_ALL_B 12.2.2 hub-leaning

owner AMS·AMS - Marketing·26 columns

A generic Program table, used to group activities such channels or events together.

AMS.AMS_PROGRAMS_ALL_B·Explore AMS module →

Table: AMS_PROGRAMS_ALL_B 12.1.1 hub-leaning

owner AMS·AMS - Marketing·26 columns

A generic Program table, used to group activities such channels or events together.

AMS.AMS_PROGRAMS_ALL_B·Explore AMS module →

Table: AMS_ACT_PROGRAMS 12.1.1 link

owner AMS·AMS - Marketing·28 columns

Stores programs for a specific activity such as an event.

AMS.AMS_ACT_PROGRAMS·Explore AMS module →

Table: AMS_QUERY_TEMP_PURPOSE_ASSOC 12.1.1 standalone

owner AMS·AMS - Marketing·14 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_RULE_MEDIA_ASSOC 12.1.1 standalone

owner AMS·AMS - Marketing·15 columns

Stores the default deduplication rule associated with the campaign schedule media.

AMS.AMS_RULE_MEDIA_ASSOC·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_RULE_MEDIA_ASSOC 12.2.2 standalone

owner AMS·AMS - Marketing·15 columns

Stores the default deduplication rule associated with the campaign schedule media.

AMS.AMS_RULE_MEDIA_ASSOC·Explore AMS module →

Table: AMS_QUERY_TEMP_INST_COND_ASSOC 12.2.2 standalone

owner AMS·AMS - Marketing·18 columns

This table provides condition selectivity within an INSTANCE. If the INSTANCE is for Admin, this table will have as many rows as template conditions. If the INSTANCE is for an End User, the table will have only rows corresponding to the co

AMS.AMS_QUERY_TEMP_INST_COND_ASSOC·Explore AMS module →

Table: AML_INTERACTION_LEADS 12.1.1 link

owner AMS·AMS - Marketing·16 columns

Defines relation of interactions, responses, and leads

AMS.AML_INTERACTION_LEADS·Explore AMS module →

Table: AMS_COND_STRUCT_RESTRICT_VALUE 12.1.1 standalone

owner AMS·AMS - Marketing·16 columns

This table stores the restricted LOV values in a query template condition, if any, in Audience Workbench.

AMS.AMS_COND_STRUCT_RESTRICT_VALUE·Explore AMS module →

View: AMS_PROGRAM_COMPONENTS_V 12.2.2

AMS - Marketing·31 columns

This view is created for giving general information about progam Components

APPS.AMS_PROGRAM_COMPONENTS_V·↳ AMS_CAMPAIGNS_ALL_B·↳ AMS_CAMPAIGNS_VL·↳ AMS_EVENT_HEADERS_VL·Explore AMS module →

Table: AMS_QUERY_TEMPLATE_INSTANCE 12.1.1 standalone

owner AMS·AMS - Marketing·17 columns

This table stores the query template instance information in Audience Workbench. There can be only one admin instance and every time the template is used by a List etc, one end user instance is created.

AMS.AMS_QUERY_TEMPLATE_INSTANCE·Explore AMS module →

Table: AMS_QUERY_CONDITION_VALUE 12.2.2 standalone

owner AMS·AMS - Marketing·17 columns

This table stores the values; default in case of admin and user supplied in case of an end user in Audience Workbench.

AMS.AMS_QUERY_CONDITION_VALUE·Explore AMS module →

View: AMS_ORG_CONTACT_ROLES_V 12.2.2

AMS - Marketing·20 columns

Roles played by organization contacts

APPS.AMS_ORG_CONTACT_ROLES_V·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·↳ HZ_PARTIES·Explore AMS module →

Table: AMS_COND_STRUCT_RESTRICT_VALUE 12.2.2 standalone

owner AMS·AMS - Marketing·17 columns

This table stores the restricted LOV values in a query template condition, if any, in Audience Workbench.

AMS.AMS_COND_STRUCT_RESTRICT_VALUE·Explore AMS module →

View: AMS_ATTB_LOV_VALUES_VL 12.1.1

AMS - Marketing·17 columns

This view stores the value meanings for lovs based on manually entered values created in Audience Workbench.

APPS.AMS_ATTB_LOV_VALUES_VL·↳ AMS_ATTB_LOV_VALUES_B·↳ AMS_ATTB_LOV_VALUES_TL·Explore AMS module →

View: AMS_ATTB_LOV_VALUES_VL 12.2.2

AMS - Marketing·17 columns

This view stores the value meanings for lovs based on manually entered values created in Audience Workbench.

APPS.AMS_ATTB_LOV_VALUES_VL·↳ AMS_ATTB_LOV_VALUES_B·↳ AMS_ATTB_LOV_VALUES_TL·Explore AMS module →

View: AMS_ORGANIZATION_V 12.2.2

AMS - Marketing·95 columns

This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.

APPS.AMS_ORGANIZATION_V·↳ HZ_PARTIES·Explore AMS module →

View: AMS_P_PERSON_V 12.2.2

AMS - Marketing·94 columns

This public view returns all entries from the HZ_PARTIES table which have a party_type of PERSON. Used for list generation.

APPS.AMS_P_PERSON_V·↳ HZ_PARTIES·Explore AMS module →

View: AMS_P_PERSON_V 12.1.1

AMS - Marketing·94 columns

This public view returns all entries from the HZ_PARTIES table which have a party_type of PERSON. Used for list generation.

APPS.AMS_P_PERSON_V·↳ HZ_PARTIES·Explore AMS module →

Table: AMS_ATTB_LOV_B 12.1.1 standalone

owner AMS·AMS - Marketing·18 columns

This table stores the user created and seeded lovs associated with data source columns in Audience Workbench.

AMS.AMS_ATTB_LOV_B·Explore AMS module →

View: AMS_ATTB_LOV_VL 12.1.1

AMS - Marketing·21 columns

This view stores the lovs created in Audience Workbench.

APPS.AMS_ATTB_LOV_VL·↳ AMS_ATTB_LOV_B·↳ AMS_ATTB_LOV_TL·Explore AMS module →

View: AMS_ORG_FINANCIAL_NUMS_V 12.1.1

AMS - Marketing·21 columns

Details of financial reports

APPS.AMS_ORG_FINANCIAL_NUMS_V·↳ HZ_FINANCIAL_NUMBERS·↳ HZ_FINANCIAL_REPORTS·↳ HZ_PARTIES·Explore AMS module →

Table: AML_INTERACTION_LEADS 12.2.2 link

owner AMS·AMS - Marketing·16 columns

Defines relation of interactions, responses, and leads

AMS.AML_INTERACTION_LEADS·Explore AMS module →

Table: AMS_ATTB_LOV_VALUES_B 12.2.2 standalone

owner AMS·AMS - Marketing·16 columns

This table stores the values for lovs based on manually entered values created in Audience Workbench.

AMS.AMS_ATTB_LOV_VALUES_B·Explore AMS module →

Table: AML_RULE_APPLIED_ATTRS 12.1.1 standalone

owner AMS·AMS - Marketing·18 columns

AML_RULE_APPLIED_ATTRS is used to store winning rule log for lead evaluation

AMS.AML_RULE_APPLIED_ATTRS·Explore AMS module →

Table: AML_RULE_APPLIED_ATTRS 12.2.2 standalone

owner AMS·AMS - Marketing·18 columns

AML_RULE_APPLIED_ATTRS is used to store winning rule log for lead evaluation

AMS.AML_RULE_APPLIED_ATTRS·Explore AMS module →

Table: AMS_QUERY_TEMPLATE_INSTANCE 12.2.2 standalone

owner AMS·AMS - Marketing·18 columns

This table stores the query template instance information in Audience Workbench. There can be only one admin instance and every time the template is used by a List etc, one end user instance is created.

AMS.AMS_QUERY_TEMPLATE_INSTANCE·Explore AMS module →

Table: AMS_QUERY_TEMP_INST_COND_ASSOC 12.1.1 standalone

owner AMS·AMS - Marketing·17 columns

This table provides condition selectivity within an INSTANCE. If the INSTANCE is for Admin, this table will have as many rows as template conditions. If the INSTANCE is for an End User, the table will have only rows corresponding to the co

AMS.AMS_QUERY_TEMP_INST_COND_ASSOC·Explore AMS module →

View: AMS_ORG_CONTACT_ROLES_V 12.1.1

AMS - Marketing·20 columns

Roles played by organization contacts

APPS.AMS_ORG_CONTACT_ROLES_V·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·↳ HZ_PARTIES·Explore AMS module →

View: AMS_P_ORGANIZATION_V 12.2.2

AMS - Marketing·95 columns

This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.

APPS.AMS_P_ORGANIZATION_V·↳ HZ_PARTIES·Explore AMS module →

View: AMS_P_ORGANIZATION_V 12.1.1

AMS - Marketing·95 columns

This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.

APPS.AMS_P_ORGANIZATION_V·↳ HZ_PARTIES·Explore AMS module →

View: AMS_QUERY_TEMPLATE_VL 12.2.2

AMS - Marketing·28 columns

This view stores the query template information in Audience Workbench.

APPS.AMS_QUERY_TEMPLATE_VL·↳ AMS_QUERY_TEMPLATE_ALL·↳ AMS_QUERY_TEMPLATE_TL·Explore AMS module →

View: AMS_CONTACT_RESTRICTIONS_V 12.1.1

AMS - Marketing·31 columns

APPS.AMS_CONTACT_RESTRICTIONS_V·↳ HZ_CONTACT_PREFERENCES·Explore AMS module →

View: AMS_CONTACT_RESTRICTIONS_V 12.2.2

AMS - Marketing·31 columns

APPS.AMS_CONTACT_RESTRICTIONS_V·↳ HZ_CONTACT_PREFERENCES·Explore AMS module →

Table: AMS_ATTB_LOV_B 12.2.2 standalone

owner AMS·AMS - Marketing·19 columns

This table stores the user created and seeded lovs associated with data source columns in Audience Workbench.

AMS.AMS_ATTB_LOV_B·Explore AMS module →

View: AMS_ATTB_LOV_VL 12.2.2

AMS - Marketing·21 columns

This view stores the lovs created in Audience Workbench.

APPS.AMS_ATTB_LOV_VL·↳ AMS_ATTB_LOV_B·↳ AMS_ATTB_LOV_TL·Explore AMS module →

Table: AMS_DIALOGS_ALL_B 12.2.2 satellite-leaning

owner AMS·AMS - Marketing·52 columns

This stores the dialog object

AMS.AMS_DIALOGS_ALL_B·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_PROGRAMS_VL 12.2.2

AMS - Marketing·27 columns

This view is created to give general information about marketing Programs

APPS.AMS_PROGRAMS_VL·↳ AMS_PROGRAMS_ALL_B·↳ AMS_PROGRAMS_ALL_TL·Explore AMS module →

View: AMS_PROGRAMS_VL 12.1.1

AMS - Marketing·27 columns

This view is created to give general information about marketing Programs

APPS.AMS_PROGRAMS_VL·↳ AMS_PROGRAMS_ALL_B·↳ AMS_PROGRAMS_ALL_TL·Explore AMS module →

Results for “program_id”