Table: AMS_CUSTOM_SETUP_PURPOSE | Oracle EBS ETRM Search

Table: AMS_CUSTOM_SETUP_PURPOSE 12.1.1 standalone

Stores Custom Setup, Purpose and Default List Template Association

AMS.AMS_CUSTOM_SETUP_PURPOSE·Explore AMS module →

View: AMS_SOURCE_CODES_DETAILS_V 12.2.2

APPS.AMS_SOURCE_CODES_DETAILS_V·↳ AMS_CAMPAIGNS_VL·↳ AMS_CAMPAIGN_SCHEDULES_VL·↳ AMS_EVENT_HEADERS_VL·Explore AMS module →

Table: AMS_PRICE_LIST_ATTRIBUTES 12.1.1 link

owner AMS·AMS - Marketing·15 columns

This is a surrogate table to QP_LIST_HEADERS_B for Price List related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, owner and other attributes specifice to Marketing Online Requir

AMS.AMS_PRICE_LIST_ATTRIBUTES·Explore AMS module →

Table: AMS_CUSTOM_SETUPS_TL 12.2.2 satellite-leaning

owner AMS·AMS - Marketing·12 columns

Stores all translated columns.

AMS.AMS_CUSTOM_SETUPS_TL·Explore AMS module →

Table: AMS_ITEM_ATTRIBUTES 12.2.2 link

owner AMS·AMS - Marketing·17 columns

This table will store Oracle Inventory Information and OMO information.

AMS.AMS_ITEM_ATTRIBUTES·Explore AMS module →

View: AMS_CUSTOM_SETUPS_VL 12.2.2

AMS - Marketing·18 columns

This view returns all the custom setups details.

APPS.AMS_CUSTOM_SETUPS_VL·↳ AMS_CUSTOM_SETUPS_B·↳ AMS_CUSTOM_SETUPS_TL·Explore AMS module →

Table: AMS_CUSTOM_SETUP_PURPOSE 12.2.2 standalone

owner AMS·AMS - Marketing·13 columns

Stores Custom Setup, Purpose and Default List Template Association

AMS.AMS_CUSTOM_SETUP_PURPOSE·Explore AMS module →

View: AMS_CUSTOM_SETUP_SCR_V 12.2.2

AMS - Marketing·19 columns

This view returns all the custom setups details.

APPS.AMS_CUSTOM_SETUP_SCR_V·↳ AMS_CUSTOM_SETUPS_VL·↳ AMS_LOOKUPS·↳ AMS_MEDIA_VL·Explore AMS module →

Table: OZF_PRICE_LIST_ATTRIBUTES 12.1.1 link

owner OZF·OZF - Trade Management·15 columns

This is a surrogate table to QP_LIST_HEADERS_B for Price List related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, owner and other attributes specifice to Trade Management Requir

OZF.OZF_PRICE_LIST_ATTRIBUTES·Explore OZF module →

Table: AMS_CUSTOM_SETUPS_B 12.1.1 hub-leaning

owner AMS·AMS - Marketing·17 columns

Stores all the custom setups.

AMS.AMS_CUSTOM_SETUPS_B·Explore AMS module →

Table: AMS_OBJECT_ATTRIBUTES 12.2.2 link

owner AMS·AMS - Marketing·14 columns

This table is obsoleted and no longer in use.

AMS.AMS_OBJECT_ATTRIBUTES·Explore AMS module →

Table: OZF_CLAIM_DEF_RULES_ALL 12.2.2 satellite-leaning

owner OZF·OZF - Trade Management·18 columns

This table stores the default claim type, reason and custom setup a claim source

OZF.OZF_CLAIM_DEF_RULES_ALL·Explore OZF module →

Table: OZF_PRICE_LIST_ATTRIBUTES 12.2.2 link

owner OZF·OZF - Trade Management·15 columns

This is a surrogate table to QP_LIST_HEADERS_B for Price List related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, owner and other attributes specifice to Trade Management Requir

OZF.OZF_PRICE_LIST_ATTRIBUTES·Explore OZF module →

Table: AMS_APPROVAL_HISTORY 12.2.2 standalone

owner AMS·AMS - Marketing·19 columns

Stores Approval History for Marketing Objects

AMS.AMS_APPROVAL_HISTORY·Explore AMS module →

Table: AMS_CALENDAR_CRITERIA 12.2.2 standalone

owner AMS·AMS - Marketing·19 columns

Stores criteria for displaying Marketing Objects on Calendar.

AMS.AMS_CALENDAR_CRITERIA·Explore AMS module →

Table: AMS_APPROVAL_HISTORY 12.1.1 standalone

owner AMS·AMS - Marketing·19 columns

Stores Approval History for Marketing Objects