Table: AMS_PARTY_DEDUPE | Oracle EBS ETRM Search

Table: AMS_PARTY_DEDUPE 12.2.2 standalone

This table is used to hold the key data information from HZ_PARTIES, which in turn gets used when processing imported external data to identify if the external data already exists in the system.

AMS.AMS_PARTY_DEDUPE·Explore AMS module →

Table: AMS_PARTY_DEDUPE 12.1.1 standalone

owner AMS·AMS - Marketing·9 columns

This table is used to hold the key data information from HZ_PARTIES, which in turn gets used when processing imported external data to identify if the external data already exists in the system.

AMS.AMS_PARTY_DEDUPE·Explore AMS module →

View: AMS_HZ_B2C_MAPPING_V 12.2.2

AMS - Marketing·405 columns

This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.

APPS.AMS_HZ_B2C_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →

View: AMS_HZ_B2C_MAPPING_V 12.1.1

AMS - Marketing·405 columns

This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.

APPS.AMS_HZ_B2C_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →

View: AMS_HZ_B2B_MAPPING_V 12.2.2

AMS - Marketing·732 columns

This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.

APPS.AMS_HZ_B2B_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →

View: AMS_HZ_B2B_MAPPING_V 12.1.1

AMS - Marketing·732 columns

This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.

APPS.AMS_HZ_B2B_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →

View: AMS_P_LIST_ENTRIES_V 12.1.1

AMS - Marketing·295 columns

This public view returns all customers/contacts/target prospectsgenerated for a list, to be used for mailshots, telemarketing etc.

APPS.AMS_P_LIST_ENTRIES_V·↳ AMS_LIST_ENTRIES·Explore AMS module →

View: AMS_P_LIST_ENTRIES_V 12.2.2

AMS - Marketing·295 columns

This public view returns all customers/contacts/target prospectsgenerated for a list, to be used for mailshots, telemarketing etc.

APPS.AMS_P_LIST_ENTRIES_V·↳ AMS_LIST_ENTRIES·Explore AMS module →

Table: AMS_LIST_ENTRIES 12.1.1 satellite-leaning

owner AMS·AMS - Marketing·423 columns

This table stores all target prospects generated for a list, to be used for mailshots, telemarketing etc. This table is populated by Oracle Marketing's list generation engine.

AMS.AMS_LIST_ENTRIES·Explore AMS module →

Table: AMS_LIST_ENTRIES 12.2.2 satellite-leaning

owner AMS·AMS - Marketing·423 columns

This table stores all target prospects generated for a list, to be used for mailshots, telemarketing etc. This table is populated by Oracle Marketing's list generation engine.

AMS.AMS_LIST_ENTRIES·Explore AMS module →

Table: AMS_IMP_SOURCE_LINES 12.2.2 satellite-leaning

owner AMS·AMS - Marketing·417 columns

This table stores Persons or Organizations (Prospects) imported from external sources.

AMS.AMS_IMP_SOURCE_LINES·Explore AMS module →

Table: AMS_IMP_SOURCE_LINES 12.1.1 satellite-leaning

owner AMS·AMS - Marketing·417 columns

This table stores Persons or Organizations (Prospects) imported from external sources.

AMS.AMS_IMP_SOURCE_LINES·Explore AMS module →

APPS.AMS_LISTDEDUPE_PVT SQL Statements 12.1.1

PACKAGE: APPS.AMS_LISTDEDUPE_PVT 12.2.2 PVT API

used by 3

PACKAGE: APPS.AMS_LISTDEDUPE_PVT 12.1.1 PVT API

used by 3

PACKAGE BODY: APPS.AMS_LISTDEDUPE_PVT 12.1.1 PVT API

used by 3

APPS.AMS_LISTDEDUPE_PVT SQL Statements 12.2.2

VIEW: AMS.AMS_PARTY_DEDUPE# 12.2.2

PACKAGE BODY: APPS.AMS_LISTDEDUPE_PVT 12.2.2 PVT API

used by 3

TABLE: AMS.AMS_PARTY_DEDUPE 12.2.2

owner AMS

TABLE: AMS.AMS_PARTY_DEDUPE 12.1.1

owner AMS

VIEW: AMS.AMS_PARTY_DEDUPE# 12.2.2

owner AMS

PACKAGE BODY: APPS.AMS_LISTDEDUPE_PVT 12.1.1

APPS.AMS_PARTYIMPORT_PVT SQL Statements 12.2.2

PACKAGE BODY: APPS.AMS_LISTDEDUPE_PVT 12.2.2

APPS.AMS_PARTYIMPORT_PVT SQL Statements 12.1.1

VIEW: APPS.AMS_P_LIST_ENTRIES_V 12.1.1

VIEW: APPS.AMS_P_LIST_ENTRIES_V 12.2.2

VIEW: APPS.AMS_HZ_B2C_MAPPING_V 12.1.1

VIEW: AMS.AMS_IMP_SOURCE_LINES# 12.2.2

VIEW: AMS.AMS_LIST_ENTRIES# 12.2.2

VIEW: APPS.AMS_HZ_B2C_MAPPING_V 12.2.2

PACKAGE: APPS.AMS_LISTDEDUPE_PVT 12.2.2

PACKAGE: APPS.AMS_LISTDEDUPE_PVT 12.1.1

VIEW: APPS.AMS_HZ_B2B_MAPPING_V 12.1.1

VIEW: APPS.AMS_HZ_B2B_MAPPING_V 12.2.2

VIEW: AMS.AMS_LIST_ENTRIES# 12.2.2

owner AMS

VIEW: AMS.AMS_IMP_SOURCE_LINES# 12.2.2

owner AMS

APPS.AMS_LIST_ENTRIES_PVT SQL Statements 12.1.1

APPS.AMS_LIST_ENTRIES_PVT SQL Statements 12.2.2

VIEW: APPS.AMS_P_LIST_ENTRIES_V 12.2.2

VIEW: APPS.AMS_P_LIST_ENTRIES_V 12.1.1

PACKAGE: APPS.AMS_IS_LINE_PUB 12.1.1

PACKAGE: APPS.AMS_IS_LINE_PUB 12.2.2

PACKAGE: APPS.AMS_IS_LINE_PVT 12.2.2

PACKAGE: APPS.AMS_IS_LINE_PVT 12.1.1

TABLE: AMS.AMS_LIST_ENTRIES 12.2.2

owner AMS

APPS.IEC_VALIDATE_PVT SQL Statements 12.1.1

TABLE: AMS.AMS_LIST_ENTRIES 12.1.1

owner AMS

APPS.IEC_VALIDATE_PVT SQL Statements 12.2.2

Results for “dedupe_key”