DBA Data[Home] [Help] [Dependency Information]

VIEW: GMD.GMD_QUALITY_CONFIG#

Object Details
Object Name: GMD_QUALITY_CONFIG#
Object Type: VIEW
Owner: GMD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGN_CODE VARCHAR2 (4)
CONTROL_BATCH_STEP_IND VARCHAR2 (1)
CONTROL_LOT_ATTRIB_IND VARCHAR2 (1)
OUT_OF_SPEC_LOT_STATUS VARCHAR2 (4)
IN_SPEC_LOT_STATUS VARCHAR2 (4)
SAMPLE_INV_TRANS_IND VARCHAR2 (1)
API_ROUND_TRUN_IND VARCHAR2 (1)
LOT_OPTIONAL_ON_SAMPLE VARCHAR2 (1)
TEXT_CODE NUMBER (10)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
INV_TRANS_REASON_CODE VARCHAR2 (4)
RESAMPLE_ACTION_CODE VARCHAR2 (32)
RETEST_ACTION_CODE VARCHAR2 (32)
CHOOSE_SPEC VARCHAR2 (1)
AUTO_SAMPLE_IND VARCHAR2 (1)
DELAYED_LOT_ENTRY VARCHAR2 (1)
ORGANIZATION_ID NUMBER

EXACT_SPEC_MATCH_IND VARCHAR2 (1)
INCLUDE_OPTIONAL_TEST_RSLT_IND VARCHAR2 (1)
IN_SPEC_LOT_STATUS_ID NUMBER

OUT_OF_SPEC_LOT_STATUS_ID NUMBER

QUALITY_LAB_IND VARCHAR2 (1)
SAMPLE_ASSIGNMENT_TYPE NUMBER (5)
SAMPLE_LAST_ASSIGNED NUMBER (10)
SPEC_VERSION_CONTROL_IND VARCHAR2 (1)
SS_ASSIGNMENT_TYPE NUMBER (5)
SS_LAST_ASSIGNED NUMBER (10)
TRANSACTION_REASON_ID NUMBER

DISTRIBUTION_ACCOUNT_ID NUMBER

MIGRATED_IND NUMBER (1)
AUTO_COMPLETE_BATCH_STEP VARCHAR2 (1)
DEFAULT_SPECIFICATION_STATUS NUMBER

MANAGE_VALIDITY_RULES_IND VARCHAR2 (1)
DELAYED_LPN_ENTRY VARCHAR2 (1)
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
,      DELAYED_LPN_ENTRY
FROM GMD.GMD_QUALITY_CONFIG#;

Dependencies

[top of page]

GMD.GMD_QUALITY_CONFIG# references the following:

SchemaGMD
TableGMD_QUALITY_CONFIG
GMD.GMD_QUALITY_CONFIG# is referenced by following:

SchemaAPPS
SynonymGMD_QUALITY_CONFIG