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_OPRN_SUM

Object Details

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

Obsolete

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CM_OPRN_SUM_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ITEM_ID LINE_TYPE WHSE_CODE CALENDAR_CODE PERIOD_CODE RESOURCES COST_CMPNTCLS_ID COST_ANALYSIS_CODE BATCHSTEP_NO

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_ID	NUMBER	(10)	Yes	Item identifier
LINE_TYPE	NUMBER	(5)	Yes	Line type
WHSE_CODE	VARCHAR2	(4)	Yes	Warehouse code
CALENDAR_CODE	VARCHAR2	(4)	Yes	Calendar code
PERIOD_CODE	VARCHAR2	(4)	Yes	Period code
RESOURCES	VARCHAR2	(16)	Yes	Resources
COST_CMPNTCLS_ID	NUMBER	(10)	Yes	Cost component class identifier
COST_ANALYSIS_CODE	VARCHAR2	(4)	Yes	Cost analysis code
BATCHSTEP_NO	NUMBER	(5)	Yes	Batch routing step number
TOTAL_RSRC_COUNT	NUMBER	(10)	Yes	Total resource count
TOTAL_RSRC_USAGE	NUMBER		Yes	Total resource usage
USAGE_UM	VARCHAR2	(4)	Yes	Usage unit of measure
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard delete mark
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column

Query Text

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


SELECT ITEM_ID
,      LINE_TYPE
,      WHSE_CODE
,      CALENDAR_CODE
,      PERIOD_CODE
,      RESOURCES
,      COST_CMPNTCLS_ID
,      COST_ANALYSIS_CODE
,      BATCHSTEP_NO
,      TOTAL_RSRC_COUNT
,      TOTAL_RSRC_USAGE
,      USAGE_UM
,      CREATION_DATE
,      CREATED_BY
,      DELETE_MARK
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM GMF.CM_OPRN_SUM;

Dependencies

[top of page]

GMF.CM_OPRN_SUM does not reference any database object

GMF.CM_OPRN_SUM is referenced by following:

APPS: CM_OPRN_SUM