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

VIEW: APPS.PMIBV_QC_MATCH_DTL_V

Object Details
Object Name: PMIBV_QC_MATCH_DTL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMIBV_QC_MATCH_DTL_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


QC Specification and results matching Base view


[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSAY_CODE VARCHAR2 (16) Yes QC Assay Code
NUM_RESULT NUMBER

Numeric Result
TEXT_RESULT VARCHAR2 (16)
Text Result
FINAL_MARK NUMBER (5) Yes Final Mark
ACCEPT_ANYWAY NUMBER (5) Yes Accept Anyway
MIN_SPEC NUMBER

MIN Value for numeric Assays
MAX_SPEC NUMBER

MAX Value for numeric Assays
TEXT_SPEC VARCHAR2 (16)
Text Specification
TARGET_SPEC NUMBER

Target Specification
QUALITY_CONTROL_UNIT_CODE VARCHAR2 (4) Yes Quality Control Unit Code
SAMPLE_ID NUMBER (10) Yes Sample ID
Query Text

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


SELECT ASSAY_CODE
,      NUM_RESULT
,      TEXT_RESULT
,      FINAL_MARK
,      ACCEPT_ANYWAY
,      MIN_SPEC
,      MAX_SPEC
,      TEXT_SPEC
,      TARGET_SPEC
,      QUALITY_CONTROL_UNIT_CODE
,      SAMPLE_ID
FROM APPS.PMIBV_QC_MATCH_DTL_V;

Dependencies

[top of page]

APPS.PMIBV_QC_MATCH_DTL_V references the following:

SchemaAPPS
SynonymQC_RSLT_MST
SynonymQC_SPEC_MST

APPS.PMIBV_QC_MATCH_DTL_V is not referenced by any database object