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

TABLE: GMF.CM_CMPT_MST_B

Object Details
Object Name: CM_CMPT_MST_B
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.CM_CMPT_MST_B
Subobject Name:
Status: VALID


Cost Component Master


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CM_CMPT_MST_B_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOST_CMPNTCLS_ID
Columns
Name Datatype Length Mandatory Comments
COST_CMPNTCLS_ID NUMBER (10) Yes Surrogate for component class
SORT_SEQUENCE NUMBER (10) Yes Sequence the component costs are sorted by on Cost details screen
USAGE_IND NUMBER (5) Yes Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment
PRIMARY_CMPNTCLS_ID NUMBER (10) Yes Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. As a default all component classes are primary unless otherwise specified.
PRODUCT_COST_IND NUMBER (5) Yes This field indicates whether the component class will affect the cost of a product or not. What this means is that the cost Rollup process will ignore the component costs marked as non-product costs. Valid values are: 0 = Not a product cost 1 = will contribute to the product cost. Used by Cost Rollup process only.
UPDATE_COST_IND NUMBER (5) Yes This field indicates whether the component cost will be updated to the GL area. (gl_item_cst, gl_item_dtl) If the cost component class is already defined as a Non-product cost(product_cost_ind =0) then it should not be updated to the GL area. Valid values are: 0 = Do not update to GL area 1 = update to GL area.
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
PPV_IND NUMBER (5) Yes Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE16 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE17 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE18 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE19 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE20 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE21 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE22 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE23 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE24 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE25 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE26 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE27 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE28 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE29 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE30 VARCHAR2 (240)
Descriptive Flexfield
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield
CMPNT_GROUP#1 VARCHAR2 (32)
Component Group #1
COST_CMPNTCLS_CODE#1 VARCHAR2 (32) Yes COST_CMPNTCLS_CODE #1
COST_CMPNTCLS_DESC#1 VARCHAR2 (240)
Cost Component Description #1
Query Text

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


SELECT COST_CMPNTCLS_ID
,      SORT_SEQUENCE
,      USAGE_IND
,      PRIMARY_CMPNTCLS_ID
,      PRODUCT_COST_IND
,      UPDATE_COST_IND
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      TEXT_CODE
,      TRANS_CNT
,      DELETE_MARK
,      PPV_IND
,      LAST_UPDATE_LOGIN
,      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
,      ATTRIBUTE_CATEGORY
,      CMPNT_GROUP#1
,      COST_CMPNTCLS_CODE#1
,      COST_CMPNTCLS_DESC#1
FROM GMF.CM_CMPT_MST_B;

Dependencies

[top of page]

GMF.CM_CMPT_MST_B does not reference any database object

GMF.CM_CMPT_MST_B is referenced by following:

SchemaGMF
ViewCM_CMPT_MST_B#