APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on GMD_SUPPLIER_SPEC_VRS

Line 1024: SELECT /*+ INDEX ( b gmd_supplier_spec_vrs_n1) */

1020: /* Bug 3473559; Added Hint for spec_id */
1021: -- Bug 3934121; Removed spec_status from Where clause
1022:
1023: CURSOR cr_match_spec IS
1024: SELECT /*+ INDEX ( b gmd_supplier_spec_vrs_n1) */
1025: a.spec_id,b.spec_vr_id,a.grade,
1026: decode(a.grade,p_supplier_spec_rec.grade,1,2),b.po_line_id,
1027: b.po_header_id,b.supplier_site_id,b.supplier_id,b.orgn_code
1028: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b

Line 1028: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b

1024: SELECT /*+ INDEX ( b gmd_supplier_spec_vrs_n1) */
1025: a.spec_id,b.spec_vr_id,a.grade,
1026: decode(a.grade,p_supplier_spec_rec.grade,1,2),b.po_line_id,
1027: b.po_header_id,b.supplier_site_id,b.supplier_id,b.orgn_code
1028: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b
1029: WHERE
1030: a.item_id = p_supplier_spec_rec.item_id
1031: AND a.delete_mark = 0
1032: AND ((l_check_for_given_grade = 'Y' and p_supplier_spec_rec.grade = a.grade )