[Home] [Help]
73: -- count the number of deliveries which should not be rated due to freight term
74: CURSOR c_check_del_freight_term(c_delivery_id NUMBER)
75: IS
76: SELECT count(wd.delivery_id)
77: FROM wsh_new_deliveries wd, wsh_global_parameters wgp
78: WHERE (
79: ((wd.shipment_direction in ('I'))
80: and (wgp.rate_ib_dels_fgt_term is not null)
81: and (wd.freight_terms_code is not null)
99: -- count the number of deliveries which should not be rated due to freight term
100: CURSOR c_check_del_freight_term2(c_trip_id NUMBER)
101: IS
102: SELECT count(wd.delivery_id)
103: FROM wsh_new_deliveries wd, wsh_global_parameters wgp
104: WHERE (
105: ((wd.shipment_direction in ('I'))
106: and (wgp.rate_ib_dels_fgt_term is not null)
107: and (wd.freight_terms_code is not null)
134: -- count the number of deliveries which should not be rated due to manifesting
135: CURSOR c_check_del_manifesting(c_delivery_id NUMBER)
136: IS
137: SELECT count(a.delivery_id)
138: FROM wsh_new_deliveries a,
139: mtl_parameters b,
140: wsh_carriers c
141: WHERE a.organization_id = b.organization_id
142: AND a.carrier_id = c.carrier_id
147: -- count the number of deliveries which should not be rated due to manifesting
148: CURSOR c_check_del_manifesting2(c_trip_id NUMBER)
149: IS
150: SELECT count(a.delivery_id)
151: FROM wsh_new_deliveries a,
152: mtl_parameters b,
153: wsh_carriers c
154: WHERE a.organization_id = b.organization_id
155: AND a.carrier_id = c.carrier_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
8843: and wdl.delivery_id = wd.delivery_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
8930: and ((wdl.reprice_required = 'Y' AND p_check_reprice_flag = 'Y') OR (p_check_reprice_flag = 'N'))
10109: l_index NUMBER := 0;
10110:
10111: CURSOR c_get_delivery_legs_detail(c_delivery_id IN NUMBER) IS
10112: SELECT wdl.delivery_id,delivery_leg_id,wnd.name
10113: FROM wsh_delivery_legs wdl, wsh_new_deliveries wnd
10114: WHERE wdl.delivery_id= c_delivery_id
10115: AND wnd.delivery_id = wdl.delivery_id;
10116:
10117: BEGIN
10166: FROM wsh_delivery_legs wdl ,
10167: wsh_trip_stops wts1,
10168: wsh_trip_stops wts2,
10169: wsh_trips wt,
10170: wsh_new_deliveries wnd
10171: WHERE wdl.pick_up_stop_id = wts1.stop_id
10172: AND wdl.drop_off_stop_id = wts2.stop_id
10173: AND wdl.delivery_leg_id = c_dleg_id
10174: AND wt.trip_id = wts1.trip_id
10259: l_var VARCHAR2(1);
10260:
10261: CURSOR check_delivery_type (c_delivery_id IN NUMBER)
10262: IS
10263: SELECT 'X' FROM WSH_NEW_DELIVERIES
10264: WHERE ( shipment_direction IN ('O','IO') AND status_code = 'OP')
10265: OR ( shipment_direction IN ('D','I') )
10266: AND delivery_id = c_delivery_id ;
10267:
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
12509: and wda.delivery_id = wd.delivery_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
12589: and wdl.delivery_id = wd.delivery_id
12950: and wda.delivery_id = c_delivery_id;
12951:
12952: CURSOR c_delivery_wt_uom(c_delivery_id IN NUMBER) IS
12953: SELECT weight_uom_code
12954: FROM wsh_new_deliveries
12955: WHERE delivery_id = c_delivery_id;
12956:
12957: l_target_wt_uom VARCHAR2(30);
12958: l_cum_wt NUMBER;