207: ,DEL_ORGANIZATION_ID IN NUMBER
208: ,DELIVERY_ID1 IN NUMBER) RETURN CHAR IS
209: L_CARRIER VARCHAR2(35);
210: L_COUNT NUMBER;
211: L_SHIP_METHOD_CODE WSH_TRIPS.SHIP_METHOD_CODE%TYPE;
212: L_TRIP_PRESENT BOOLEAN := FALSE;
213: L_SHIP_METHOD_MEANING VARCHAR2(50);
214: BEGIN
215: /*SRW.REFERENCE(CARRIER_NAME)*/NULL;
240: SELECT
241: WT.SHIP_METHOD_CODE
242: INTO L_SHIP_METHOD_CODE
243: FROM
244: WSH_TRIPS WT,
245: WSH_TRIP_STOPS WTS,
246: WSH_DELIVERY_ASSIGNMENTS_V WDA,
247: WSH_DELIVERY_LEGS WDL
248: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID