APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_CUSTOMER_SPEC_VRS

Line 304: SELECT /*+ INDEX (b gmd_customer_spec_vrs_n1 ) */

300:
301: /* Bug 3473559; Added Hint for spec_id */
302:
303: CURSOR cr_match_spec IS
304: SELECT /*+ INDEX (b gmd_customer_spec_vrs_n1 ) */
305: a.spec_id,b.spec_vr_id,a.revision,a.grade_code ,DECODE(a.grade_code,p_customer_spec_rec.grade_code,1,2) grade_order_by,
306: b.order_line_id,b.order_line,b.order_id,b.ship_to_site_id,b.org_id
307: FROM gmd_specifications_b a,gmd_customer_spec_vrs b
308: WHERE

Line 307: FROM gmd_specifications_b a,gmd_customer_spec_vrs b

303: CURSOR cr_match_spec IS
304: SELECT /*+ INDEX (b gmd_customer_spec_vrs_n1 ) */
305: a.spec_id,b.spec_vr_id,a.revision,a.grade_code ,DECODE(a.grade_code,p_customer_spec_rec.grade_code,1,2) grade_order_by,
306: b.order_line_id,b.order_line,b.order_id,b.ship_to_site_id,b.org_id
307: FROM gmd_specifications_b a,gmd_customer_spec_vrs b
308: WHERE
309: a.inventory_item_id = p_customer_spec_rec.inventory_item_id
310: AND ((p_customer_spec_rec.revision = a.revision) OR ( p_customer_spec_rec.revision IS NULL AND a.revision IS NULL)
311: OR (p_customer_spec_rec.revision IS NOT NULL AND a.revision IS NULL ))