eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: AMS_EVENT_OFFERS_ALL_B

Product:	AMS - Marketing
Description:	Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings.
Implementation/DBA Data:	AMS.AMS_EVENT_OFFERS_ALL_B

Primary Key: AMS_EVENT_OFFERS_ALL_B_PK

EVENT_OFFER_ID

Primary Key: AMS_EVENT_OFFERS_ALL_B_UK1

SOURCE_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
AMS_EVENT_OFFERS_ALL_B	QP_LIST_HEADERS_B	AMS_EVENT_OFFERS_ALL_B.PRICELIST_HEADER_ID
AMS_EVENT_OFFERS_ALL_B	QP_LIST_LINES	AMS_EVENT_OFFERS_ALL_B.PRICELIST_LINE_ID
AMS_EVENT_OFFERS_ALL_B	FND_APPLICATION	AMS_EVENT_OFFERS_ALL_B.APPLICATION_ID
AMS_EVENT_OFFERS_ALL_B	HZ_TIMEZONES	AMS_EVENT_OFFERS_ALL_B.TIMEZONE_ID
AMS_EVENT_OFFERS_ALL_B	AMS_CAMPAIGNS_ALL_B	AMS_EVENT_OFFERS_ALL_B.FUND_SOURCE_ID
AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_HEADERS_ALL_B	AMS_EVENT_OFFERS_ALL_B.FUND_SOURCE_ID
AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_OFFERS_ALL_B.FUND_SOURCE_ID
AMS_EVENT_OFFERS_ALL_B	OZF_FUNDS_ALL_B	AMS_EVENT_OFFERS_ALL_B.FUND_SOURCE_ID
AMS_EVENT_OFFERS_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_EVENT_OFFERS_ALL_B.COORDINATOR_ID
AMS_EVENT_OFFERS_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_EVENT_OFFERS_ALL_B.OWNER_USER_ID
AMS_EVENT_OFFERS_ALL_B	AMS_USER_STATUSES_B	AMS_EVENT_OFFERS_ALL_B.USER_STATUS_ID
AMS_EVENT_OFFERS_ALL_B	AMS_VENUES_B	AMS_EVENT_OFFERS_ALL_B.EVENT_VENUE_ID
AMS_EVENT_OFFERS_ALL_B	AMS_CUSTOM_SETUPS_B	AMS_EVENT_OFFERS_ALL_B.SETUP_TYPE_ID
AMS_EVENT_OFFERS_ALL_B	FND_LANGUAGES	AMS_EVENT_OFFERS_ALL_B.EVENT_LANGUAGE_CODE
AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_HEADERS_ALL_B	AMS_EVENT_OFFERS_ALL_B.EVENT_HEADER_ID
AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_OFFERS_ALL_B.PARENT_EVENT_OFFER_ID
AMS_EVENT_OFFERS_ALL_B	AMS_ACT_DELIVERY_METHODS	AMS_EVENT_OFFERS_ALL_B.EVENT_DELIVERY_METHOD_ID
AMS_EVENT_OFFERS_ALL_B	HZ_LOCATIONS	AMS_EVENT_OFFERS_ALL_B.EVENT_LOCATION_ID
AMS_EVENT_OFFERS_ALL_B	AMS_USER_STATUSES_B	AMS_EVENT_OFFERS_ALL_B.EVENT_OFFER_ID
AMS_ACT_ACCESS	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_ACCESS.ACT_ACCESS_TO_OBJECT_ID
AMS_ACT_CATEGORIES	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_CATEGORIES.ACT_CATEGORY_USED_BY_ID
AMS_ACT_LISTS	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_LISTS.LIST_USED_BY_ID
AMS_ACT_MARKET_SEGMENTS	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_MARKET_SEGMENTS.ACT_MARKET_SEGMENT_USED_BY_ID
AMS_ACT_MESSAGES	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_MESSAGES.MESSAGE_USED_BY_ID
AMS_ACT_METRICS_ALL	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_METRICS_ALL.ACT_METRIC_USED_BY_ID
AMS_ACT_OBJECTIVES	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_OBJECTIVES.ACT_OBJECTIVE_USED_BY_ID
AMS_ACT_PARTNERS	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_PARTNERS.ACT_PARTNER_USED_BY_ID
AMS_ACT_PERSONS	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_PERSONS.PERSON_USED_BY_ID
AMS_ACT_PRODUCTS	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_PRODUCTS.ACT_PRODUCT_USED_BY_ID
AMS_ACT_PROGRAMS	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_PROGRAMS.ACT_PROGRAM_USED_BY_ID
AMS_ACT_RESOURCES	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_RESOURCES.ACT_RESOURCE_USED_BY_ID
AMS_ACT_SKILLS	AMS_EVENT_OFFERS_ALL_B	AMS_ACT_SKILLS.ACT_SKILL_USED_BY_ID
AMS_AGENDAS_B	AMS_EVENT_OFFERS_ALL_B	AMS_AGENDAS_B.PARENT_ID
AMS_CAMPAIGNS_ALL_B	AMS_EVENT_OFFERS_ALL_B	AMS_CAMPAIGNS_ALL_B.CHANNEL_ID
AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_OFFERS_ALL_B.FUND_SOURCE_ID
AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_OFFERS_ALL_B.PARENT_EVENT_OFFER_ID
AMS_EVENT_OFFERS_ALL_TL	AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_OFFERS_ALL_TL.EVENT_OFFER_ID
AMS_EVENT_REGISTRATIONS	AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_REGISTRATIONS.EVENT_OFFER_ID
AMS_LIST_HEADERS_ALL	AMS_EVENT_OFFERS_ALL_B	AMS_LIST_HEADERS_ALL.LIST_USED_BY_ID
AMS_OBJECT_ASSOCIATIONS	AMS_EVENT_OFFERS_ALL_B	AMS_OBJECT_ASSOCIATIONS.MASTER_OBJECT_ID
AMS_OBJECT_ASSOCIATIONS	AMS_EVENT_OFFERS_ALL_B	AMS_OBJECT_ASSOCIATIONS.USING_OBJECT_ID
AMS_OBJECT_ATTRIBUTES	AMS_EVENT_OFFERS_ALL_B	AMS_OBJECT_ATTRIBUTES.OBJECT_ID