VIEW: APPS.PMIFV_QC_ASSAYS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'