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_LAB_FORMULA_ASSOC

Object Details

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

Association for lab values that get converted to formulas

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
OLD_FORMULA_ID	NUMBER		Old formula id
OLD_FORMULA_NO	VARCHAR2	(32)	Old Formula number
OLD_FORMULA_VERS	NUMBER		old formula version
NEW_FORMULA_VERS	NUMBER		New formula version
MIGRATED	VARCHAR2	(3)	FLag indicatind sucessful migration
OLD_TP_FORMULA_ID	NUMBER		Id for old technical parameter based formula id
NEW_TP_FORMULA_ID	NUMBER		Id for new technical parameter based formula id
NEW_FORMULA_ID	NUMBER		New formula id
NEW_FORMULA_NO	VARCHAR2	(32)	New formula version

Query Text

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


SELECT OLD_FORMULA_ID
,      OLD_FORMULA_NO
,      OLD_FORMULA_VERS
,      NEW_FORMULA_VERS
,      MIGRATED
,      OLD_TP_FORMULA_ID
,      NEW_TP_FORMULA_ID
,      NEW_FORMULA_ID
,      NEW_FORMULA_NO
FROM GMD.GMD_LAB_FORMULA_ASSOC;

Dependencies

[top of page]

GMD.GMD_LAB_FORMULA_ASSOC does not reference any database object

GMD.GMD_LAB_FORMULA_ASSOC is referenced by following:

APPS: GMD_LAB_FORMULA_ASSOC