APPS.FTE_FREIGHT_PRICING dependencies on WSH_DELIVERY_DETAILS

Line 8838: from wsh_delivery_details wdd, wsh_delivery_assignments wda,

8834: NULL, -- comm_category_id
8835: wda.type,
8836: wda.parent_delivery_id,
8837: wdl.parent_delivery_leg_id
8838: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
8839: wsh_new_deliveries wd,
8840: wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt
8841: where wdd.delivery_detail_id = wda.delivery_detail_id
8842: and wda.delivery_id = wdl.delivery_id

Line 8925: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_legs wdl,

8921: NULL, -- comm_category_id
8922: wda.type,
8923: wda.parent_delivery_id,
8924: wdl.parent_delivery_leg_id
8925: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_legs wdl,
8926: wsh_new_deliveries wd
8927: where wdd.delivery_detail_id = wda.delivery_detail_id
8928: and wda.delivery_id = wdl.delivery_id
8929: and wdl.delivery_id = wd.delivery_id

Line 12504: from wsh_delivery_details wdd, wsh_delivery_assignments wda,

12500: NULL, -- comm_category_id
12501: wda.type,
12502: wda.parent_delivery_id,
12503: NULL--wdl.parent_delivery_leg_id
12504: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
12505: wsh_new_deliveries wd
12506: where wdd.delivery_detail_id = wda.delivery_detail_id
12507: and wda.delivery_id = c_delivery_id
12508: and (wda.type IS null OR wda.type <> 'O')--MDC

Line 12584: from wsh_delivery_details wdd, wsh_delivery_assignments wda,

12580: NULL, -- comm_category_id
12581: wda.type,
12582: wda.parent_delivery_id,
12583: wdl.parent_delivery_leg_id
12584: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
12585: wsh_new_deliveries wd,
12586: wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt
12587: where wdd.delivery_detail_id = wda.delivery_detail_id
12588: and wda.delivery_id = wdl.delivery_id

Line 12946: from wsh_delivery_details wdd, wsh_delivery_assignments wda

12942: CURSOR c_delivery_details(c_delivery_id IN NUMBER) IS
12943: SELECT wdd.delivery_detail_id,
12944: wdd.gross_weight ,
12945: wdd.weight_uom_code
12946: from wsh_delivery_details wdd, wsh_delivery_assignments wda
12947: where wdd.delivery_detail_id = wda.delivery_detail_id
12948: and wdd.container_flag = 'N'
12949: and (wda.type IS null OR wda.type <> 'O')--MDC
12950: and wda.delivery_id = c_delivery_id;