AMS — Marketing
333 documented tables · 319 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
AMS_CATEGORIES_B |
This table stores the definition for categories and is used by Events, Metrics and the Deliverables area. | hub |
AMS_CAMPAIGNS_ALL_B |
Base table to store the details of a campaign. | hub |
AMS_USER_STATUSES_B |
Stores User status information | hub |
AMS_MEDIA_B |
Specifies all different media that can be used by an activity. | hub |
AMS_CUSTOM_SETUPS_B |
Stores all the custom setups. | hub |
AMS_DELIVERABLES_ALL_B |
This table stores the details about marketing deliverables/collaterals, collaterals are uniquely identified by | hub-leaning |
AMS_DM_PARTY_DETAILS |
Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is use | hub-leaning |
AMS_EVENT_HEADERS_ALL_B |
Stores the definition of a Marketing Event. (Master Event or Event Template) | hub |
AMS_EVENT_OFFERS_ALL_B |
Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the E | hub |
AMS_LIST_HEADERS_ALL |
This table stores the name and other details about a target list. | hub |
AMS_LIST_SRC_TYPES |
This table stores all different list source types that may be used for list generation. | hub |
AMS_IBA_PL_SITES_B |
Stores the Definiton of a Site | hub-leaning |
AMS_CPAG_QUESTIONS_B |
This table holds the Questions Definition for Questions Sections in Content Pages. | hub-leaning |
AMS_DLG_COMP_TYPES_B |
Stores the Dialog Component Types | hub-leaning |
AMS_VENUES_B |
Stores places that can be used to hold an event at. | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
AMS_CAMP_SCHEDULE_PUB |
PUB | 6 | 8 packages |
AMS_LIST_IMPORT_PUB |
PUB | 5 | 5 packages |
AMS_LISTHEADER_PUB |
PUB | 6 | 3 packages |
AMS_CAMPAIGN_PUB |
PUB | 5 | 3 packages |
AMS_ACTRESOURCE_PUB |
PUB | 5 | 3 packages |
AMS_EVENTOFFER_PUB |
PUB | 5 | 2 packages |
AMS_DELIVERABLE_PUB |
PUB | 7 | 2 packages |
AMS_ACTMETRIC_PUB |
PUB | 6 | 2 packages |
AMS_REGISTRANTS_PUB |
PUB | 1 | 2 packages |
AMS_EVTREGS_PUB |
PUB | 9 | 2 packages |