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.GL_ITEM_CST

Object Details

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

Item costs for transactions. Maintains accounting and current costs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_ITEM_CST_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEMCOST_ID
GL_ITEM_CST_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID INVENTORY_ITEM_ID COST_TYPE_ID END_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
FINAL_FLAG	NUMBER	(5)	Yes	Indicates if Cost is frozen: 0 - not frozen, can be updated from CDA by running Cost Update process; 1 - Frozen, cannot be modified.
ORGN_CODE	VARCHAR2	(4)		Organization of item cost.
WHSE_CODE	VARCHAR2	(4)		Warehouse for the cost. ( Plant whse or default costing whse.)
ITEM_ID	NUMBER	(10)		Item for which cost is stored
COST_MTHD_CODE	VARCHAR2	(4)		Cost method for accounting cost.
END_DATE	DATE		Yes	End effective date for the accounting cost.
START_DATE	DATE		Yes	Start Effective date for accounting cost.
CALENDAR_CODE	VARCHAR2	(4)		Costing calendar code.
PERIOD_CODE	VARCHAR2	(4)		Costing period code.
COST_TYPE	NUMBER	(5)	Yes	Type of cost. 0=other; 1=std; 2=avg actual; 3=current. Not currently used.
ACCTG_COST	NUMBER		Yes	Item cost as seen by OPM programs, especially Susidiary Ledger Update process.
FMEFF_ID	NUMBER	(10)		Formula effectivity used in the calculation of accounting cost.
ITEMCOST_ID	NUMBER	(10)	Yes	Surrogate key to the row. Foreign Key to GL_ITEM_DTL table.
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
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
REQUEST_ID	NUMBER	(15)		Concurrent who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
COST_TYPE_ID	NUMBER	(15)		cost type identifier
INVENTORY_ITEM_ID	NUMBER	(15)		inventory item identifier
ORGANIZATION_ID	NUMBER	(15)		organization identifier
PERIOD_ID	NUMBER	(15)		period identifier

Query Text

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


SELECT FINAL_FLAG
,      ORGN_CODE
,      WHSE_CODE
,      ITEM_ID
,      COST_MTHD_CODE
,      END_DATE
,      START_DATE
,      CALENDAR_CODE
,      PERIOD_CODE
,      COST_TYPE
,      ACCTG_COST
,      FMEFF_ID
,      ITEMCOST_ID
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COST_TYPE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PERIOD_ID
FROM GMF.GL_ITEM_CST;

Dependencies

[top of page]

GMF.GL_ITEM_CST does not reference any database object

GMF.GL_ITEM_CST is referenced by following:

GMF: GL_ITEM_CST#