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_WHSE_EFF

Object Details

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

Costing Warehouse Effectivities

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CM_WHSE_EFF_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRGT_WHSE_ID
CM_WHSE_EFF_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGN_CODE CALENDAR_CODE PERIOD_CODE ITEMCOST_CLASS ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRGT_WHSE_ID	NUMBER	(15)	Yes	Surrogate to this row
ORGN_CODE	VARCHAR2	(4)		Organization of Warehouse Effectivity
CALENDAR_CODE	VARCHAR2	(4)		Cost Calendar Code of Warehouse Effectivity
PERIOD_CODE	VARCHAR2	(4)		Cost Period Code
ITEMCOST_CLASS	VARCHAR2	(8)		Item Cost Class of Warehouse Effectivity
ITEM_ID	NUMBER	(10)		Item Surrogate ID of Effectivity
COSTING_WHSE	VARCHAR2	(4)	Yes	Costing Warehouse - The warehouse in which costs calculated for Product Items by Rollup process will be written
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
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.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
COST_CATEGORY_ID	NUMBER			Category Id for COST_CLASS
PERIOD_ID	NUMBER	(15)		period identifier

Query Text

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


SELECT TRGT_WHSE_ID
,      ORGN_CODE
,      CALENDAR_CODE
,      PERIOD_CODE
,      ITEMCOST_CLASS
,      ITEM_ID
,      COSTING_WHSE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
,      LAST_UPDATE_LOGIN
,      COST_CATEGORY_ID
,      PERIOD_ID
FROM GMF.CM_WHSE_EFF;

Dependencies

[top of page]

GMF.CM_WHSE_EFF does not reference any database object

GMF.CM_WHSE_EFF is referenced by following:

APPS: CM_WHSE_EFF