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

TABLE: GMF.CM_MTHD_MST

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


Item Cost Method Table. This table is the existing cost method
definition master. Cost methods are defined by the user. The cost
calculation method is added


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CM_MTHD_MST_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOST_MTHD_CODE
Columns
Name Datatype Length Mandatory Comments
COST_MTHD_CODE VARCHAR2 (10) Yes Cost method defined by the user
COST_MTHD_DESC VARCHAR2 (40) Yes Description of the method
COST_TYPE NUMBER (5) Yes Cost Type: 0 - Standard; 1 - Actual Cost; 6 - Lot 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.
RMCALC_TYPE NUMBER (5)
Raw Material Cost Calculation Type (applicable under Actual Cost Methods only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC, 4-LSTT, 5 -LSTI
PRODCALC_TYPE NUMBER (5)
Product Cost Calculation Type (applicable under Actual Cost Methods only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
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
USAGE_TYPE NUMBER (5)
General use or Lab use cost method flag
DEFAULT_LOT_COST_MTHD VARCHAR2 (4)
Alternate cost method to use in get_item_cost to retrieve cost of non-lot costed items.
LOT_ACTUAL_COST NUMBER (3)
Obsolete column
TRANS_START_DATE DATE

The transaction start date will be used to collect all transactions that happened after that start date for lot cost calculation purposes.
COST_TYPE_ID NUMBER (15)
cost type identifier
DEFAULT_LOT_COST_TYPE_ID NUMBER (15)
Alternate cost type identifier for Lot Cost Types
Query Text

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


SELECT COST_MTHD_CODE
,      COST_MTHD_DESC
,      COST_TYPE
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
,      RMCALC_TYPE
,      PRODCALC_TYPE
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      USAGE_TYPE
,      DEFAULT_LOT_COST_MTHD
,      LOT_ACTUAL_COST
,      TRANS_START_DATE
,      COST_TYPE_ID
,      DEFAULT_LOT_COST_TYPE_ID
FROM GMF.CM_MTHD_MST;

Dependencies

[top of page]

GMF.CM_MTHD_MST does not reference any database object

GMF.CM_MTHD_MST is referenced by following:

SchemaGMF
ViewCM_MTHD_MST#