DBA Data[Home] [Help]

APPS.GMD_TECH_PARAMS dependencies on QC_RSLT_MST

Line 630: FROM qc_rslt_mst a, gmd_tests b

626: PROCEDURE get_qc_results IS
627:
628: CURSOR Cur_get_qcvalue (V_orgn_code VARCHAR2, V_item_id NUMBER, V_assay_code VARCHAR2) IS
629: SELECT a.text_result, a.num_result
630: FROM qc_rslt_mst a, gmd_tests b
631: WHERE a.item_id = V_item_id
632: AND a.formula_id IS NULL
633: AND a.routing_id IS NULL
634: AND a.oprn_id IS NULL

Line 962: FROM qc_rslt_mst q, lm_prlt_asc s, lm_tech_hdr h

958: AND item_id = pitem_id ;
959:
960: CURSOR cur_get_qcvalue IS
961: SELECT 1
962: FROM qc_rslt_mst q, lm_prlt_asc s, lm_tech_hdr h
963: WHERE q.item_id = pitem_id
964: AND q.formula_id IS NULL
965: AND q.routing_id IS NULL
966: AND q.oprn_id IS NULL