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


TABLE: GMF.GMF_COST_METHOD_LEVEL

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


Table of all cost methods that cost items at the summary level


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMF_COST_METHOD_LEVEL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOST_MTHD_CODE
Columns
Name Datatype Length Mandatory Comments
COST_MTHD_CODE VARCHAR2 (4) Yes Cost Method Code
ITEM_FAMILY_BASED VARCHAR2 (1) Yes Flag for summary level costing. Y = Summary Level; N or Null = Not a Summary Level cost method
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
DELETE_MARK NUMBER (5) Yes Standard: 0 = Active record (default); 1 = Marked for (logical) deletion.
Query Text

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


SELECT COST_MTHD_CODE
,      ITEM_FAMILY_BASED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
FROM GMF.GMF_COST_METHOD_LEVEL;

Dependencies

[top of page]

GMF.GMF_COST_METHOD_LEVEL does not reference any database object

GMF.GMF_COST_METHOD_LEVEL is referenced by following:

SchemaGMF
ViewGMF_COST_METHOD_LEVEL#