APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_SUPPLIER_SPEC_VRS

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

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

Line 1016: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b

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