APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 86: SELECT count(delivery_detail_id) FROM wsh_delivery_assignments

82: WHERE delivery_id = c_dlv;
83: --
84: CURSOR c_count_delivery_details(c_delivery_id NUMBER)
85: IS
86: SELECT count(delivery_detail_id) FROM wsh_delivery_assignments
87: WHERE (delivery_id = c_delivery_id OR parent_delivery_id= c_delivery_id);
88:
89: CURSOR c_count_delivery_details2(c_trip_id NUMBER)
90: IS

Line 91: SELECT count(delivery_detail_id) FROM wsh_delivery_assignments

87: WHERE (delivery_id = c_delivery_id OR parent_delivery_id= c_delivery_id);
88:
89: CURSOR c_count_delivery_details2(c_trip_id NUMBER)
90: IS
91: SELECT count(delivery_detail_id) FROM wsh_delivery_assignments
92: WHERE delivery_id in
93: (SELECT wdl.delivery_id
94: FROM wsh_delivery_legs wdl,
95: wsh_trip_stops wts1,

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

3377: NULL, -- comm_category_id : FTE J estimate rate
3378: wda.type,
3379: wda.parent_delivery_id,
3380: wdl.parent_delivery_leg_id
3381: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_legs wdl,
3382: wsh_new_deliveries wd
3383: where wdd.delivery_detail_id = wda.delivery_detail_id
3384: and wda.delivery_id = wdl.delivery_id
3385: and wdl.delivery_id = wd.delivery_id

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

3458: NULL, -- comm_category_id : FTE J estimate rate
3459: wda.type,
3460: wda.parent_delivery_id,
3461: wdl.parent_delivery_leg_id
3462: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_legs wdl,
3463: wsh_new_deliveries wd, wsh_trips wt, wsh_trip_stops wts1, wsh_trip_stops wts2
3464: where wdd.delivery_detail_id = wda.delivery_detail_id
3465: and wda.delivery_id = wdl.delivery_id
3466: and wdl.delivery_id = wd.delivery_id