[Home] [Help] [Dependency Information]
Object Name: | GMD_TESTS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMD.GMD_TESTS_VL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
MultiLingual view (a language resolved view of the data.)
Qulaity testing view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
QCASSY_TYP_ID | NUMBER | (15) | Yes | |
ORGN_CODE | VARCHAR2 | (4) | ||
ASSAY_CODE | VARCHAR2 | (16) | Yes | |
ASSAY_DESC | VARCHAR2 | (40) | Yes | |
ASSAY_TYPE | NUMBER | (5) | Yes | |
QCUNIT_CODE | VARCHAR2 | (4) | Yes | |
TEST_OPRN_ID | NUMBER | (10) | ||
TEST_OPRN_LINE_ID | NUMBER | (10) | ||
TEST_PROVIDER_CODE | VARCHAR2 | (8) | ||
MIN_VALID | NUMBER | |||
MAX_VALID | NUMBER | |||
DELETE_MARK | NUMBER | (5) | Yes | |
TEXT_CODE | NUMBER | (10) | ||
IN_USE | NUMBER | (10) | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
ASSAY_CLASS | VARCHAR2 | (8) | ||
POTENCY_UOM | VARCHAR2 | (25) | ||
ATTRIBUTE1 | VARCHAR2 | (240) | ||
ATTRIBUTE2 | VARCHAR2 | (240) | ||
ATTRIBUTE3 | VARCHAR2 | (240) | ||
ATTRIBUTE4 | VARCHAR2 | (240) | ||
ATTRIBUTE5 | VARCHAR2 | (240) | ||
ATTRIBUTE6 | VARCHAR2 | (240) | ||
ATTRIBUTE7 | VARCHAR2 | (240) | ||
ATTRIBUTE8 | VARCHAR2 | (240) | ||
ATTRIBUTE9 | VARCHAR2 | (240) | ||
ATTRIBUTE10 | VARCHAR2 | (240) | ||
ATTRIBUTE11 | VARCHAR2 | (240) | ||
ATTRIBUTE12 | VARCHAR2 | (240) | ||
ATTRIBUTE13 | VARCHAR2 | (240) | ||
ATTRIBUTE14 | VARCHAR2 | (240) | ||
ATTRIBUTE15 | VARCHAR2 | (240) | ||
ATTRIBUTE16 | VARCHAR2 | (240) | ||
ATTRIBUTE17 | VARCHAR2 | (240) | ||
ATTRIBUTE18 | VARCHAR2 | (240) | ||
ATTRIBUTE19 | VARCHAR2 | (240) | ||
ATTRIBUTE20 | VARCHAR2 | (240) | ||
ATTRIBUTE21 | VARCHAR2 | (240) | ||
ATTRIBUTE22 | VARCHAR2 | (240) | ||
ATTRIBUTE23 | VARCHAR2 | (240) | ||
ATTRIBUTE24 | VARCHAR2 | (240) | ||
ATTRIBUTE25 | VARCHAR2 | (240) | ||
ATTRIBUTE26 | VARCHAR2 | (240) | ||
ATTRIBUTE27 | VARCHAR2 | (240) | ||
ATTRIBUTE28 | VARCHAR2 | (240) | ||
ATTRIBUTE29 | VARCHAR2 | (240) | ||
ATTRIBUTE30 | VARCHAR2 | (240) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
OUTSIDE_SPEC_MIN | NUMBER | |||
OUTSIDE_SPEC_MAX | NUMBER | |||
INSIDE_SPEC_MIN | NUMBER | |||
INSIDE_SPEC_MAX | NUMBER | |||
ERROR_VAL_TYPE | VARCHAR2 | (30) | ||
INSIDE_MAX_ACTION_CODE | VARCHAR2 | (4) | ||
OUTSIDE_MIN_ACTION_CODE | VARCHAR2 | (4) | ||
OUTSIDE_MAX_ACTION_CODE | VARCHAR2 | (4) | ||
INSIDE_MIN_ACTION_CODE | VARCHAR2 | (4) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, QCASSY_TYP_ID
, ORGN_CODE
, ASSAY_CODE
, ASSAY_DESC
, ASSAY_TYPE
, QCUNIT_CODE
, TEST_OPRN_ID
, TEST_OPRN_LINE_ID
, TEST_PROVIDER_CODE
, MIN_VALID
, MAX_VALID
, DELETE_MARK
, TEXT_CODE
, IN_USE
, CREATION_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ASSAY_CLASS
, POTENCY_UOM
, 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
, ATTRIBUTE_CATEGORY
, OUTSIDE_SPEC_MIN
, OUTSIDE_SPEC_MAX
, INSIDE_SPEC_MIN
, INSIDE_SPEC_MAX
, ERROR_VAL_TYPE
, INSIDE_MAX_ACTION_CODE
, OUTSIDE_MIN_ACTION_CODE
, OUTSIDE_MAX_ACTION_CODE
, INSIDE_MIN_ACTION_CODE
FROM APPS.GMD_TESTS_VL;
|
|
|