[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:	GMD.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:
PCT Free:	10
PCT Used:	40

Columns

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:

APPS

GMD_MASS_RESULTS_GT