APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_WIP_SPEC_VRS

Line 559: SELECT /*+ INDEX ( b gmd_wip_spec_vrs_n1 ) */

555:
556: -- Bug 3473559; Added Hint for spec_id
557: -- Bug 4640143; Added material_detail_id
558: CURSOR cr_match_spec IS
559: SELECT /*+ INDEX ( b gmd_wip_spec_vrs_n1 ) */
560: a.spec_id,
561: b.spec_vr_id,
562: a.revision,
563: a.grade_code,

Line 580: gmd_wip_spec_vrs b

576: b.oprn_vers,
577: b.oprn_no,
578: b.organization_id
579: FROM gmd_specifications_b a,
580: gmd_wip_spec_vrs b
581: WHERE
582: a.inventory_item_id = p_wip_spec_rec.inventory_item_id
583: AND ((p_wip_spec_rec.revision = a.revision)
584: OR ( p_wip_spec_rec.revision IS NULL AND a.revision IS NULL)