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_BTCH_SUM

Object Details

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

Obsolete

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CM_BTCH_SUM_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ITEM_ID LINE_TYPE WHSE_CODE FISCAL_YEAR PERIOD FORMULALINE_ID

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
FISCAL_YEAR	VARCHAR2	(4)	Yes	Fiscal Year
PERIOD	NUMBER	(5)	Yes	Period
FORMULALINE_ID	NUMBER	(10)	Yes	Formula Line identifier
TOTAL_ITEM_QTY1	NUMBER		Yes	Total item quantity 1
TOTAL_ITEM_QTY2	NUMBER		Yes	Total item quantity 2
QTY1_UM	VARCHAR2	(4)	Yes	Unit of measure for quantity 1
QTY2_UM	VARCHAR2	(4)	Yes	Unit of measure for quantity 2
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard Delete Mark

Query Text

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


SELECT ITEM_ID
,      LINE_TYPE
,      WHSE_CODE
,      FISCAL_YEAR
,      PERIOD
,      FORMULALINE_ID
,      TOTAL_ITEM_QTY1
,      TOTAL_ITEM_QTY2
,      QTY1_UM
,      QTY2_UM
,      CREATION_DATE
,      CREATED_BY
,      DELETE_MARK
FROM GMF.CM_BTCH_SUM;

Dependencies

[top of page]

GMF.CM_BTCH_SUM does not reference any database object

GMF.CM_BTCH_SUM is referenced by following:

APPS: CM_BTCH_SUM