Table: AMS_OFFER_PARTIES | Oracle EBS ETRM Search

Table: AMS_OFFER_PARTIES 12.1.1 link

This table stores all the parties eligible for the request only active offers created through Oracle Marketing Online

AMS.AMS_OFFER_PARTIES·Explore AMS module →

Table: OZF_OFFER_PARTIES_TEMP 12.1.1 standalone

owner OZF·OZF - Trade Management·9 columns

This table stores all the parties eligible for the request only active offers created through Oracle Trade Management temporarily when full refresh is performed through the concurrent program.

OZF.OZF_OFFER_PARTIES_TEMP·Explore OZF module →

Table: OZF_OFFER_PARTIES_TEMP 12.2.2 standalone

owner OZF·OZF - Trade Management·9 columns

This table stores all the parties eligible for the request only active offers created through Oracle Trade Management temporarily when full refresh is performed through the concurrent program.

OZF.OZF_OFFER_PARTIES_TEMP·Explore OZF module →

Table: AMS_OFFER_PRODUCTS_TEMP 12.2.2 standalone

owner AMS·AMS - Marketing·9 columns

This table stores all the products defined for the request only active offers created through Oracle Marketing Online temporarily when full refresh is performed through the concurrent program.

AMS.AMS_OFFER_PRODUCTS_TEMP·Explore AMS module →

Table: OZF_VOLUME_OFFER_TIERS 12.2.2 satellite-leaning

owner OZF·OZF - Trade Management·11 columns

Stores tier info of volume offer

OZF.OZF_VOLUME_OFFER_TIERS·Explore OZF module →

Table: OZF_OFFER_PARTIES 12.2.2 link

owner OZF·OZF - Trade Management·9 columns

This table stores all the parties eligible for the request only active offers created through Oracle Trade Management.

OZF.OZF_OFFER_PARTIES·Explore OZF module →

Table: AMS_OFFER_PRODUCTS_TEMP 12.1.1 standalone

owner AMS·AMS - Marketing·9 columns

This table stores all the products defined for the request only active offers created through Oracle Marketing Online temporarily when full refresh is performed through the concurrent program.

AMS.AMS_OFFER_PRODUCTS_TEMP·Explore AMS module →

Table: OZF_OFFER_PRODUCTS 12.2.2 satellite-leaning

owner OZF·OZF - Trade Management·9 columns

This table stores all the products defined for the request only active offers created through Oracle Trade Management.

OZF.OZF_OFFER_PRODUCTS·Explore OZF module →

Table: AMS_OFFER_PARTIES_TEMP 12.1.1 standalone

owner AMS·AMS - Marketing·9 columns

This table stores all the parties eligible for the request only active offers created through Oracle Marketing Online temporarily when full refresh is performed through the concurrent program.

AMS.AMS_OFFER_PARTIES_TEMP·Explore AMS module →

Table: AMS_OFFER_PARTIES 12.2.2 link

owner AMS·AMS - Marketing·9 columns

This table stores all the parties eligible for the request only active offers created through Oracle Marketing Online

AMS.AMS_OFFER_PARTIES·Explore AMS module →

Table: OZF_NAE_COMPLETION_TIME 12.1.1 standalone

owner OZF·OZF - Trade Management·9 columns

This table stores last completion time of net accrual engine for each org seperately

OZF.OZF_NAE_COMPLETION_TIME·Explore OZF module →

Table: AMS_OFFER_PRODUCTS 12.1.1 satellite-leaning

owner AMS·AMS - Marketing·9 columns

This table stores all the products defined for the request only active offers created through Oracle Marketing Online.

AMS.AMS_OFFER_PRODUCTS·Explore AMS module →

Table: OZF_OFFER_PRODUCTS_TEMP 12.1.1 standalone

owner OZF·OZF - Trade Management·9 columns

This table stores all the products defined for the request only active offers created through Oracle Trade Management temporarily when full refresh is performed through the concurrent program.

OZF.OZF_OFFER_PRODUCTS_TEMP·Explore OZF module →

Table: OZF_OFFER_PRODUCTS 12.1.1 satellite-leaning

owner OZF·OZF - Trade Management·9 columns

