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.

VIEW: APPS.PMIBV_QC_MATCH_DTL_V

Source

View Text - Preformatted


SELECT res.assay_code AS Assay_Code, res.num_result AS Num_Result, res.text_result AS Text_Result, res.final_mark AS Final_Mark, res.accept_anyway AS Accept_Anyway, spec.min_spec AS Min_Spec, spec.max_spec AS Max_Spec, spec.text_spec AS Text_Spec, spec.target_spec AS Target_Spec, spec.qcunit_code AS Quality_Control_Unit_Code, res.sample_id AS Sample_ID FROM qc_spec_mst spec, qc_rslt_mst res WHERE res.qc_spec_id = spec.qc_spec_id AND res.assay_code = spec.assay_code

View Text - HTML Formatted

SELECT RES.ASSAY_CODE AS ASSAY_CODE
, RES.NUM_RESULT AS NUM_RESULT
, RES.TEXT_RESULT AS TEXT_RESULT
, RES.FINAL_MARK AS FINAL_MARK
, RES.ACCEPT_ANYWAY AS ACCEPT_ANYWAY
, SPEC.MIN_SPEC AS MIN_SPEC
, SPEC.MAX_SPEC AS MAX_SPEC
, SPEC.TEXT_SPEC AS TEXT_SPEC
, SPEC.TARGET_SPEC AS TARGET_SPEC
, SPEC.QCUNIT_CODE AS QUALITY_CONTROL_UNIT_CODE
, RES.SAMPLE_ID AS SAMPLE_ID
FROM QC_SPEC_MST SPEC
, QC_RSLT_MST RES
WHERE RES.QC_SPEC_ID = SPEC.QC_SPEC_ID
AND RES.ASSAY_CODE = SPEC.ASSAY_CODE