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.

[Home] [Help]

VIEW: GMD.GMD_QUALITY_CONFIG#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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