This table stores all the products defined for the request only active offers created through Oracle Trade Management.

OZF.OZF_OFFER_PRODUCTS·Explore OZF module →

Table: OZF_OFFER_PARTIES 12.1.1 link

owner OZF·OZF - Trade Management·9 columns

This table stores all the parties eligible for the request only active offers created through Oracle Trade Management.

OZF.OZF_OFFER_PARTIES·Explore OZF module →

Table: AMS_OFFER_PRODUCTS 12.2.2 satellite-leaning

owner AMS·AMS - Marketing·9 columns

This table stores all the products defined for the request only active offers created through Oracle Marketing Online.

AMS.AMS_OFFER_PRODUCTS·Explore AMS module →

Table: AMS_OFFER_PARTIES_TEMP 12.2.2 standalone

owner AMS·AMS - Marketing·9 columns

This table stores all the parties eligible for the request only active offers created through Oracle Marketing Online temporarily when full refresh is performed through the concurrent program.

AMS.AMS_OFFER_PARTIES_TEMP·Explore AMS module →

Table: OZF_OFFER_PRODUCTS_TEMP 12.2.2 standalone

owner OZF·OZF - Trade Management·9 columns

This table stores all the products defined for the request only active offers created through Oracle Trade Management temporarily when full refresh is performed through the concurrent program.

OZF.OZF_OFFER_PRODUCTS_TEMP·Explore OZF module →

Table: OZF_NAE_COMPLETION_TIME 12.2.2 standalone

owner OZF·OZF - Trade Management·9 columns

This table stores last completion time of net accrual engine for each org seperately

OZF.OZF_NAE_COMPLETION_TIME·Explore OZF module →

Table: OZF_VOLUME_SUMMARY 12.2.2 standalone

owner OZF·OZF - Trade Management·14 columns

This table stores accumulated volume for volume offers

OZF.OZF_VOLUME_SUMMARY·Explore OZF module →

View: PV_PG_INVITE_HEADERS_VL 12.2.2

PV - Partner Management·14 columns

APPS.PV_PG_INVITE_HEADERS_VL·↳ PV_PG_INVITE_HEADERS_B·↳ PV_PG_INVITE_HEADERS_TL·Explore PV module →

Table: OZF_VOLUME_OFFER_TIERS 12.1.1 satellite-leaning

owner OZF·OZF - Trade Management·11 columns

Stores tier info of volume offer

OZF.OZF_VOLUME_OFFER_TIERS·Explore OZF module →

Table: AMS_VOLUME_OFFER_TIERS 12.1.1 standalone

owner AMS·AMS - Marketing·11 columns

Stores tier info of volume offer

AMS.AMS_VOLUME_OFFER_TIERS·Explore AMS 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: OZF_FORECAST_CUSTOMERS 12.2.2 link

owner OZF·OZF - Trade Management·15 columns

Stores all the customers eligible for an version of Forecast

OZF.OZF_FORECAST_CUSTOMERS·Explore OZF module →

Table: AMS_OFFER_ADJUSTMENT_TIERS 12.1.1 standalone

owner AMS·AMS - Marketing·13 columns

This table stores tier infomation for offer adjustments

AMS.AMS_OFFER_ADJUSTMENT_TIERS·Explore AMS module →

Table: AMS_RELATED_DEAL_LINES 12.1.1 link

owner AMS·AMS - Marketing·16 columns

This table is used for Trade Deal Offers. Trade Deal Offers can have two modifiers in one deal line. This table will capture the relation between two lines. Modifier_id and related_modifier_id are foreign keys to list_line_id in QP_LIS

Table: OZF_RULE_BASED_LOG 12.2.2 standalone

owner OZF·OZF - Trade Management·13 columns

This table stores the Rule Based Claim Data

OZF.OZF_RULE_BASED_LOG·Explore OZF module →

Table: OZF_VOLUME_SUMMARY 12.1.1 standalone

owner OZF·OZF - Trade Management·14 columns

This table stores accumulated volume for volume offers

OZF.OZF_VOLUME_SUMMARY·Explore OZF module →

Table: OZF_OFFER_ADJUSTMENT_TIERS 12.2.2 satellite-leaning

