APPS.FTE_FREIGHT_PRICING dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 56: SELECT count(delivery_detail_id) FROM wsh_delivery_assignments

52: WHERE delivery_leg_id = c_leg_id;
53:
54: CURSOR c_count_delivery_details(c_delivery_id NUMBER)
55: IS
56: SELECT count(delivery_detail_id) FROM wsh_delivery_assignments
57: WHERE delivery_id = c_delivery_id;
58:
59: CURSOR c_count_delivery_details2(c_trip_id NUMBER)
60: IS

Line 61: SELECT count(delivery_detail_id) FROM wsh_delivery_assignments

57: WHERE delivery_id = c_delivery_id;
58:
59: CURSOR c_count_delivery_details2(c_trip_id NUMBER)
60: IS
61: SELECT count(delivery_detail_id) FROM wsh_delivery_assignments
62: WHERE delivery_id in
63: (SELECT wdl.delivery_id
64: FROM wsh_delivery_legs wdl,
65: wsh_trip_stops wts1,

Line 8839: from wsh_delivery_details wdd, wsh_delivery_assignments wda,

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

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

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

Line 12505: from wsh_delivery_details wdd, wsh_delivery_assignments wda,

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

Line 12585: from wsh_delivery_details wdd, wsh_delivery_assignments wda,

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

Line 12947: from wsh_delivery_details wdd, wsh_delivery_assignments wda

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