FND Design Data [Home] [Help]

Table: AS_INTEREST_CODES_B

Product: AS - Sales Foundation
Description: Define Interest code - Base table
Implementation/DBA Data: TableOSM.AS_INTEREST_CODES_B
Primary Key: AS_INTEREST_CODES_B_PK
  1. ColumnINTEREST_CODE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AS_INTEREST_CODES_B FK Joins to TableAS_INTEREST_CODES_B AS_INTEREST_CODES_B.PARENT_INTEREST_CODE_ID
AS_INTEREST_CODES_B FK Joins to TableAS_INTEREST_TYPES_B AS_INTEREST_CODES_B.INTEREST_TYPE_ID
AS_INTEREST_CODES_B FK Joins to TableMTL_CATEGORIES_B AS_INTEREST_CODES_B.CATEGORY_ID
AS_INTEREST_CODES_B FK Joins to TableMTL_CATEGORY_SETS_B AS_INTEREST_CODES_B.CATEGORY_SET_ID
AS_INTEREST_CODES_B FK Joins to TableMTL_SYSTEM_ITEMS_B AS_INTEREST_CODES_B.PF_ITEM_ID
AS_INTEREST_CODES_B.PF_ORGANIZATION_ID
TableAS_CURRENT_ENVIRONMENT FK Joins to AS_INTEREST_CODES_B AS_CURRENT_ENVIRONMENT.PRIMARY_INTEREST_CODE_ID
TableAS_CURRENT_ENVIRONMENT FK Joins to AS_INTEREST_CODES_B AS_CURRENT_ENVIRONMENT.SECONDARY_INTEREST_CODE_ID
TableAS_INTERESTS_ALL FK Joins to AS_INTEREST_CODES_B AS_INTERESTS_ALL.PRIMARY_INTEREST_CODE_ID
TableAS_INTERESTS_ALL FK Joins to AS_INTEREST_CODES_B AS_INTERESTS_ALL.SECONDARY_INTEREST_CODE_ID
TableAS_INTEREST_CODES_ALL FK Joins to AS_INTEREST_CODES_B AS_INTEREST_CODES_ALL.INTEREST_CODE_ID
TableAS_INTEREST_CODES_B FK Joins to AS_INTEREST_CODES_B AS_INTEREST_CODES_B.PARENT_INTEREST_CODE_ID
TableAS_INTEREST_CODES_MC FK Joins to AS_INTEREST_CODES_B AS_INTEREST_CODES_MC.INTEREST_CODE_ID
TableAS_INTEREST_CODES_TL FK Joins to AS_INTEREST_CODES_B AS_INTEREST_CODES_TL.INTEREST_CODE_ID
TableAS_LEAD_LINES_ALL FK Joins to AS_INTEREST_CODES_B AS_LEAD_LINES_ALL.PRIMARY_INTEREST_CODE_ID
TableAS_LEAD_LINES_ALL FK Joins to AS_INTEREST_CODES_B AS_LEAD_LINES_ALL.SECONDARY_INTEREST_CODE_ID
TableAS_PE_INT_CATEGORIES FK Joins to AS_INTEREST_CODES_B AS_PE_INT_CATEGORIES.PRI_INTEREST_CODE_ID
TableAS_PE_INT_CATEGORIES FK Joins to AS_INTEREST_CODES_B AS_PE_INT_CATEGORIES.SEC_INTEREST_CODE_ID
TableAS_QUOTA_PROFILES FK Joins to AS_INTEREST_CODES_B AS_QUOTA_PROFILES.PRIMARY_INTEREST_CODE_ID
TableAS_SALES_CREDITS_DENORM FK Joins to AS_INTEREST_CODES_B AS_SALES_CREDITS_DENORM.PRIMARY_INTEREST_CODE_ID
TableAS_SALES_CREDITS_DENORM FK Joins to AS_INTEREST_CODES_B AS_SALES_CREDITS_DENORM.SECONDARY_INTEREST_CODE_ID
TableAS_SALES_LEAD_LINES FK Joins to AS_INTEREST_CODES_B AS_SALES_LEAD_LINES.PRIMARY_INTEREST_CODE_ID
TableAS_SALES_LEAD_LINES FK Joins to AS_INTEREST_CODES_B AS_SALES_LEAD_LINES.SECONDARY_INTEREST_CODE_ID
TableAS_SALES_QUOTAS FK Joins to AS_INTEREST_CODES_B AS_SALES_QUOTAS.PRIMARY_INTEREST_CODE_ID
TableAS_SALES_QUOTAS FK Joins to AS_INTEREST_CODES_B AS_SALES_QUOTAS.SECONDARY_INTEREST_CODE_ID
TableIGS_RC_IS_I_LINES FK Joins to AS_INTEREST_CODES_B IGS_RC_IS_I_LINES.INQ_PROG_CODE_ID
TableIGS_RC_IS_I_LINES FK Joins to AS_INTEREST_CODES_B IGS_RC_IS_I_LINES.INQ_UNIT_SET_CODE_ID
TableIGS_RC_I_PKG_REDUCT FK Joins to AS_INTEREST_CODES_B IGS_RC_I_PKG_REDUCT.INQ_PROG_ID
TableIGS_RC_I_PKG_REDUCT FK Joins to AS_INTEREST_CODES_B IGS_RC_I_PKG_REDUCT.INQ_USET_ID