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]

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

Name	Datatype	Length
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:

APPS: GMD_MASS_RESULTS_GT