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_QC_E_SPEC_TESTS_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
SPEC_ID	NUMBER		Yes
TEST_ID	NUMBER		Yes
TEST_METHOD_ID	NUMBER		Yes
SEQ	NUMBER		Yes
TEST_METHOD_CODE	VARCHAR2	(80)	Yes
TEST_REPLICATE	NUMBER		Yes
TEST_QTY	NUMBER
TEST_QTY_UOM	VARCHAR2	(3)
SPEC_MIN_VALUE	VARCHAR2	(40)
SPEC_TARGET_VALUE	VARCHAR2	(40)
SPEC_MAX_VALUE	VARCHAR2	(40)
MIN_VALUE_NUM	NUMBER
TARGET_VALUE_NUM	NUMBER
MAX_VALUE_NUM	NUMBER
MIN_VALUE_CHAR	VARCHAR2	(16)
TARGET_VALUE_CHAR	VARCHAR2	(16)
MAX_VALUE_CHAR	VARCHAR2	(16)
BELOW_SPEC_MIN	NUMBER
ABOVE_SPEC_MIN	NUMBER
BELOW_SPEC_MAX	NUMBER
ABOVE_SPEC_MAX	NUMBER
BELOW_MIN_ACTION_CODE	VARCHAR2	(32)
ABOVE_MIN_ACTION_CODE	VARCHAR2	(32)
BELOW_MAX_ACTION_CODE	VARCHAR2	(32)
ABOVE_MAX_ACTION_CODE	VARCHAR2	(32)
OPTIONAL_IND	VARCHAR2	(80)
DISPLAY_PRECISION	NUMBER	(2)
REPORT_PRECISION	NUMBER	(2)
OUT_OF_SPEC_ACTION	VARCHAR2	(32)
TEST_PRIORITY	VARCHAR2	(80)	Yes
RETEST_LOT_EXPIRY_IND	VARCHAR2	(80)
EXP_ERROR_TYPE	VARCHAR2	(80)
PRINT_SPEC_IND	VARCHAR2	(80)
PRINT_RESULT_IND	VARCHAR2	(80)
TEST_DISPLAY	VARCHAR2	(240)
TEXT_CODE	NUMBER	(10)
OUT_OF_SPEC_ACTION_DESC	VARCHAR2	(80)
OUT_OF_SPEC_ACTION_INTERVAL	NUMBER
EXPRESSION	VARCHAR2	(4000)
TEST_CODE	VARCHAR2	(80)	Yes
TEST_DESC	VARCHAR2	(240)	Yes
TEST_UNIT	VARCHAR2	(25)
TEST_TYPE	VARCHAR2	(1)	Yes
TEST_TYPE_DESC	VARCHAR2	(80)	Yes
TEST_CLASS	VARCHAR2	(8)
TEST_MIN_VALUE	NUMBER
TEST_MAX_VALUE	NUMBER
SPEC_TARGET_MEANING	VARCHAR2	(4000)
SPEC_MIN_MEANING	VARCHAR2	(4000)
SPEC_MAX_MEANING	VARCHAR2	(4000)
TEST_MIN_MEANING	VARCHAR2	(4000)
TEST_MAX_MEANING	VARCHAR2	(4000)
FROM_BASE_IND	VARCHAR2	(1)
EXCLUDE_IND	VARCHAR2	(1)
MODIFIED_IND	VARCHAR2	(1)
CALC_UOM_CONV_IND	VARCHAR2	(1)
TO_QTY_UOM	VARCHAR2	(3)

Query Text

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


SELECT SPEC_ID
,      TEST_ID
,      TEST_METHOD_ID
,      SEQ
,      TEST_METHOD_CODE
,      TEST_REPLICATE
,      TEST_QTY
,      TEST_QTY_UOM
,      SPEC_MIN_VALUE
,      SPEC_TARGET_VALUE
,      SPEC_MAX_VALUE
,      MIN_VALUE_NUM
,      TARGET_VALUE_NUM
,      MAX_VALUE_NUM
,      MIN_VALUE_CHAR
,      TARGET_VALUE_CHAR
,      MAX_VALUE_CHAR
,      BELOW_SPEC_MIN
,      ABOVE_SPEC_MIN
,      BELOW_SPEC_MAX
,      ABOVE_SPEC_MAX
,      BELOW_MIN_ACTION_CODE
,      ABOVE_MIN_ACTION_CODE
,      BELOW_MAX_ACTION_CODE
,      ABOVE_MAX_ACTION_CODE
,      OPTIONAL_IND
,      DISPLAY_PRECISION
,      REPORT_PRECISION
,      OUT_OF_SPEC_ACTION
,      TEST_PRIORITY
,      RETEST_LOT_EXPIRY_IND
,      EXP_ERROR_TYPE
,      PRINT_SPEC_IND
,      PRINT_RESULT_IND
,      TEST_DISPLAY
,      TEXT_CODE
,      OUT_OF_SPEC_ACTION_DESC
,      OUT_OF_SPEC_ACTION_INTERVAL
,      EXPRESSION
,      TEST_CODE
,      TEST_DESC
,      TEST_UNIT
,      TEST_TYPE
,      TEST_TYPE_DESC
,      TEST_CLASS
,      TEST_MIN_VALUE
,      TEST_MAX_VALUE
,      SPEC_TARGET_MEANING
,      SPEC_MIN_MEANING
,      SPEC_MAX_MEANING
,      TEST_MIN_MEANING
,      TEST_MAX_MEANING
,      FROM_BASE_IND
,      EXCLUDE_IND
,      MODIFIED_IND
,      CALC_UOM_CONV_IND
,      TO_QTY_UOM
FROM APPS.GMD_QC_E_SPEC_TESTS_V;

Dependencies

[top of page]

APPS.GMD_QC_E_SPEC_TESTS_V references the following:

APPS: FND_LOOKUP_VALUES_VL; GMD_QC_TESTS; GMD_QC_TEST_VALUES_GRP - show dependent code; GMD_SPEC_TESTS; GMD_TEST_METHODS; MTL_ACTIONS

APPS.GMD_QC_E_SPEC_TESTS_V is not referenced by any database object