DBA Data[Home] [Help]

APPS.GR_TECHNICAL_PARAMETERS dependencies on GMD_QC_TESTS_B

Line 67: FROM gmd_spec_tests_b b, gmd_inventory_spec_vrs v, gmd_specifications_b s, gmd_qc_tests_b q

63:
64: /* B2564522 Changed the cursor to incorporatethe QM changes*/
65: CURSOR c_get_specs IS
66: SELECT b.min_value_num, b.max_value_num, b.target_value_num, b.target_value_char, q.test_unit
67: FROM gmd_spec_tests_b b, gmd_inventory_spec_vrs v, gmd_specifications_b s, gmd_qc_tests_b q
68: WHERE b.test_id = LocalLabRecord.qcassy_typ_id
69: AND s.inventory_item_id = p_inventory_item_id
70: AND b.spec_id = v.spec_id
71: AND s.spec_id = b.spec_id