APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_SUPPLIER_SPEC_VRS

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

1005:
1006: /* Bug 3473559; Added Hint for spec_id */
1007:
1008: CURSOR cr_match_spec IS
1009: SELECT /*+ INDEX ( b gmd_supplier_spec_vrs_n1) */
1010: a.spec_id,b.spec_vr_id,a.revision,a.grade_code,
1011: decode(a.grade_code,p_supplier_spec_rec.grade_code,1,2),b.po_line_id,
1012: b.po_header_id,b.supplier_site_id,b.supplier_id
1013: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b

Line 1013: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b

1009: SELECT /*+ INDEX ( b gmd_supplier_spec_vrs_n1) */
1010: a.spec_id,b.spec_vr_id,a.revision,a.grade_code,
1011: decode(a.grade_code,p_supplier_spec_rec.grade_code,1,2),b.po_line_id,
1012: b.po_header_id,b.supplier_site_id,b.supplier_id
1013: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b
1014: WHERE
1015: a.inventory_item_id = p_supplier_spec_rec.inventory_item_id
1016: AND ((p_supplier_spec_rec.revision = a.revision) OR ( p_supplier_spec_rec.revision IS NULL AND a.revision IS NULL)
1017: OR (p_supplier_spec_rec.revision IS NOT NULL AND a.revision IS NULL ))