DBA Data[Home] [Help]

APPS.GMD_TECH_PARAMS dependencies on LM_PRLT_ASC

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 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