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: AS_PROMOTIONS_ALL

Product:	AS - Sales Foundation
Description:	Defines promotions
Implementation/DBA Data:	OSM.AS_PROMOTIONS_ALL

Primary Key: AS_PROMOTIONS_PK

PROMOTION_ID

Primary Key: AS_PROMOTIONS_UK

CODE

Primary Key: AS_PROMOTIONS_UK2

TYPE
NAME

Foreign Keys

Table	Foreign Table	Foreign Key Column
AS_PROMOTIONS_ALL	AS_EVENT_FACILITIES_ALL	AS_PROMOTIONS_ALL.EVENT_FACILITY_ID
AS_PROMOTIONS_ALL	FND_CURRENCIES	AS_PROMOTIONS_ALL.CURRENCY_CODE
AS_PROMOTIONS_ALL	MTL_SYSTEM_ITEMS_B	AS_PROMOTIONS_ALL.COLLATERAL_INVENTORY_ITEM_ID AS_PROMOTIONS_ALL.COLLATERAL_ORGANIZATION_ID
AS_COLLATERAL_KITS_ALL	AS_PROMOTIONS_ALL	AS_COLLATERAL_KITS_ALL.PARENT_COLLATERAL_ID
AS_COLLATERAL_KITS_ALL	AS_PROMOTIONS_ALL	AS_COLLATERAL_KITS_ALL.CHILD_COLLATERAL_ID
AS_COLLATERAL_REQ_ALL	AS_PROMOTIONS_ALL	AS_COLLATERAL_REQ_ALL.LIST_ID
AS_COLLATERAL_REQ_ALL	AS_PROMOTIONS_ALL	AS_COLLATERAL_REQ_ALL.MAIL_BLITZ_ID
AS_COLLATERAL_REQ_ALL	AS_PROMOTIONS_ALL	AS_COLLATERAL_REQ_ALL.LETTER_ID
AS_COLLATERAL_CAT_ALL	AS_PROMOTIONS_ALL	AS_COLLATERAL_CAT_ALL.PROMOTION_ID
AS_COLLATERAL_REQ_ITEMS	AS_PROMOTIONS_ALL	AS_COLLATERAL_REQ_ITEMS.COLLATERAL_ID
AS_EVENT_ENROLLMENTS_ALL	AS_PROMOTIONS_ALL	AS_EVENT_ENROLLMENTS_ALL.EVENT_ID
AS_EVENT_ENROLLMENTS_ALL	AS_PROMOTIONS_ALL	AS_EVENT_ENROLLMENTS_ALL.SOURCE_PROMOTION_ID
AS_EVENT_LETTERS_ALL	AS_PROMOTIONS_ALL	AS_EVENT_LETTERS_ALL.EVENT_ID
AS_EVENT_LETTERS_ALL	AS_PROMOTIONS_ALL	AS_EVENT_LETTERS_ALL.LETTER_ID
AS_LIST_ENTRIES	AS_PROMOTIONS_ALL	AS_LIST_ENTRIES.LIST_ID
AS_PROMOTION_RELATIONSHIPS	AS_PROMOTIONS_ALL	AS_PROMOTION_RELATIONSHIPS.PARENT_PROMOTION_ID
AS_PROMOTION_RELATIONSHIPS	AS_PROMOTIONS_ALL	AS_PROMOTION_RELATIONSHIPS.CHILD_PROMOTION_ID
AS_PROMOTION_SCRIPTS	AS_PROMOTIONS_ALL	AS_PROMOTION_SCRIPTS.SCRIPT_ID
AS_PROMOTION_SCRIPTS	AS_PROMOTIONS_ALL	AS_PROMOTION_SCRIPTS.PROMOTION_ID
AS_SCRIPT_QUESTIONS	AS_PROMOTIONS_ALL	AS_SCRIPT_QUESTIONS.SCRIPT_ID
AS_SCRIPT_ANSWER_ACTIONS_ALL	AS_PROMOTIONS_ALL	AS_SCRIPT_ANSWER_ACTIONS_ALL.PROMOTION_ID
AS_SCRIPT_PRE_DEFINED_ANSWERS	AS_PROMOTIONS_ALL	AS_SCRIPT_PRE_DEFINED_ANSWERS.SCRIPT_ID