DBA Data[Home] [Help]

APPS.GMD_TECH_PARAMS dependencies on GMD_TESTS

Line 290: FROM lm_tech_hdr t, lm_prlt_asc p, gmd_tests q

286:
287: CURSOR Cur_lm_tp IS
288: SELECT t.orgn_code lab_type, t.tech_parm_name, p.sort_seq, t.expression_char,
289: t.data_type, t.lm_unit_code, q.orgn_code, q.assay_code
290: FROM lm_tech_hdr t, lm_prlt_asc p, gmd_tests q
291: WHERE t.orgn_code = p_lab_type
292: AND p.orgn_code = t.orgn_code
293: AND t.tech_parm_name = p.tech_parm_name
294: AND t.qcassy_typ_id = q.qcassy_typ_id(+)

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