DBA Data[Home] [Help]

APPS.GMD_SPEC_MATCH_GRP dependencies on FM_ROUT_DTL

Line 730: FROM fm_rout_dtl

726: EXCEPTION
727: WHEN OTHERS THEN
728: BEGIN
729: SELECT ROUTINGSTEP_NO INTO l_step_no
730: FROM fm_rout_dtl
731: WHERE routingstep_id = p_wip_spec_rec.step_id
732: AND routing_id = p_wip_spec_rec.routing_id;
733:
734: EXCEPTION WHEN OTHERS THEN

Line 741: FROM fm_rout_dtl

737: END;
738: ELSIF p_wip_spec_rec.routing_id IS NOT NULL THEN
739: BEGIN
740: SELECT ROUTINGSTEP_NO INTO l_step_no
741: FROM fm_rout_dtl
742: WHERE routingstep_id = p_wip_spec_rec.step_id
743: AND routing_id = p_wip_spec_rec.routing_id ;
744:
745: EXCEPTION