[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
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
8844: and wdl.delivery_id = wd.delivery_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
8931: and ((wdl.reprice_required = 'Y' AND p_check_reprice_flag = 'Y') OR (p_check_reprice_flag = 'N'))
10110: l_index NUMBER := 0;
10111:
10112: CURSOR c_get_delivery_legs_detail(c_delivery_id IN NUMBER) IS
10113: SELECT wdl.delivery_id,delivery_leg_id,wnd.name
10114: FROM wsh_delivery_legs wdl, wsh_new_deliveries wnd
10115: WHERE wdl.delivery_id= c_delivery_id
10116: AND wnd.delivery_id = wdl.delivery_id;
10117:
10118: BEGIN
10167: FROM wsh_delivery_legs wdl ,
10168: wsh_trip_stops wts1,
10169: wsh_trip_stops wts2,
10170: wsh_trips wt,
10171: wsh_new_deliveries wnd
10172: WHERE wdl.pick_up_stop_id = wts1.stop_id
10173: AND wdl.drop_off_stop_id = wts2.stop_id
10174: AND wdl.delivery_leg_id = c_dleg_id
10175: AND wt.trip_id = wts1.trip_id
10260: l_var VARCHAR2(1);
10261:
10262: CURSOR check_delivery_type (c_delivery_id IN NUMBER)
10263: IS
10264: SELECT 'X' FROM WSH_NEW_DELIVERIES
10265: WHERE ( shipment_direction IN ('O','IO') AND status_code = 'OP')
10266: OR ( shipment_direction IN ('D','I') )
10267: AND delivery_id = c_delivery_id ;
10268:
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
12510: and wda.delivery_id = wd.delivery_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
12590: and wdl.delivery_id = wd.delivery_id
12951: and wda.delivery_id = c_delivery_id;
12952:
12953: CURSOR c_delivery_wt_uom(c_delivery_id IN NUMBER) IS
12954: SELECT weight_uom_code
12955: FROM wsh_new_deliveries
12956: WHERE delivery_id = c_delivery_id;
12957:
12958: l_target_wt_uom VARCHAR2(30);
12959: l_cum_wt NUMBER;