owner OZF·OZF - Trade Management·14 columns

This table stores tier infomation for offer adjustments

OZF.OZF_OFFER_ADJUSTMENT_TIERS·Explore OZF module →

Table: OZF_RELATED_DEAL_LINES 12.2.2 link

owner OZF·OZF - Trade Management·16 columns

This table is used for Trade Deal Offers. Trade Deal Offers can have two modifiers in one deal line. This table will capture the relation between two lines. Modifier_id and related_modifier_id are foreign keys to list_line_id in QP_LIS

Table: OZF_FORECAST_PRODUCTS 12.1.1 link

owner OZF·OZF - Trade Management·16 columns

Stores all the products eligible for a version of forecast

OZF.OZF_FORECAST_PRODUCTS·Explore OZF module →

Table: OZF_OFFER_ADJUSTMENT_TIERS 12.1.1 satellite-leaning

owner OZF·OZF - Trade Management·14 columns

This table stores tier infomation for offer adjustments

OZF.OZF_OFFER_ADJUSTMENT_TIERS·Explore OZF module →

View: PV_PG_INVITE_HEADERS_VL 12.1.1

PV - Partner Management·14 columns

APPS.PV_PG_INVITE_HEADERS_VL·↳ PV_PG_INVITE_HEADERS_B·↳ PV_PG_INVITE_HEADERS_TL·Explore PV module →

Table: OZF_FORECAST_CUSTOMERS 12.1.1 link

owner OZF·OZF - Trade Management·15 columns

Stores all the customers eligible for an version of Forecast

OZF.OZF_FORECAST_CUSTOMERS·Explore OZF module →

Table: PV_PG_INVITE_HEADERS_B 12.2.2 hub-leaning

owner PV·PV - Partner Management·15 columns

Container for storing invitations sent to partners for enrollment into programs.

PV.PV_PG_INVITE_HEADERS_B·Explore PV module →

Table: PV_PG_INVITE_HEADERS_B 12.1.1 hub-leaning

owner PV·PV - Partner Management·15 columns

Container for storing invitations sent to partners for enrollment into programs.

PV.PV_PG_INVITE_HEADERS_B·Explore PV 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: OZF_OFFR_MARKET_OPTIONS 12.1.1 hub-leaning

owner OZF·OZF - Trade Management·17 columns

This table stores market option for market eligibility group in volume offer.

OZF.OZF_OFFR_MARKET_OPTIONS·Explore OZF 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_FORECAST_CUSTOMERS 12.1.1 standalone

owner AMS·AMS - Marketing·15 columns

Stores all the customers eligible for an version of Forecast

AMS.AMS_FORECAST_CUSTOMERS·Explore AMS module →

Table: AMS_FORECAST_PRODUCTS 12.1.1 standalone

owner AMS·AMS - Marketing·16 columns

Stores all the products eligible for a version of forecast

AMS.AMS_FORECAST_PRODUCTS·Explore AMS module →

Table: OZF_RELATED_DEAL_LINES 12.1.1 link

owner OZF·OZF - Trade Management·16 columns

This table is used for Trade Deal Offers. Trade Deal Offers can have two modifiers in one deal line. This table will capture the relation between two lines. Modifier_id and related_modifier_id are foreign keys to list_line_id in QP_LIS

Table: OZF_FORECAST_PRODUCTS 12.2.2 link

owner OZF·OZF - Trade Management·16 columns

Stores all the products eligible for a version of forecast

OZF.OZF_FORECAST_PRODUCTS·Explore OZF module →

Table: OZF_OFFR_MARKET_OPTIONS 12.2.2 hub-leaning

owner OZF·OZF - Trade Management·17 columns

This table stores market option for market eligibility group in volume offer.

OZF.OZF_OFFR_MARKET_OPTIONS·Explore OZF module →

View: AMS_ASO_CAMPAIGN_OFFERS_V 12.2.2

AMS - Marketing·20 columns

APPS.AMS_ASO_CAMPAIGN_OFFERS_V·↳ AMS_ACT_OFFERS·↳ QP_LIST_HEADERS_VL·Explore AMS module →

Table: OZF_ORDER_GROUP_PROD 12.2.2 standalone