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_QUALITY_CONFIG

Object Details

Object Name:	GMD_QUALITY_CONFIG
Object Type:	TABLE
Owner:	GMD
FND Design Data:	GMD.GMD_QUALITY_CONFIG
Subobject Name:
Status:	VALID

OPM Quality Configuration

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMD_QUALITY_CONFIG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGN_CODE
GMD_QUALITY_CONFIG_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGN_CODE	VARCHAR2	(4)		Organization
CONTROL_BATCH_STEP_IND	VARCHAR2	(1)		Batch Step Indicator
CONTROL_LOT_ATTRIB_IND	VARCHAR2	(1)		Lot Attribute Indicator
OUT_OF_SPEC_LOT_STATUS	VARCHAR2	(4)		out-Spec Lot Status
IN_SPEC_LOT_STATUS	VARCHAR2	(4)		in spec lot status
SAMPLE_INV_TRANS_IND	VARCHAR2	(1)		Sample Inventory transaction indicator
API_ROUND_TRUN_IND	VARCHAR2	(1)		Api truction or rounding
LOT_OPTIONAL_ON_SAMPLE	VARCHAR2	(1)		lot optional on sample
TEXT_CODE	NUMBER	(10)		Edit text
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
INV_TRANS_REASON_CODE	VARCHAR2	(4)		Reason code for updating inventory
RESAMPLE_ACTION_CODE	VARCHAR2	(32)		Resample Action Code
RETEST_ACTION_CODE	VARCHAR2	(32)		Retest Action Code
CHOOSE_SPEC	VARCHAR2	(1)		This column is used by samples to allow or disallow manual specification selections
AUTO_SAMPLE_IND	VARCHAR2	(1)		Auto Sample Creation Indicator
DELAYED_LOT_ENTRY	VARCHAR2	(1)		This column contains the default value which is used when creating a Spec VR
ORGANIZATION_ID	NUMBER			This is the Organization ID
EXACT_SPEC_MATCH_IND	VARCHAR2	(1)		This is whether to require an exact spec match
INCLUDE_OPTIONAL_TEST_RSLT_IND	VARCHAR2	(1)		This is whether to use optional tests results in sample disposition
IN_SPEC_LOT_STATUS_ID	NUMBER			This is the in-spec-status indicator
OUT_OF_SPEC_LOT_STATUS_ID	NUMBER			This is the out-of-spec status indicator
QUALITY_LAB_IND	VARCHAR2	(1)		This is the Quality Lab Indicator
SAMPLE_ASSIGNMENT_TYPE	NUMBER	(5)		This is the sample number generation type
SAMPLE_LAST_ASSIGNED	NUMBER	(10)		This is the last assigned sample number
SPEC_VERSION_CONTROL_IND	VARCHAR2	(1)		This is whether there is spec version control
SS_ASSIGNMENT_TYPE	NUMBER	(5)		This is the stability study number generation type
SS_LAST_ASSIGNED	NUMBER	(10)		This is the last stability study number
TRANSACTION_REASON_ID	NUMBER			This is the Transaction Reason ID
DISTRIBUTION_ACCOUNT_ID	NUMBER			This is Distribution Account ID
MIGRATED_IND	NUMBER	(1)		Indicates Status of the Migration of this table
AUTO_COMPLETE_BATCH_STEP	VARCHAR2	(1)		Auto Complete Batch Step Indicator
DEFAULT_SPECIFICATION_STATUS	NUMBER			Status of new specification version when created through Mass Search and Replace
MANAGE_VALIDITY_RULES_IND	VARCHAR2	(1)		Indicated handling of validity rules when a new specification version is created through Mass Search and Replace

Query Text

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


SELECT ORGN_CODE
,      CONTROL_BATCH_STEP_IND
,      CONTROL_LOT_ATTRIB_IND
,      OUT_OF_SPEC_LOT_STATUS
,      IN_SPEC_LOT_STATUS
,      SAMPLE_INV_TRANS_IND
,      API_ROUND_TRUN_IND
,      LOT_OPTIONAL_ON_SAMPLE
,      TEXT_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      INV_TRANS_REASON_CODE
,      RESAMPLE_ACTION_CODE
,      RETEST_ACTION_CODE
,      CHOOSE_SPEC
,      AUTO_SAMPLE_IND
,      DELAYED_LOT_ENTRY
,      ORGANIZATION_ID
,      EXACT_SPEC_MATCH_IND
,      INCLUDE_OPTIONAL_TEST_RSLT_IND
,      IN_SPEC_LOT_STATUS_ID
,      OUT_OF_SPEC_LOT_STATUS_ID
,      QUALITY_LAB_IND
,      SAMPLE_ASSIGNMENT_TYPE
,      SAMPLE_LAST_ASSIGNED
,      SPEC_VERSION_CONTROL_IND
,      SS_ASSIGNMENT_TYPE
,      SS_LAST_ASSIGNED
,      TRANSACTION_REASON_ID
,      DISTRIBUTION_ACCOUNT_ID
,      MIGRATED_IND
,      AUTO_COMPLETE_BATCH_STEP
,      DEFAULT_SPECIFICATION_STATUS
,      MANAGE_VALIDITY_RULES_IND
FROM GMD.GMD_QUALITY_CONFIG;

Dependencies

[top of page]

GMD.GMD_QUALITY_CONFIG does not reference any database object

GMD.GMD_QUALITY_CONFIG is referenced by following:

APPS: GMD_QUALITY_CONFIG