View: PMIFV_QC_MATCH_DTL_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	QC Sepecification and results matching Full view
Implementation/DBA Data:	APPS.PMIFV_QC_MATCH_DTL_V

View Text

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
AND (( RES.ORGN_CODE IS NULL) OR ('TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(RES.ORGN_CODE) ))

Columns