[Home] [Help] [Dependency Information]
Object Name: | GMD_QUALITY_CONFIG |
---|---|
Object Type: | TABLE |
Owner: | GMD |
FND Design Data: | GMD.GMD_QUALITY_CONFIG |
Subobject Name: | |
Status: | VALID |
OPM Quality Configuration
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
GMD.GMD_QUALITY_CONFIG does not reference any database object
GMD.GMD_QUALITY_CONFIG is referenced by following:
|
|
|