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_DTL

Object Details

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

Cost Component Details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: CM_CMPT_DTL_PK

CMPNTCOST_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CM_CMPT_DTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CMPNTCOST_ID
CM_CMPT_DTLI1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALENDAR_CODE PERIOD_CODE COST_MTHD_CODE
CM_CMPT_DTLI2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FMEFF_ID
CM_CMPT_DTL_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_ID COST_TYPE_ID ORGANIZATION_ID INVENTORY_ITEM_ID COST_CMPNTCLS_ID COST_ANALYSIS_CODE COST_LEVEL

Foreign Keys

Table	Foreign Table	Foreign Key Column
CM_ACST_LED	CM_CMPT_DTL	CM_ACST_LED CMPNTCOST_ID
CM_BRDN_DTL	CM_CMPT_DTL	CM_BRDN_DTL CMPNTCOST_ID
CM_SCST_LED	CM_CMPT_DTL	CM_SCST_LED CMPNTCOST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CMPNTCOST_ID	NUMBER	(10)	Yes	Surrogate ID for the Cost Component
ITEM_ID	NUMBER	(10)		Surrogate for item for which the cost is specified
WHSE_CODE	VARCHAR2	(4)		Warehouse for which the cost is specified
CALENDAR_CODE	VARCHAR2	(4)		Cost Calendar for which the cost is specified
PERIOD_CODE	VARCHAR2	(4)		Costing Period for which the cost is specified
COST_MTHD_CODE	VARCHAR2	(4)		Cost Method for which the cost is specified
COST_CMPNTCLS_ID	NUMBER	(10)	Yes	Surrogate for component class
COST_ANALYSIS_CODE	VARCHAR2	(4)	Yes	Analysis code
COST_LEVEL	NUMBER	(5)	Yes	Cost source. 0=Directly entered or Routing/Burden costs calculated by Cost Rollup process or Calculated by Actual Cost Process, 1= Costs via Ingredients calculated by Cost Rollup Process
CMPNT_COST	NUMBER		Yes	Component cost
BURDEN_IND	NUMBER	(5)	Yes	Indicates if costs came from burdens 0=No 1=Yes
FMEFF_ID	NUMBER	(10)		Effectivity used in determining Product(hence formula, routing - if any) during Cost Rollup Process
ROLLOVER_IND	NUMBER	(5)	Yes	Indicates if costs have been updated to GL area and hence frozen or not - 0=No 1=Yes, updated.
TOTAL_QTY	NUMBER			Written by Actual Cost Process. Usually the total transaction quantity of the item used in calculating the actual cost but not used currently by other programs.
COSTCALC_ORIG	NUMBER	(5)		Cost calculation origin for actual costs only; 0 = Actual Cost Calculation, 1 = Cost Development Process
RMCALC_TYPE	NUMBER	(5)		Raw Material Cost Calculation Type (applicable under actual costs only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC, 4-LSTT, 5 -LSTI
ROLLUP_REF_NO	NUMBER	(10)		Reference number of the Cost Rollup process that calculated this cost
ACPROC_ID	NUMBER	(10)		Reference number of the Actual Cost Process that calculated this cost
TRANS_CNT	NUMBER	(10)		Not currently used
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
REQUEST_ID	NUMBER	(15)		Concurrent who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield segment
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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
PERIOD_TRANS_QTY	NUMBER			Total period transaction quantity
PERIOD_PERP_QTY	NUMBER			Total perpetual transaction quantity
COST_TYPE_ID	NUMBER	(15)		cost type identifier
INVENTORY_ITEM_ID	NUMBER	(15)		inventory item identifier
ORGANIZATION_ID	NUMBER	(15)		organization identifier
PERIOD_ID	NUMBER	(15)		period identifier

Query Text

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


SELECT CMPNTCOST_ID
,      ITEM_ID
,      WHSE_CODE
,      CALENDAR_CODE
,      PERIOD_CODE
,      COST_MTHD_CODE
,      COST_CMPNTCLS_ID
,      COST_ANALYSIS_CODE
,      COST_LEVEL
,      CMPNT_COST
,      BURDEN_IND
,      FMEFF_ID
,      ROLLOVER_IND
,      TOTAL_QTY
,      COSTCALC_ORIG
,      RMCALC_TYPE
,      ROLLUP_REF_NO
,      ACPROC_ID
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      PERIOD_TRANS_QTY
,      PERIOD_PERP_QTY
,      COST_TYPE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PERIOD_ID
FROM GMF.CM_CMPT_DTL;

Dependencies

[top of page]

GMF.CM_CMPT_DTL does not reference any database object

GMF.CM_CMPT_DTL is referenced by following:

APPS: CM_CMPT_DTL