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_FORMULA_ANALYSIS_DTL

Object Details

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

Formula analysis detail table

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
FORMULA_ID	NUMBER		Yes	Formula for which analysis has been run.
ORGN_CODE	VARCHAR2	(4)		Organization under which analysis was run.
ITEM_ID	NUMBER			Item involved in the formula analysis.
TECHNICAL_CLASS	VARCHAR2	(240)	Yes	Item involved in the formula analysis.
TECHNICAL_SUB_CLASS	VARCHAR2	(240)	Yes	Technical Sub Class of item.
DIRECT_WEIGHT	NUMBER		Yes	Direct contribution of item in the formula in MASS uom type.
DIRECT_WEIGHT_PERCENT	NUMBER		Yes	Direct contribution in percent of item in the formula in MASS uom type.
INDIRECT_WEIGHT	NUMBER		Yes	Indirect contribution of item in the formula in MASS uom type.
INDIRECT_WEIGHT_PERCENT	NUMBER		Yes	Indirect contribution in percent of item in the formula in MASS uom type.
DIRECT_VOLUME	NUMBER		Yes	Direct contribution of item in the formula in VOLUME uom type.
DIRECT_VOLUME_PERCENT	NUMBER		Yes	Direct contribution in percent of item in the formula in VOLUME uom type.
INDIRECT_VOLUME	NUMBER		Yes	Indirect contribution of item in the formula in VOLUME uom type.
INDIRECT_VOLUME_PERCENT	NUMBER		Yes	Indirect contribution in percent of item in the formula in VOLUME uom type.
ORGANIZATION_ID	NUMBER	(15)	Yes	This is the inv organization ID
LABORATORY_ID	NUMBER	(15)		This is the inv laboratory id
INVENTORY_ITEM_ID	NUMBER	(15)	Yes	This is the inv item id
LINE_NO	NUMBER	(10)		added line number to table GMD_FORMULA_ANALYSIS_DTL

Query Text

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


SELECT FORMULA_ID
,      ORGN_CODE
,      ITEM_ID
,      TECHNICAL_CLASS
,      TECHNICAL_SUB_CLASS
,      DIRECT_WEIGHT
,      DIRECT_WEIGHT_PERCENT
,      INDIRECT_WEIGHT
,      INDIRECT_WEIGHT_PERCENT
,      DIRECT_VOLUME
,      DIRECT_VOLUME_PERCENT
,      INDIRECT_VOLUME
,      INDIRECT_VOLUME_PERCENT
,      ORGANIZATION_ID
,      LABORATORY_ID
,      INVENTORY_ITEM_ID
,      LINE_NO
FROM GMD.GMD_FORMULA_ANALYSIS_DTL;

Dependencies

[top of page]

GMD.GMD_FORMULA_ANALYSIS_DTL does not reference any database object

GMD.GMD_FORMULA_ANALYSIS_DTL is referenced by following:

GMD: GMD_FORMULA_ANALYSIS_DTL#