173: FUNCTION ROUTSTEPTBLCFFORMULA RETURN VARCHAR2 IS
174: BEGIN
175: /*SRW.REFERENCE(ROUTSTEPTBLCP)*/NULL;
176: IF (FROM_ROUTING_STEP_NO IS NOT NULL OR TO_ROUTING_STEP_NO IS NOT NULL) THEN
177: ROUTSTEPTBLCP := (',fm_rout_dtl frd');
178: ELSE
179: --ROUTSTEPTBLCP := NULL;
180: ROUTSTEPTBLCP := ' ';
181: END IF;
494: SELECT
495: ROUTINGSTEP_NO
496: INTO ROUTSTEP
497: FROM
498: FM_ROUT_DTL
499: WHERE ROUTING_ID = ROUTING_ID_V
500: AND ROUTINGSTEP_ID = ROUTINGSTEP_ID_V;
501: RETURN (ROUTSTEP);
502: RETURN NULL;