APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_SPEC_TESTS_B

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

105: SELECT a.spec_id,b.spec_vr_id,a.grade_code,revision,decode(a.grade_code,
106: p_inventory_spec_rec.grade_code,1,2),
107: b.locator_id,b.subinventory,b.parent_lot_number,b.lot_number,
108: b.organization_id
109: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b , gmd_spec_tests_b c
110: WHERE
111: a.inventory_item_id = p_inventory_spec_rec.inventory_item_id
112: AND ((p_inventory_spec_rec.revision = a.revision) OR ( p_inventory_spec_rec.revision IS NULL AND a.revision IS NULL)
113: OR (p_inventory_spec_rec.revision IS NOT NULL AND a.revision IS NULL ))

Line 1248: FROM GMD_SPEC_TESTS_B gst

1244:
1245: -- pick up only required test
1246: CURSOR cr_get_req_spec_tests IS
1247: SELECT gst.test_id
1248: FROM GMD_SPEC_TESTS_B gst
1249: WHERE gst.spec_id = p_spec_id
1250: AND gst.optional_ind is NULL ;
1251:
1252: CURSOR cr_get_sample_for_lot IS