eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_TENDER_WF dependencies on WSH_TRIPS

Line 78: FROM wsh_trips

74:
75: CURSOR c_tender_check (p_tender_id NUMBER)
76: IS
77: SELECT trip_id,wf_item_key
78: FROM wsh_trips
79: WHERE load_tender_number = p_tender_id;
80:
81: l_trip_id NUMBER;
82: l_item_key VARCHAR2(240);

Line 253: from wsh_trips wts,

249: CURSOR c_vehicle_info(p_tender_id NUMBER) is
250: select
251: msi.segment1 vehicle_type,
252: flvv.meaning vehicle_class
253: from wsh_trips wts,
254: mtl_system_items msi,
255: fnd_lookup_values_vl flvv,
256: fte_vehicle_types fvt
257: where

Line 270: wsh_trips wts,

266: CURSOR c_service_info(p_tender_id NUMBER) is
267: select
268: wl.meaning service_level
269: from
270: wsh_trips wts,
271: wsh_lookups wl
272: where
273: wts.service_level = wl.lookup_code(+)
274: and wl.lookup_type(+) = 'WSH_SERVICE_LEVELS'

Line 298: from wsh_trips

294: x_mbol_number OUT NOCOPY VARCHAR2) IS
295:
296: CURSOR c_mode_of_transport(p_tender_id NUMBER) is
297: SELECT mode_of_transport,trip_id
298: from wsh_trips
299: where load_tender_number = p_tender_id;
300:
301: CURSOR c_mbol_info(p_trip_id NUMBER) is
302: select sequence_number

Line 306: and entity_name = 'WSH_TRIPS'

302: select sequence_number
303: from wsh_document_instances
304: where
305: entity_id = p_trip_id
306: and entity_name = 'WSH_TRIPS'
307: and document_type = 'MBOL';
308:
309: l_mode_of_transport VARCHAR2(60);
310: l_trip_id NUMBER;

Line 430: hz_parties hz, wsh_trips wt

426: l_carrier_name VARCHAR2(360);
427:
428: cursor get_carrier_name (c_trip_id number) is
429: select hz.party_name from
430: hz_parties hz, wsh_trips wt
431: where wt.carrier_id= hz.party_id AND
432: wt.trip_id = c_trip_id;
433:
434: CURSOR get_trip_cur(c_trip_id NUMBER) is

Line 438: from wsh_trips

434: CURSOR get_trip_cur(c_trip_id NUMBER) is
435: SELECT trip_id, name,load_tender_status,load_Tender_number,
436: shipper_wait_time,wait_time_uom,carrier_id,
437: load_tendered_time,mode_of_transport
438: from wsh_trips
439: where trip_id = c_trip_id;
440:
441:
442: /* Bug 5312853: Query does not join contacts to sites

Line 447: hz_party_sites sites, wsh_Carrier_sites car_sites, wsh_trips trips

443: CURSOR get_notif_type_c (l_trip_id NUMBER) IS
444: SELECT car_sites.tender_transmission_method notif_type,
445: car_sites.auto_accept_load_tender auto_accept_flag,car_sites.carrier_site_id
446: FROM hz_contact_points cont, hz_relationships rel,
447: hz_party_sites sites, wsh_Carrier_sites car_sites, wsh_trips trips
448: WHERE owner_table_name = 'HZ_PARTIES'
449: and rel.party_id = owner_table_id
450: and sites.party_id =rel.subject_id
451: and car_sites.carrier_site_id = sites.party_site_id

Line 461: wsh_carrier_sites car_sites, wsh_trips trips

457: SELECT car_sites.tender_transmission_method notif_type,
458: car_sites.auto_accept_load_tender auto_accept_flag,car_sites.carrier_site_id
459: FROM hz_parties party, hz_relationships rel, hz_party_sites sites,
460: hz_org_contacts cont, hz_contact_points points,
461: wsh_carrier_sites car_sites, wsh_trips trips
462: WHERE rel.object_id = party.party_id
463: AND rel.subject_type = 'ORGANIZATION'
464: AND rel.subject_Table_name = 'HZ_PARTIES'
465: AND sites.party_id = rel.subject_id

Line 2164: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2160: l_trip_name VARCHAR2(30000);
2161: l_msg_string VARCHAR2(30000);
2162:
2163:
2164: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2165: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
2166: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
2167: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
2168:

Line 2165: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

2161: l_msg_string VARCHAR2(30000);
2162:
2163:
2164: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2165: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
2166: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
2167: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
2168:
2169: l_number_of_warnings NUMBER;

Line 2166: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

2162:
2163:
2164: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2165: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
2166: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
2167: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
2168:
2169: l_number_of_warnings NUMBER;
2170: l_number_of_errors NUMBER;

Line 2167: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;

2163:
2164: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2165: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
2166: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
2167: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
2168:
2169: l_number_of_warnings NUMBER;
2170: l_number_of_errors NUMBER;
2171:

Line 2417: FROM wsh_trips WHERE load_tender_number = c_tender_id;

2413: CURSOR get_tender_info_cur (c_tender_id NUMBER)
2414: IS
2415: SELECT routing_instructions, load_tendered_time,
2416: shipper_wait_time,wait_time_uom, carrier_response, mode_of_transport
2417: FROM wsh_trips WHERE load_tender_number = c_tender_id;
2418:
2419: --{
2420: BEGIN
2421: --

Line 2744: FROM WSH_TRIPS

2740: -- tender wf item key.
2741: IF (l_tender_status = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
2742: THEN
2743: SELECT WF_ITEM_KEY INTO l_delivery_leg_activity_rec.wf_item_key
2744: FROM WSH_TRIPS
2745: WHERE TRIP_ID = l_trip_id;
2746: ELSE
2747: l_delivery_leg_activity_rec.wf_item_key := itemkey;
2748: END IF;

Line 2935: FROM WSH_TRIPS

2931:
2932: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2933:
2934: SELECT APPEND_FLAG,ROUTING_RULE_ID INTO l_appendFlag, l_ruleId
2935: FROM WSH_TRIPS
2936: WHERE TRIP_ID = l_trip_id;
2937:
2938: -- We have to query first stop, last stop information to populate on to
2939: -- trip

Line 3328: SELECT CARRIER_ID INTO l_carrier_id FROM WSH_TRIPS

3324:
3325: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
3326:
3327:
3328: SELECT CARRIER_ID INTO l_carrier_id FROM WSH_TRIPS
3329: WHERE TRIP_ID = l_trip_id;
3330:
3331: SELECT decode(ENABLE_AUTO_TENDER,null,'N','N','N','Y') AUTO_TENDER
3332: INTO l_autoTender