APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on GMD_CUSTOMER_SPEC_VRS

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

313: /* Bug 3473559; Added Hint for spec_id */
314: -- Bug 3934121; Removed spec_status from Where clause
315:
316: CURSOR cr_match_spec IS
317: SELECT /*+ INDEX (b gmd_customer_spec_vrs_n1 ) */
318: a.spec_id,b.spec_vr_id,a.grade grade,DECODE(a.grade,p_customer_spec_rec.grade,1,2) grade_order_by,b.order_line_id,b.order_line,b.order_id,b.ship_to_site_id,b.org_id,DECODE(b.orgn_code,l_orgn_code,1,NULL,2,3) orgn_code_order_by,b.orgn_code
319: FROM gmd_specifications_b a,gmd_customer_spec_vrs b
320: WHERE
321: a.item_id = p_customer_spec_rec.item_id

Line 319: FROM gmd_specifications_b a,gmd_customer_spec_vrs b

315:
316: CURSOR cr_match_spec IS
317: SELECT /*+ INDEX (b gmd_customer_spec_vrs_n1 ) */
318: a.spec_id,b.spec_vr_id,a.grade grade,DECODE(a.grade,p_customer_spec_rec.grade,1,2) grade_order_by,b.order_line_id,b.order_line,b.order_id,b.ship_to_site_id,b.org_id,DECODE(b.orgn_code,l_orgn_code,1,NULL,2,3) orgn_code_order_by,b.orgn_code
319: FROM gmd_specifications_b a,gmd_customer_spec_vrs b
320: WHERE
321: a.item_id = p_customer_spec_rec.item_id
322: AND a.delete_mark = 0
323: AND ((l_check_for_given_grade = 'Y' and p_customer_spec_rec.grade = a.grade )