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: GMF.CM_CMPT_MTL

Object Details

Object Name:	CM_CMPT_MTL
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.CM_CMPT_MTL
Subobject Name:
Status:	VALID

This table contains the item or item cost class specific material cost component and material analysis code.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CM_CMPT_MTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CMPTMTL_ID
CM_CMPT_MTLI0	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEGAL_ENTITY_ID ORGANIZATION_ID INVENTORY_ITEM_ID COST_CATEGORY_ID EFF_START_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
CMPTMTL_ID	NUMBER	(15)	Yes	Number that uniquely identifies the material component class/analysis code definition. Surrogate to the row.
CO_CODE	VARCHAR2	(4)		Company for which material component and analysis code is being defined
ITEMCOST_CLASS	VARCHAR2	(8)		Item cost class for which material component and analysis code is being defined
ITEM_ID	NUMBER			Item for which material component and analysis code is being defined.
EFF_START_DATE	DATE		Yes	Material component/analysis code effective start date
EFF_END_DATE	DATE		Yes	Material component/analysis code effective end date
USE_IND	NUMBER			FOR FUTURE USE
MTL_CMPNTCLS_ID	NUMBER		Yes	Material component class specific to an item or item cost class
MTL_ANALYSIS_CODE	VARCHAR2	(4)	Yes	Material analysis code specific to an item or item cost class
TRANS_CNT	NUMBER			Not currently used
TEXT_CODE	NUMBER			ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER		Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
COST_CATEGORY_ID	NUMBER			Category Id for COST_CLASS
INVENTORY_ITEM_ID	NUMBER	(15)		inventory item identifier
LEGAL_ENTITY_ID	NUMBER	(15)		legal entity identifier
ORGANIZATION_ID	NUMBER	(15)		organization identifier
MASTER_ORGANIZATION_ID	NUMBER	(15)		master organization identifier

Query Text

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


SELECT CMPTMTL_ID
,      CO_CODE
,      ITEMCOST_CLASS
,      ITEM_ID
,      EFF_START_DATE
,      EFF_END_DATE
,      USE_IND
,      MTL_CMPNTCLS_ID
,      MTL_ANALYSIS_CODE
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      COST_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      LEGAL_ENTITY_ID
,      ORGANIZATION_ID
,      MASTER_ORGANIZATION_ID
FROM GMF.CM_CMPT_MTL;

Dependencies

[top of page]

GMF.CM_CMPT_MTL does not reference any database object

GMF.CM_CMPT_MTL is referenced by following:

APPS: CM_CMPT_MTL