APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_SPEC_TESTS_B

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

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

Line 1241: FROM GMD_SPEC_TESTS_B gst

1237:
1238: -- pick up only required test
1239: CURSOR cr_get_req_spec_tests IS
1240: SELECT gst.test_id
1241: FROM GMD_SPEC_TESTS_B gst
1242: WHERE gst.spec_id = p_spec_id
1243: AND gst.optional_ind is NULL ;
1244:
1245: CURSOR cr_get_sample_for_lot IS