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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OSM.AS_PE_INT_CATEGORIES

Object Details

Object Name:	AS_PE_INT_CATEGORIES
Object Type:	TABLE
Owner:	OSM
FND Design Data:	AS.AS_PE_INT_CATEGORIES
Subobject Name:
Status:	VALID

This is a mapping table between CN_QUOTAS_ALL and AS tables (AS_INTEREST_TYPES_B,AS_INTEREST_CODES_B) . The MAPPING_TYPE determines the definition.
If the Mapping Type has value Interest Type, Plan Element of CN_QUOTAS_ALL is mapped to Interest Type of AS_INTEREST_TYPES_B only. If the Mapping Type is Primary Code, Plan Element is mapped to Primary Interest Code(Interest Code) of AS_INTEREST_CODES along with Interest Type. If Mapping Type is Secondary Code, Plan Element is Mapped to Secondary Interest Code (Interest Code ) of AS_INTEREST_CODES alongwith Interest Type and Primary Interest Code.
This mapping is then used for income planning in Sales Compensation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_PE_INT_CATEGORIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PE_INT_CATEGORY_ID
AS_PE_INT_CATEGORIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUOTA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PE_INT_CATEGORY_ID	NUMBER	(15)	Yes	Plan Element Interest Category mapping table Identifier (Primary Key)
CREATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column
REQUEST_ID	NUMBER			Request Identifier
PROGRAM_APPLICATION_ID	NUMBER			Program Application Identifier
PROGRAM_ID	NUMBER			Program Identifier
PROGRAM_UPDATE_DATE	DATE			Program Update Date
QUOTA_ID	NUMBER		Yes	Foreign key to cn_quotas_all
MAPPING_TYPE	VARCHAR2	(30)	Yes	Mapping between Qutoa with Interst type/codes :Mapping Type: ?Interest Type?,?Primary Interest Code? or ?Secondary Interest Code?
INTEREST_TYPE_ID	NUMBER			Obsolete. Product Interest type identifier
PRI_INTEREST_CODE_ID	NUMBER			Obsolete. Product interest primary code identifier
SEC_INTEREST_CODE_ID	NUMBER			Obsolete. Product interest secondary code identifier
SECURITY_GROUP_ID	NUMBER			Subscriber id, for CRM Online Services use
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
PRODUCT_CATEGORY_ID	NUMBER			Maps to the new product category
PRODUCT_CAT_SET_ID	NUMBER			Stores the category set id of the catalog

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PE_INT_CATEGORY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      QUOTA_ID
,      MAPPING_TYPE
,      INTEREST_TYPE_ID
,      PRI_INTEREST_CODE_ID
,      SEC_INTEREST_CODE_ID
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      PRODUCT_CATEGORY_ID
,      PRODUCT_CAT_SET_ID
FROM OSM.AS_PE_INT_CATEGORIES;

Dependencies

[top of page]

OSM.AS_PE_INT_CATEGORIES does not reference any database object

OSM.AS_PE_INT_CATEGORIES is referenced by following:

OSM: AS_PE_INT_CATEGORIES#