DBA Data[Home] [Help] [Dependency Information]


TABLE: GMD.GMD_MASS_RESULTS_GT

Object Details
Object Name: GMD_MASS_RESULTS_GT
Object Type: TABLE
Owner: GMD
FND Design Data: TableGMD.GMD_MASS_RESULTS_GT
Subobject Name:
Status: VALID

Temporary Table Details

GMD.GMD_MASS_RESULTS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
SAMPLING_EVENT_ID NUMBER

SAMPLE_ACTIVE_CNT NUMBER

SAMPLE_ID NUMBER

SAMPLE_NO VARCHAR2 (80)
SAMPLE_DESC VARCHAR2 (240)
ITEM_ID NUMBER

LOCATION VARCHAR2 (30)
LOT_ID NUMBER

LOT_NO VARCHAR2 (32)
SOURCE VARCHAR2 (2)
WHSE_CODE VARCHAR2 (4)
ORGN_CODE VARCHAR2 (4)
SUBLOT_NO VARCHAR2 (32)
SOURCE_WHSE VARCHAR2 (4)
SOURCE_LOCATION VARCHAR2 (30)
RESOURCES VARCHAR2 (30)
SAMPLE_TYPE VARCHAR2 (2)
UPDATE_INSTANCE_ID NUMBER

RESULT_ID NUMBER

TEST_ID NUMBER

TEST_METHOD_ID NUMBER

TEST_REPLICATE_CNT NUMBER

TEST_QTY NUMBER

TEST_UOM VARCHAR2 (4)
QC_LAB_ORGN_CODE VARCHAR2 (4)
RESULT_VALUE_NUM NUMBER

RESULT_DATE DATE

TESTER_ID NUMBER

SEQ NUMBER

RESULT_VALUE_CHAR VARCHAR2 (80)
LAST_UPDATE_DATE DATE

EVALUATION_IND VARCHAR2 (2)
ACTION_CODE VARCHAR2 (32)
IN_SPEC_IND VARCHAR2 (2)
ADDITIONAL_TEST_IND VARCHAR2 (2)
VALUE_IN_REPORT_PRECISION NUMBER

EVENT_SPEC_DISP_ID NUMBER

SPEC_ID NUMBER

SPEC_VR_ID NUMBER

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)
TEST_REPLICATE NUMBER

OUT_OF_SPEC_ACTION VARCHAR2 (32)
EXP_ERROR_TYPE VARCHAR2 (2)
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 (2)
DISPLAY_PRECISION NUMBER

REPORT_PRECISION NUMBER

TEST_CODE VARCHAR2 (80)
TEST_DESC VARCHAR2 (240)
TEST_CLASS VARCHAR2 (80)
TEST_TYPE VARCHAR2 (2)
TEST_UNIT VARCHAR2 (25)
TEST_MIN_VALUE_NUM NUMBER

TEST_MAX_VALUE_NUM NUMBER

EXPRESSION VARCHAR2 (4000)
TEST_METHOD_CODE VARCHAR2 (80)
TEST_METHOD_DESC VARCHAR2 (240)
TEST_SELECTED NUMBER (1)
UPDATE_ALLOWED NUMBER (1)
RECORD_UPDATED NUMBER (1)
INVENTORY_ITEM_ID NUMBER

LOT_NUMBER VARCHAR2 (80)
SUBINVENTORY VARCHAR2 (10)
ORGANIZATION_CODE VARCHAR2 (3)
SOURCE_SUBINVENTORY VARCHAR2 (10)
ORGANIZATION_ID NUMBER

LAB_ORGANIZATION_ID NUMBER

LOCATOR_ID NUMBER

TEST_QTY_UOM VARCHAR2 (3)
SOURCE_LOCATOR_ID NUMBER

PARENT_LOT_NUMBER VARCHAR2 (80)
Query Text

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


SELECT SAMPLING_EVENT_ID
,      SAMPLE_ACTIVE_CNT
,      SAMPLE_ID
,      SAMPLE_NO
,      SAMPLE_DESC
,      ITEM_ID
,      LOCATION
,      LOT_ID
,      LOT_NO
,      SOURCE
,      WHSE_CODE
,      ORGN_CODE
,      SUBLOT_NO
,      SOURCE_WHSE
,      SOURCE_LOCATION
,      RESOURCES
,      SAMPLE_TYPE
,      UPDATE_INSTANCE_ID
,      RESULT_ID
,      TEST_ID
,      TEST_METHOD_ID
,      TEST_REPLICATE_CNT
,      TEST_QTY
,      TEST_UOM
,      QC_LAB_ORGN_CODE
,      RESULT_VALUE_NUM
,      RESULT_DATE
,      TESTER_ID
,      SEQ
,      RESULT_VALUE_CHAR
,      LAST_UPDATE_DATE
,      EVALUATION_IND
,      ACTION_CODE
,      IN_SPEC_IND
,      ADDITIONAL_TEST_IND
,      VALUE_IN_REPORT_PRECISION
,      EVENT_SPEC_DISP_ID
,      SPEC_ID
,      SPEC_VR_ID
,      MIN_VALUE_NUM
,      TARGET_VALUE_NUM
,      MAX_VALUE_NUM
,      MIN_VALUE_CHAR
,      TARGET_VALUE_CHAR
,      MAX_VALUE_CHAR
,      TEST_REPLICATE
,      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
,      BELOW_MAX_ACTION_CODE
,      ABOVE_MAX_ACTION_CODE
,      OPTIONAL_IND
,      DISPLAY_PRECISION
,      REPORT_PRECISION
,      TEST_CODE
,      TEST_DESC
,      TEST_CLASS
,      TEST_TYPE
,      TEST_UNIT
,      TEST_MIN_VALUE_NUM
,      TEST_MAX_VALUE_NUM
,      EXPRESSION
,      TEST_METHOD_CODE
,      TEST_METHOD_DESC
,      TEST_SELECTED
,      UPDATE_ALLOWED
,      RECORD_UPDATED
,      INVENTORY_ITEM_ID
,      LOT_NUMBER
,      SUBINVENTORY
,      ORGANIZATION_CODE
,      SOURCE_SUBINVENTORY
,      ORGANIZATION_ID
,      LAB_ORGANIZATION_ID
,      LOCATOR_ID
,      TEST_QTY_UOM
,      SOURCE_LOCATOR_ID
,      PARENT_LOT_NUMBER
FROM GMD.GMD_MASS_RESULTS_GT;

Dependencies

[top of page]

GMD.GMD_MASS_RESULTS_GT does not reference any database object

GMD.GMD_MASS_RESULTS_GT is referenced by following:

SchemaAPPS
SynonymGMD_MASS_RESULTS_GT