DBA Data[Home] [Help]

APPS.WSH_FREIGHT_COSTS_PVT dependencies on WSH_DELIVERY_LEGS

Line 1830: from wsh_delivery_legs wdl, wsh_trip_stops wts

1826: where trip_id=p_tripid;
1827:
1828: cursor c_get_dels(p_tripid NUMBER) is
1829: select delivery_id
1830: from wsh_delivery_legs wdl, wsh_trip_stops wts
1831: where wdl.pick_up_stop_id=wts.stop_id
1832: and wts.trip_id=p_tripid;
1833:
1834: Cursor freight_cost_at_trip(c_trip_id number) IS

Line 2234: FROM wsh_delivery_legs wshlg, wsh_delivery_assignments_v wshda,

2230:
2231:
2232: Cursor need_reprice(c_delivery_id NUMBER) IS
2233: SELECT 1
2234: FROM wsh_delivery_legs wshlg, wsh_delivery_assignments_v wshda,
2235: wsh_new_deliveries wshnd
2236: WHERE wshlg.delivery_id = c_delivery_id AND
2237: wshlg.reprice_required = 'Y' AND
2238: wshnd.delivery_id = wshlg.delivery_id and