View: PMIFV_QC_ASSAYS_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	QC Assays Full View
Implementation/DBA Data:	APPS.PMIFV_QC_ASSAYS_V

View Text

SELECT NVL(QA.ORGN_CODE
, LKUP.MEANING) AS ORGANIZATION_CODE
, QA.ASSAY_CODE AS ASSAY_CODE
, QA.ASSAY_DESC AS ASSAY_DESCRIPTION
, QA.ASSAY_TYPE AS ASSAY_TYPE
, QA.MIN_VALID AS MIN_VALUE
, QA.MAX_VALID AS MAX_VALUE
, QA.QCUNIT_CODE AS QUALITY_CONTROL_UNIT_CODE
, QA.DELETE_MARK AS DELETE_MARK
, QA.LAST_UPDATE_DATE AS LAST_UPDATED_DATE
, QA.LAST_UPDATED_BY AS LAST_UPDATED_BY
, QA.CREATION_DATE AS CREATION_DATE
, QA.CREATED_BY AS CREATED_BY
, VA.VALUE_DESC AS VALUE FROM QC_ASSY_TYP QA
, QC_ASSY_VAL VA
, FND_LOOKUPS LKUP
WHERE QA.ASSAY_CODE = VA.ASSAY_CODE(+)
AND QA.QCASSY_TYP_ID = VA.QCASSY_TYP_ID(+)
AND LKUP.LOOKUP_TYPE = 'PMI_GLOBAL'
AND LKUP.LOOKUP_CODE = 'GLOBAL'
AND ((QA.ORGN_CODE IS NULL) OR ('TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(QA.ORGN_CODE)))

Columns