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]

VIEW: APPS.GMD_SPEC_TESTS_VL

Object Details

Object Name:	GMD_SPEC_TESTS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMD.GMD_SPEC_TESTS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

OPM Specification tests View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
SPEC_ID	NUMBER		Yes	Specification Identification
TEST_ID	NUMBER		Yes	Test Identification
TEST_METHOD_ID	NUMBER		Yes	Test Method Identification
SEQ	NUMBER		Yes	Test sequence
TEST_QTY	NUMBER			Qty of sample required to perform test.
TEST_QTY_UOM	VARCHAR2	(3)		test quantity uom
MIN_VALUE_NUM	NUMBER			Min target value for numeric range test type
TARGET_VALUE_NUM	NUMBER			Test target value.
MAX_VALUE_NUM	NUMBER			Max target value for numeric range test type
MIN_VALUE_CHAR	VARCHAR2	(16)		Min target value for text range test type
TARGET_VALUE_CHAR	VARCHAR2	(16)		Target value for Test when test type is LOV or text range
MAX_VALUE_CHAR	VARCHAR2	(16)		Max target value for text range test type
TEST_REPLICATE	NUMBER		Yes	The number of times a test is repeated for the same sample instance. Defaults to 1
CHECK_RESULT_INTERVAL	NUMBER			Frequency result values are checked for out-of-spec condition.
PRINT_ON_COA_IND	VARCHAR2	(1)		Print on Cerificate of analysis
USE_TO_CONTROL_STEP	VARCHAR2	(1)		Use to control step
OUT_OF_SPEC_ACTION	VARCHAR2	(32)		Out of Specification action
EXP_ERROR_TYPE	VARCHAR2	(1)		NUM = Number PCT = Percent
BELOW_SPEC_MIN	NUMBER			Below Specification Minimum
ABOVE_SPEC_MIN	NUMBER			above Specification Minimum
BELOW_SPEC_MAX	NUMBER			Below Specification Maximum
ABOVE_SPEC_MAX	NUMBER			Above Specification maximum
BELOW_MIN_ACTION_CODE	VARCHAR2	(32)		Action code for results In the test error region spec min - test error
ABOVE_MIN_ACTION_CODE	VARCHAR2	(32)		Action code for results In the test error region spec min + test error
OPTIONAL_IND	VARCHAR2	(1)		Indicates if a test is optional.Y = YesNull = No
DISPLAY_PRECISION	NUMBER	(2)		Decimal precision of saved value
REPORT_PRECISION	NUMBER	(2)		Decimal precision used to display value
TEST_PRIORITY	VARCHAR2	(2)	Yes	Test priority H = HighN = Normal L = Low
RETEST_LOT_EXPIRY_IND	VARCHAR2	(1)		Indicates spec is used to retest for lot expiration, etc.Y = Yes
PRINT_SPEC_IND	VARCHAR2	(1)		Print Specification indicator
PRINT_RESULT_IND	VARCHAR2	(1)		Print Result indicator
BELOW_MAX_ACTION_CODE	VARCHAR2	(32)		Action code for results In the test error region spec max - test error
ABOVE_MAX_ACTION_CODE	VARCHAR2	(32)		Action code for results In the test error region spec max + test error
TEST_DISPLAY	VARCHAR2	(240)
TEXT_CODE	NUMBER	(10)		Edit text code
VIABILITY_DURATION	NUMBER			Total Sample Viability for Test
DAYS	NUMBER	(10)		Sample viability for the test in number of days
HOURS	NUMBER	(10)		Sample viability for the test in number of hours
MINUTES	NUMBER	(10)		Sample viability for the test in number of minutes
SECONDS	NUMBER	(10)		Sample viability for the test in number of seconds
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure ID
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flexfield column
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flexfield column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
FROM_BASE_IND	VARCHAR2	(1)		Indicator for test from base spec
EXCLUDE_IND	VARCHAR2	(1)		Indicator if the test is excluded from base spec
MODIFIED_IND	VARCHAR2	(1)		Indicator if the test is modified from base spec
CALC_UOM_CONV_IND	VARCHAR2	(1)		Indicates whether to calculate UOM Conversion based on the result of the test.
TO_QTY_UOM	VARCHAR2	(3)		TO QTY UOM

Query Text

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


SELECT ROW_ID
,      SPEC_ID
,      TEST_ID
,      TEST_METHOD_ID
,      SEQ
,      TEST_QTY
,      TEST_QTY_UOM
,      MIN_VALUE_NUM
,      TARGET_VALUE_NUM
,      MAX_VALUE_NUM
,      MIN_VALUE_CHAR
,      TARGET_VALUE_CHAR
,      MAX_VALUE_CHAR
,      TEST_REPLICATE
,      CHECK_RESULT_INTERVAL
,      PRINT_ON_COA_IND
,      USE_TO_CONTROL_STEP
,      OUT_OF_SPEC_ACTION
,      EXP_ERROR_TYPE
,      BELOW_SPEC_MIN
,      ABOVE_SPEC_MIN
,      BELOW_SPEC_MAX
,      ABOVE_SPEC_MAX
,      BELOW_MIN_ACTION_CODE
,      ABOVE_MIN_ACTION_CODE
,      OPTIONAL_IND
,      DISPLAY_PRECISION
,      REPORT_PRECISION
,      TEST_PRIORITY
,      RETEST_LOT_EXPIRY_IND
,      PRINT_SPEC_IND
,      PRINT_RESULT_IND
,      BELOW_MAX_ACTION_CODE
,      ABOVE_MAX_ACTION_CODE
,      TEST_DISPLAY
,      TEXT_CODE
,      VIABILITY_DURATION
,      DAYS
,      HOURS
,      MINUTES
,      SECONDS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FROM_BASE_IND
,      EXCLUDE_IND
,      MODIFIED_IND
,      CALC_UOM_CONV_IND
,      TO_QTY_UOM
FROM APPS.GMD_SPEC_TESTS_VL;

Dependencies

[top of page]

APPS.GMD_SPEC_TESTS_VL references the following:

APPS: GMD_SPEC_TESTS_B; GMD_SPEC_TESTS_TL

APPS.GMD_SPEC_TESTS_VL is referenced by following:

APPS: GMD_SPEC_TESTS