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: GR.GR_ITEM_CONC_DETAILS

Object Details

Object Name:	GR_ITEM_CONC_DETAILS
Object Type:	TABLE
Owner:	GR
FND Design Data:	GR.GR_ITEM_CONC_DETAILS
Subobject Name:
Status:	VALID

A temporary table used during the document build process.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GR_ITEM_CONC_DETAILS_PK	NORMAL	UNIQUE	APPS_TS_NOLOGGING	ITEM_CODE INGREDIENT_ITEM_CODE SOURCE_ITEM_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_CODE	VARCHAR2	(32)	Yes	The Item Code for the substance used in or produced by the process.
INGREDIENT_ITEM_CODE	VARCHAR2	(32)	Yes	The Ingredient Item Code for the substance used in or produced by the process.
SOURCE_ITEM_CODE	VARCHAR2	(32)	Yes	The souce item code.
LEVEL_HIERARCHY_CODE	NUMBER	(10)	Yes	Not yet available
WORK_CONCENTRATION	NUMBER		Yes	The concentration of the ingredient in the intermediate product.
UOM	VARCHAR2	(4)	Yes	Unit of measure.
QUANTITY	NUMBER		Yes	Quantity

Query Text

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


SELECT ITEM_CODE
,      INGREDIENT_ITEM_CODE
,      SOURCE_ITEM_CODE
,      LEVEL_HIERARCHY_CODE
,      WORK_CONCENTRATION
,      UOM
,      QUANTITY
FROM GR.GR_ITEM_CONC_DETAILS;

Dependencies

[top of page]

GR.GR_ITEM_CONC_DETAILS does not reference any database object

GR.GR_ITEM_CONC_DETAILS is referenced by following:

APPS: GR_ITEM_CONC_DETAILS