APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on GMD_WIP_SPEC_VRS

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

611: /* Bug 3473559; Added Hint for spec_id */
612: -- Bug 3934121; Removed spec_status from Where clause
613:
614: CURSOR cr_match_spec IS
615: SELECT /*+ INDEX ( b gmd_wip_spec_vrs_n1 ) */
616: a.spec_id,b.spec_vr_id,a.grade grade,
617: DECODE(a.grade,p_wip_spec_rec.grade,1,2) grade_order_by,
618: b.charge,b.step_no,
619: b.routing_vers,b.routing_no,b.formulaline_id,

Line 622: FROM gmd_specifications_b a,gmd_wip_spec_vrs b

618: b.charge,b.step_no,
619: b.routing_vers,b.routing_no,b.formulaline_id,
620: b.formula_vers,b.formula_no,b.recipe_version,
621: b.recipe_no,b.batch_id,b.oprn_vers,b.oprn_no,b.orgn_code
622: FROM gmd_specifications_b a,gmd_wip_spec_vrs b
623: WHERE
624: a.item_id = p_wip_spec_rec.item_id
625: AND a.delete_mark = 0
626: AND ((l_check_for_given_grade = 'Y' and p_wip_spec_rec.grade = a.grade ) OR (l_check_for_null_grade = 'Y' AND a.grade IS NULL )