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_INTEREST_CODES_B

Product:	AS - Sales Foundation
Description:	Define Interest code - Base table
Implementation/DBA Data:	OSM.AS_INTEREST_CODES_B

Primary Key: AS_INTEREST_CODES_B_PK

INTEREST_CODE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AS_INTEREST_CODES_B	AS_INTEREST_CODES_B	AS_INTEREST_CODES_B.PARENT_INTEREST_CODE_ID
AS_INTEREST_CODES_B	AS_INTEREST_TYPES_B	AS_INTEREST_CODES_B.INTEREST_TYPE_ID
AS_INTEREST_CODES_B	MTL_CATEGORIES_B	AS_INTEREST_CODES_B.CATEGORY_ID
AS_INTEREST_CODES_B	MTL_CATEGORY_SETS_B	AS_INTEREST_CODES_B.CATEGORY_SET_ID
AS_INTEREST_CODES_B	MTL_SYSTEM_ITEMS_B	AS_INTEREST_CODES_B.PF_ITEM_ID AS_INTEREST_CODES_B.PF_ORGANIZATION_ID
AS_CURRENT_ENVIRONMENT	AS_INTEREST_CODES_B	AS_CURRENT_ENVIRONMENT.PRIMARY_INTEREST_CODE_ID
AS_CURRENT_ENVIRONMENT	AS_INTEREST_CODES_B	AS_CURRENT_ENVIRONMENT.SECONDARY_INTEREST_CODE_ID
AS_INTERESTS_ALL	AS_INTEREST_CODES_B	AS_INTERESTS_ALL.PRIMARY_INTEREST_CODE_ID
AS_INTERESTS_ALL	AS_INTEREST_CODES_B	AS_INTERESTS_ALL.SECONDARY_INTEREST_CODE_ID
AS_INTEREST_CODES_ALL	AS_INTEREST_CODES_B	AS_INTEREST_CODES_ALL.INTEREST_CODE_ID
AS_INTEREST_CODES_B	AS_INTEREST_CODES_B	AS_INTEREST_CODES_B.PARENT_INTEREST_CODE_ID
AS_INTEREST_CODES_MC	AS_INTEREST_CODES_B	AS_INTEREST_CODES_MC.INTEREST_CODE_ID
AS_INTEREST_CODES_TL	AS_INTEREST_CODES_B	AS_INTEREST_CODES_TL.INTEREST_CODE_ID
AS_LEAD_LINES_ALL	AS_INTEREST_CODES_B	AS_LEAD_LINES_ALL.PRIMARY_INTEREST_CODE_ID
AS_LEAD_LINES_ALL	AS_INTEREST_CODES_B	AS_LEAD_LINES_ALL.SECONDARY_INTEREST_CODE_ID
AS_PE_INT_CATEGORIES	AS_INTEREST_CODES_B	AS_PE_INT_CATEGORIES.PRI_INTEREST_CODE_ID
AS_PE_INT_CATEGORIES	AS_INTEREST_CODES_B	AS_PE_INT_CATEGORIES.SEC_INTEREST_CODE_ID
AS_QUOTA_PROFILES	AS_INTEREST_CODES_B	AS_QUOTA_PROFILES.PRIMARY_INTEREST_CODE_ID
AS_SALES_CREDITS_DENORM	AS_INTEREST_CODES_B	AS_SALES_CREDITS_DENORM.PRIMARY_INTEREST_CODE_ID
AS_SALES_CREDITS_DENORM	AS_INTEREST_CODES_B	AS_SALES_CREDITS_DENORM.SECONDARY_INTEREST_CODE_ID
AS_SALES_LEAD_LINES	AS_INTEREST_CODES_B	AS_SALES_LEAD_LINES.PRIMARY_INTEREST_CODE_ID
AS_SALES_LEAD_LINES	AS_INTEREST_CODES_B	AS_SALES_LEAD_LINES.SECONDARY_INTEREST_CODE_ID
AS_SALES_QUOTAS	AS_INTEREST_CODES_B	AS_SALES_QUOTAS.PRIMARY_INTEREST_CODE_ID
AS_SALES_QUOTAS	AS_INTEREST_CODES_B	AS_SALES_QUOTAS.SECONDARY_INTEREST_CODE_ID
IGS_RC_IS_I_LINES	AS_INTEREST_CODES_B	IGS_RC_IS_I_LINES.INQ_PROG_CODE_ID
IGS_RC_IS_I_LINES	AS_INTEREST_CODES_B	IGS_RC_IS_I_LINES.INQ_UNIT_SET_CODE_ID
IGS_RC_I_PKG_REDUCT	AS_INTEREST_CODES_B	IGS_RC_I_PKG_REDUCT.INQ_PROG_ID
IGS_RC_I_PKG_REDUCT	AS_INTEREST_CODES_B	IGS_RC_I_PKG_REDUCT.INQ_USET_ID