VIEW: APPS.PMIBV_QCRESULT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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