[Home] [Help]
182:
183: -- cursor definitions
184: CURSOR c_get_carrier_id(p_carrier_name VARCHAR2) IS
185: select party_id
186: from hz_parties, wsh_carriers
187: where party_name = p_carrier_name and party_id = carrier_id;
188:
189: CURSOR c_get_lookup_code(p_lookup_type VARCHAR2, p_meaning VARCHAR2) IS
190: select lookup_code from fnd_lookup_values_vl
252: IF (p_source_type ='T') THEN
253:
254: l_query_select := 'select wc.carrier_name, l.carrier_id, l.origin_id, l.destination_id, lv2.meaning, l.mode_of_transportation_code, r.region_type, min(l.lane_id) lane_id ';
255:
256: l_query_from_regions :=' from fte_lanes l, wsh_carriers_v wc, wsh_zone_regions zr,' ||
257: ' wsh_zone_regions pd, fnd_lookup_values_vl lv2, wsh_regions r';
258:
259: l_query_common_join := ' where l.carrier_id = wc.carrier_id and' ||
260: ' wc.active = ''A'' AND' ||
284: 'l.expiry_date, ro.region_type, rd.region_type, l.comm_fc_class_code, ' ||
285: 'l.schedules_flag, ls.lane_service_id, l.tariff_name, l.lane_type';
286:
287: -- from clauses
288: l_query_from_regions := ' from fte_lanes l, wsh_carriers_v wc, wsh_zone_regions zr,' ||
289: ' wsh_zone_regions pd, fnd_lookup_values_vl lv1,' ||
290: ' qp_list_headers_tl lh, fnd_lookup_values_vl lv2,' ||
291: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||
292: ' wsh_regions ro, wsh_regions rd,' ||
291: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||
292: ' wsh_regions ro, wsh_regions rd,' ||
293: ' fte_lane_services ls ';
294:
295: l_query_from_lane_num := ' from fte_lanes l, wsh_carriers_v wc, fnd_lookup_values_vl lv1,' ||
296: ' qp_list_headers_tl lh, fnd_lookup_values_vl lv2,' ||
297: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||
298: ' wsh_regions ro, wsh_regions rd, ' ||
299: ' fte_lane_services ls ';