[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT trip_id,wf_item_key
FROM wsh_trips
WHERE load_tender_number = p_tender_id;
select
msi.segment1 vehicle_type,
flvv.meaning vehicle_class
from wsh_trips wts,
mtl_system_items msi,
fnd_lookup_values_vl flvv,
fte_vehicle_types fvt
where
fvt.inventory_item_id = wts.vehicle_item_id
and fvt.organization_id = wts.vehicle_organization_id
and wts.vehicle_item_id = msi.inventory_item_id
and fvt.vehicle_class_code = flvv.lookup_code(+)
and flvv.lookup_type(+) = 'FTE_VEHICLE_CLASS'
and wts.vehicle_organization_id = msi.organization_id
and wts.load_tender_number = p_tender_id;
select
wl.meaning service_level
from
wsh_trips wts,
wsh_lookups wl
where
wts.service_level = wl.lookup_code(+)
and wl.lookup_type(+) = 'WSH_SERVICE_LEVELS'
and wts.load_tender_number = p_tender_id;
SELECT mode_of_transport,trip_id
from wsh_trips
where load_tender_number = p_tender_id;
select sequence_number
from wsh_document_instances
where
entity_id = p_trip_id
and entity_name = 'WSH_TRIPS'
and document_type = 'MBOL';
select hz.party_name from
hz_parties hz, wsh_trips wt
where wt.carrier_id= hz.party_id AND
wt.trip_id = c_trip_id;
SELECT trip_id, name,load_tender_status,load_Tender_number,
shipper_wait_time,wait_time_uom,carrier_id,
load_tendered_time,mode_of_transport
from wsh_trips
where trip_id = c_trip_id;
SELECT car_sites.tender_transmission_method notif_type,
car_sites.auto_accept_load_tender auto_accept_flag,car_sites.carrier_site_id
FROM hz_contact_points cont, hz_relationships rel,
hz_party_sites sites, wsh_Carrier_sites car_sites, wsh_trips trips
WHERE owner_table_name = 'HZ_PARTIES'
and rel.party_id = owner_table_id
and sites.party_id =rel.subject_id
and car_sites.carrier_site_id = sites.party_site_id
and trips.carrier_contact_id = owner_table_id
and trip_id = l_trip_id;
SELECT car_sites.tender_transmission_method notif_type,
car_sites.auto_accept_load_tender auto_accept_flag,car_sites.carrier_site_id
FROM hz_parties party, hz_relationships rel, hz_party_sites sites,
hz_org_contacts cont, hz_contact_points points,
wsh_carrier_sites car_sites, wsh_trips trips
WHERE rel.object_id = party.party_id
AND rel.subject_type = 'ORGANIZATION'
AND rel.subject_Table_name = 'HZ_PARTIES'
AND sites.party_id = rel.subject_id
AND cont.party_site_id = sites.party_site_id
AND cont.party_relationship_id = rel.relationship_id
AND points.owner_table_id = rel.party_id
AND points.owner_table_name = 'HZ_PARTIES'
AND points.contact_point_type = 'EMAIL'
AND car_sites.carrier_site_id = sites.party_site_id
AND trips.carrier_contact_id = points.owner_table_id
AND trips.trip_id = l_trip_id;
PROCEDURE UPDATE_CARRIER_RESPONSE(
p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
p_tender_id IN NUMBER,
p_tender_status IN VARCHAR2,
p_wf_item_key IN VARCHAR2,
p_remarks IN VARCHAR2,
p_initial_pickup_date IN DATE,
p_ultimate_dropoff_date IN DATE,
p_vehicle_number IN VARCHAR2,
p_operator IN VARCHAR2,
p_carrier_ref_number IN VARCHAR2,
p_call_source IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_api_name VARCHAR2(30) := 'UPDATE_CARRIER_RESPONSE';
l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'UPDATE_CARRIER_RESPONSE';
SAVEPOINT UPDATE_CARRIER_RESPONSE_PUB;
ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
wsh_util_core.default_handler('FTE_TENDER_WF.UPDATE_CARRIER_RESPONSE');
END UPDATE_CARRIER_RESPONSE;
PROCEDURE FINALIZE_UPDATE_TENDER(itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout out NOCOPY varchar2) IS
l_result_code VARCHAR2(10);
l_api_name VARCHAR2(30) := 'FINALIZE_UPDATE_TENDER';
avalue => FTE_TENDER_PVT.S_SHIPPER_UPDATED);
'FINALIZE_UPDATE_TENDER',
itemtype,
itemkey,
actid,
funcmode);
END FINALIZE_UPDATE_TENDER;
SELECT routing_instructions, load_tendered_time,
shipper_wait_time,wait_time_uom, carrier_response, mode_of_transport
FROM wsh_trips WHERE load_tender_number = c_tender_id;
l_tender_status = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
THEN
l_delivery_leg_activity_rec.action_by :=
wf_engine.GetItemAttrNumber(itemtype,itemkey,'SHIPPER_USER_ID');
-- For shipper update item key is different. so we have to get the original
-- tender wf item key.
IF (l_tender_status = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
THEN
SELECT WF_ITEM_KEY INTO l_delivery_leg_activity_rec.wf_item_key
FROM WSH_TRIPS
WHERE TRIP_ID = l_trip_id;
SELECT APPEND_FLAG,ROUTING_RULE_ID INTO l_appendFlag, l_ruleId
FROM WSH_TRIPS
WHERE TRIP_ID = l_trip_id;
SELECT CARRIER_ID INTO l_carrier_id FROM WSH_TRIPS
WHERE TRIP_ID = l_trip_id;
SELECT decode(ENABLE_AUTO_TENDER,null,'N','N','N','Y') AUTO_TENDER
INTO l_autoTender
FROM WSH_CARRIER_SITES
WHERE CARRIER_ID = l_carrier_id
AND ROWNUM = 1;
PROCEDURE FTETENDER_SELECTOR(itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout out NOCOPY varchar2) IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'FTETENDER_SELECTOR';
END FTETENDER_SELECTOR;