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: GMD.GMD_LCF_EXTERNAL_COST

Object Details

Object Name:	GMD_LCF_EXTERNAL_COST
Object Type:	TABLE
Owner:	GMD
FND Design Data:	GMD.GMD_LCF_EXTERNAL_COST
Subobject Name:
Status:	VALID

Source for, external cost values

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item
COST_ORGANIZATION_ID	NUMBER		Yes	Cost Source Organization
LAB_ORGANIZATION_ID	NUMBER		Yes	Laboratory Organization
QUANTITY	NUMBER			Quantity of the item
LOT_NUMBER	VARCHAR2	(80)		Lot Number
UOM	VARCHAR2	(3)		Unit of Measure for the item
UNIT_COST	NUMBER		Yes	Cost of the each Unit
FROM_DATE	DATE			From Date
TO_DATE	DATE			To Date
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT INVENTORY_ITEM_ID
,      COST_ORGANIZATION_ID
,      LAB_ORGANIZATION_ID
,      QUANTITY
,      LOT_NUMBER
,      UOM
,      UNIT_COST
,      FROM_DATE
,      TO_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM GMD.GMD_LCF_EXTERNAL_COST;

Dependencies

[top of page]

GMD.GMD_LCF_EXTERNAL_COST does not reference any database object

GMD.GMD_LCF_EXTERNAL_COST is referenced by following:

APPS: GMD_LCF_EXTERNAL_COST