APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on GMD_SPEC_TESTS_B

Line 104: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b , gmd_spec_tests_b c

100: SELECT a.spec_id,b.spec_vr_id,a.grade,decode(a.grade,
101: p_inventory_spec_rec.grade,1,2),
102: b.location,b.whse_code,b.sublot_no,b.lot_no,
103: b.orgn_code
104: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b , gmd_spec_tests_b c
105: WHERE
106: a.item_id = p_inventory_spec_rec.item_id
107: AND a.delete_mark = 0
108: AND ((l_check_for_given_grade = 'Y' and p_inventory_spec_rec.grade = a.grade )

Line 1297: FROM GMD_SPEC_TESTS_B gst

1293:
1294: -- pick up only required test
1295: CURSOR cr_get_req_spec_tests IS
1296: SELECT gst.test_id
1297: FROM GMD_SPEC_TESTS_B gst
1298: WHERE gst.spec_id = p_spec_id
1299: AND gst.optional_ind is NULL ;
1300:
1301: CURSOR cr_get_sample_for_lot IS