APPS.WSH_WSHRDMBL_XMLP_PKG dependencies on WSH_DELIVERY_LEGS

Line 34: WSH_DELIVERY_LEGS WDL

30: FROM
31: WSH_SHIP_FROM_ORGS_V WSFO,
32: WSH_TRIP_STOPS WTS,
33: WSH_NEW_DELIVERIES WND,
34: WSH_DELIVERY_LEGS WDL
35: WHERE WTS.TRIP_ID = P_TRIP_ID
36: AND WTS.STOP_ID = CF_SHIPPER_NAMEFORMULA.STOP_ID
37: AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID
38: AND WND.DELIVERY_ID = WDL.DELIVERY_ID

Line 488: WSH_DELIVERY_LEGS

484: WHERE DELIVERY_ID in (
485: SELECT
486: DELIVERY_ID
487: FROM
488: WSH_DELIVERY_LEGS
489: WHERE DELIVERY_LEG_ID in (
490: SELECT
491: PARENT_DELIVERY_LEG_ID
492: FROM

Line 493: WSH_DELIVERY_LEGS

489: WHERE DELIVERY_LEG_ID in (
490: SELECT
491: PARENT_DELIVERY_LEG_ID
492: FROM
493: WSH_DELIVERY_LEGS
494: WHERE DELIVERY_LEG_ID = DELIVERY_LEG_ID_DP ) )
495: AND ROWNUM = 1;
496: END IF;
497: RETURN L_PARENT_DEL_NAME;

Line 516: WSH_DELIVERY_LEGS

512: WHERE DELIVERY_ID in (
513: SELECT
514: DELIVERY_ID
515: FROM
516: WSH_DELIVERY_LEGS
517: WHERE DELIVERY_LEG_ID in (
518: SELECT
519: PARENT_DELIVERY_LEG_ID
520: FROM

Line 521: WSH_DELIVERY_LEGS

517: WHERE DELIVERY_LEG_ID in (
518: SELECT
519: PARENT_DELIVERY_LEG_ID
520: FROM
521: WSH_DELIVERY_LEGS
522: WHERE DELIVERY_LEG_ID = DELIVERY_LEG_ID_DD ) )
523: AND ROWNUM = 1;
524: END IF;
525: RETURN L_PARENT_DEL_NAME;