Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | QC Results View |
Implementation/DBA Data: | APPS.PMIBV_QCRESULT_V |
SELECT QCRESULT.RESULT_DATE
, DECODE( QCRESULT.NUM_RESULT
, NULL
, QCRESULT.TEXT_RESULT
, QCRESULT.NUM_RESULT)
, QCRESULT.QCUNIT_CODE
, QCRESULT.ACCEPT_ANYWAY
, QCRESULT.FINAL_MARK
, QCRESULT.TEST_PROVIDER_CODE
, QCRESULT.ASSAY_TESTER
, QCRESULT.WF_RESPONSE
, QCRESULT.ASSAY_RETEST
, QCRESULT.QCASSY_TYP_ID
, QCRESULT.QC_RESULT_ID
, QCRESULT.QC_SPEC_ID
, QCRESULT.ORGN_CODE
, QCRESULT.SAMPLE_ID
, QCSMPLMST.SAMPLE_NO
, QCSMPLMST.SAMPLE_DESC
, QCSMPLMST.SAMPLE_STATUS
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING( 'GMD_SAMPLE_STATUS'
, QCSMPLMST.SAMPLE_STATUS)
, 1
, 80)
, QCRESULT.ASSAY_CODE
, QCASSYTYP.ASSAY_DESC
, QCRESULT.ITEM_ID
, QCRESULT.LOT_ID
, QCRESULT.WHSE_CODE
, QCRESULT.LOCATION
, QCRESULT.FORMULA_ID
, QCRESULT.FORMULALINE_ID
, QCRESULT.ROUTING_ID
, QCRESULT.ROUTINGSTEP_ID
, QCRESULT.OPRN_ID
, QCRESULT.CUST_ID
, QCRESULT.SHIP_TO_SITE_ID
, QCRESULT.VENDOR_ID
, QCRESULT.BATCH_ID
, QCRESULT.ROUTINGSTEP_NO
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, QCSPEC.DOC_TYPE
, QCSPEC.DOC_ID
, QCSPEC.DOCLINE_ID
, QCSPEC.CUST_SPECIFICATION
, QCSPEC.CUST_CERTIFICATION
, QCSPEC.VENDOR_SPECIFICATION
, QCSPEC.VENDOR_CERTIFICATION
, QCSPEC.TEXT_SPEC
, QCSPEC.TARGET_SPEC
, QCSPEC.MIN_SPEC
, QCSPEC.MAX_SPEC
, QCSPEC.QCUNIT_CODE
, QCSPEC.FROM_DATE
, QCSPEC.TO_DATE
, QCSPEC.OUTACTION_CODE
, QCSPEC.OUTACTION_INTERVAL
, QCSPEC.PREFERENCE
, QCSPEC.PRINT_COA_SHIPPED
, QCSPEC.PRINT_COA_INVOICED
, QCSPEC.VENDOR_COA_REQUIRED
, QCSPEC.TEST_OPRN_ID
, QCSPEC.TEST_OPRN_LINE_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, VENDOR.VENDOR_NO
, VENDOR.VENDOR_NAME
, QCRESULT.ACCEPT_ANYWAY
, LOT.LOT_NO
, LOT.SUBLOT_NO
, QCRESULT.CREATED_BY
, QCRESULT.CREATION_DATE
, QCRESULT.LAST_UPDATE_DATE
, QCRESULT.LAST_UPDATED_BY
FROM QC_RSLT_MST QCRESULT
, QC_SPEC_MST QCSPEC
, IC_ITEM_MST ITEM
, QC_SMPL_MST QCSMPLMST
, QC_ASSY_TYP QCASSYTYP
, HZ_CUST_ACCOUNTS_ALL CUST_ACCT
, HZ_PARTIES PARTY
, PO_VEND_MST VENDOR
, IC_LOTS_MST LOT
WHERE QCRESULT.QC_SPEC_ID = QCSPEC.QC_SPEC_ID(+)
AND QCRESULT.ITEM_ID = ITEM.ITEM_ID
AND QCRESULT.SAMPLE_ID = QCSMPLMST.SAMPLE_ID
AND QCRESULT.ASSAY_CODE = QCASSYTYP.ASSAY_CODE
AND QCRESULT.VENDOR_ID = VENDOR.VENDOR_ID(+)
AND QCRESULT.ITEM_ID = LOT.ITEM_ID(+)
AND QCRESULT.LOT_ID = LOT.LOT_ID(+)
AND PARTY.PARTY_ID(+) = CUST_ACCT.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID(+) = QCRESULT.CUST_ID
AND QCRESULT.DELETE_MARK = 0
AND (QCRESULT.ORGN_CODE IS NULL OR QCRESULT.ORGN_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY