[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT wsh_trips_s.nextval
FROM sys.dual;
SELECT trip_id FROM wsh_trips
WHERE name = v_trip_name;
SELECT trip_id FROM wsh_trips
WHERE trip_id = v_trip_id;
INSERT INTO wsh_trips(
trip_id,
name,
planned_flag,
arrive_after_trip_id,
status_code,
vehicle_item_id,
vehicle_organization_id,
vehicle_number,
vehicle_num_prefix,
carrier_id,
ship_method_code,
route_id,
routing_instructions,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
program_application_id,
program_id,
program_update_date,
request_id,
/* H Integration: datamodel changes wrudge */
service_level,
mode_of_transport,
freight_terms_code,
consolidation_allowed,
load_tender_status,
load_tender_number,
wf_name,
wf_process_name,
wf_item_key,
carrier_contact_id,
shipper_wait_time,
wait_time_uom,
load_tendered_time,
vessel,
voyage_number,
port_of_loading,
port_of_discharge,
carrier_response,
route_lane_id,
lane_id,
schedule_id,
booking_number,
shipments_type_flag,
/* J TP Release : ttrichy */
ignore_for_planning,
tp_plan_name,
tp_trip_number,
seal_code,
operator,
/* R12 attributes */
carrier_reference_number,
rank_id,
consignee_carrier_ac_no,
routing_rule_id,
append_flag
) VALUES(
x_trip_id,
x_name,
nvl(p_trip_info.planned_flag, 'N'),
p_trip_info.arrive_after_trip_id,
nvl(p_trip_info.status_code,'OP'),
p_trip_info.vehicle_item_id,
p_trip_info.vehicle_organization_id,
p_trip_info.vehicle_number,
p_trip_info.vehicle_num_prefix,
p_trip_info.carrier_id,
p_trip_info.ship_method_code,
p_trip_info.route_id,
p_trip_info.routing_instructions,
p_trip_info.attribute_category,
p_trip_info.attribute1,
p_trip_info.attribute2,
p_trip_info.attribute3,
p_trip_info.attribute4,
p_trip_info.attribute5,
p_trip_info.attribute6,
p_trip_info.attribute7,
p_trip_info.attribute8,
p_trip_info.attribute9,
p_trip_info.attribute10,
p_trip_info.attribute11,
p_trip_info.attribute12,
p_trip_info.attribute13,
p_trip_info.attribute14,
p_trip_info.attribute15,
nvl(p_trip_info.creation_date, SYSDATE),
nvl(p_trip_info.created_by, FND_GLOBAL.USER_ID),
nvl(p_trip_info.last_update_date, SYSDATE),
nvl(p_trip_info.last_updated_by, FND_GLOBAL.USER_ID),
nvl(p_trip_info.last_update_login, FND_GLOBAL.LOGIN_ID),
p_trip_info.program_application_id,
p_trip_info.program_id,
p_trip_info.program_update_date,
p_trip_info.request_id,
/* H Integration: datamodel changes wrudge */
p_trip_info.service_level,
p_trip_info.mode_of_transport,
p_trip_info.freight_terms_code,
p_trip_info.consolidation_allowed,
p_trip_info.load_tender_status,
p_trip_info.load_tender_number,
p_trip_info.wf_name,
p_trip_info.wf_process_name,
p_trip_info.wf_item_key,
p_trip_info.carrier_contact_id,
p_trip_info.shipper_wait_time,
p_trip_info.wait_time_uom,
p_trip_info.load_tendered_time,
p_trip_info.vessel,
p_trip_info.voyage_number,
p_trip_info.port_of_loading,
p_trip_info.port_of_discharge,
p_trip_info.carrier_response,
p_trip_info.route_lane_id,
p_trip_info.lane_id,
p_trip_info.schedule_id,
p_trip_info.booking_number,
nvl(p_trip_info.shipments_type_flag, 'O'),
/* J TP Release : ttrichy */
--OTM R12, glog proj
NVL(p_trip_info.ignore_for_planning, l_ignore_for_planning),
p_trip_info.tp_plan_name,
p_trip_info.tp_trip_number,
p_trip_info.seal_code,
p_trip_info.operator,
p_trip_info.carrier_reference_number,
p_trip_info.rank_id,
p_trip_info.consignee_carrier_ac_no,
p_trip_info.routing_rule_id,
p_trip_info.append_flag
)RETURNING rowid -- Bug 3821688
INTO x_rowid;
PROCEDURE Delete_Trip(
p_rowid IN VARCHAR2,
p_trip_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
p_validate_flag IN VARCHAR2,
--tkt
p_caller IN VARCHAR2) IS
CURSOR get_trip_id_rowid (v_rowid VARCHAR2) IS
SELECT trip_id
FROM wsh_trips
WHERE rowid = v_rowid;
SELECT delivery_id
FROM wsh_delivery_legs wdl,
wsh_trip_stops wts
WHERE wts.trip_id = l_trip_id
AND wdl.pick_up_stop_id = wts.stop_id;
SELECT stop_id FROM wsh_trip_stops WHERE trip_id = c_trip_id;
SELECT NVL(ignore_for_planning, 'N'),
tp_plan_name
FROM WSH_TRIPS
WHERE trip_id = p_trip_id;
cannot_delete_trip EXCEPTION;
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_TRIP';
WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.CHECK_TRIP_DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
wsh_trip_validations.check_trip_delete(l_trip_id, l_return_status, p_caller);
RAISE cannot_delete_trip;
RAISE cannot_delete_trip;
DELETE FROM wsh_freight_costs
WHERE trip_id = l_trip_id;
DELETE FROM wsh_freight_costs WHERE stop_id = l_stop_id;
DELETE FROM wsh_trip_stops
WHERE trip_id = l_trip_id;
WSH_INTEGRATION.DBI_Update_Trip_Stop_Log
(p_stop_id_tab => l_stop_tab,
p_dml_type => 'DELETE',
x_return_status => l_dbi_rs);
DELETE FROM wsh_trips
WHERE trip_id = l_trip_id;
FND_MESSAGE.SET_NAME('WSH','WSH_OTM_TRIP_DELETE_ERROR');
WHEN cannot_delete_trip THEN
IF c_get_trip_status%ISOPEN THEN
CLOSE c_get_trip_status;
FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_DELETE_ERROR');
WSH_DEBUG_SV.logmsg(l_module_name,'CANNOT_DELETE_TRIP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CANNOT_DELETE_TRIP');
wsh_util_core.default_handler('WSH_TRIPS_PVT.DELETE_TRIP');
END Delete_Trip;
PROCEDURE Update_Trip(
p_rowid IN VARCHAR2,
p_trip_info IN trip_rec_type,
x_return_status OUT NOCOPY VARCHAR2) IS
CURSOR get_row_id IS
SELECT rowid
FROM wsh_trips
WHERE trip_id = p_trip_info.trip_id;
SELECT wnd.organization_id, wnd.name
FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl
WHERE wnd.delivery_id=wdl.delivery_id
and wdl.pick_up_stop_id=wts.stop_id
and wts.trip_id = p_trip_info.trip_id
and (carrier_id <> p_trip_info.carrier_id
OR ship_method_code <> p_trip_info.ship_method_code);
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_TRIP';
UPDATE wsh_trips SET
trip_id = p_trip_info.trip_id,
name = p_trip_info.name,
planned_flag = p_trip_info.planned_flag,
arrive_after_trip_id = p_trip_info.arrive_after_trip_id,
status_code = p_trip_info.status_code,
vehicle_item_id = p_trip_info.vehicle_item_id,
vehicle_organization_id = p_trip_info.vehicle_organization_id,
vehicle_number = p_trip_info.vehicle_number,
vehicle_num_prefix = p_trip_info.vehicle_num_prefix,
carrier_id = p_trip_info.carrier_id,
ship_method_code = p_trip_info.ship_method_code,
route_id = p_trip_info.route_id,
routing_instructions = p_trip_info.routing_instructions,
attribute_category = p_trip_info.attribute_category,
attribute1 = p_trip_info.attribute1,
attribute2 = p_trip_info.attribute2,
attribute3 = p_trip_info.attribute3,
attribute4 = p_trip_info.attribute4,
attribute5 = p_trip_info.attribute5,
attribute6 = p_trip_info.attribute6,
attribute7 = p_trip_info.attribute7,
attribute8 = p_trip_info.attribute8,
attribute9 = p_trip_info.attribute9,
attribute10 = p_trip_info.attribute10,
attribute11 = p_trip_info.attribute11,
attribute12 = p_trip_info.attribute12,
attribute13 = p_trip_info.attribute13,
attribute14 = p_trip_info.attribute14,
attribute15 = p_trip_info.attribute15,
last_update_date = p_trip_info.last_update_date,
last_updated_by = p_trip_info.last_updated_by,
last_update_login = p_trip_info.last_update_login,
program_application_id = p_trip_info.program_application_id,
program_id = p_trip_info.program_id,
program_update_date = p_trip_info.program_update_date,
request_id = p_trip_info.request_id,
/* H Integration: datamodel changes wrudge */
service_level = p_trip_info.service_level,
mode_of_transport = p_trip_info.mode_of_transport,
freight_terms_code = p_trip_info.freight_terms_code,
consolidation_allowed = p_trip_info.consolidation_allowed,
load_tender_status = p_trip_info.load_tender_status,
load_tender_number = p_trip_info.load_tender_number,
wf_name = p_trip_info.wf_name,
wf_process_name = p_trip_info.wf_process_name,
wf_item_key = p_trip_info.wf_item_key,
carrier_contact_id = p_trip_info.carrier_contact_id,
shipper_wait_time = p_trip_info.shipper_wait_time,
wait_time_uom = p_trip_info.wait_time_uom,
load_tendered_time = p_trip_info.load_tendered_time,
vessel = p_trip_info.vessel,
voyage_number = p_trip_info.voyage_number,
port_of_loading = p_trip_info.port_of_loading,
port_of_discharge = p_trip_info.port_of_discharge,
carrier_response = p_trip_info.carrier_response,
route_lane_id = p_trip_info.route_lane_id,
lane_id = p_trip_info.lane_id,
schedule_id = p_trip_info.schedule_id,
booking_number = p_trip_info.booking_number,
/* J Inbound Logistics: new columns jckwok */
shipments_type_flag = nvl(p_trip_info.shipments_type_flag, 'O'),
/* J TP Release : ttrichy */
IGNORE_FOR_PLANNING = nvl(p_trip_info.IGNORE_FOR_PLANNING, 'N'),
TP_PLAN_NAME = p_trip_info.TP_PLAN_NAME,
TP_TRIP_NUMBER = p_trip_info.TP_TRIP_NUMBER,
seal_code = p_trip_info.seal_code,
operator = p_trip_info.operator,
carrier_reference_number = p_trip_info.carrier_reference_number,
rank_id = p_trip_info.rank_id,
consignee_carrier_ac_no = p_trip_info.consignee_carrier_ac_no,
routing_rule_id = p_trip_info.routing_rule_id,
append_flag = p_trip_info.append_flag
WHERE rowid = l_rowid;
wsh_util_core.default_handler('WSH_TRIPS_PVT.UPDATE_TRIP');
END Update_Trip;
SELECT
TRIP_ID,
NAME,
PLANNED_FLAG,
ARRIVE_AFTER_TRIP_ID,
STATUS_CODE,
VEHICLE_ITEM_ID,
VEHICLE_ORGANIZATION_ID,
VEHICLE_NUMBER,
VEHICLE_NUM_PREFIX,
CARRIER_ID,
SHIP_METHOD_CODE,
ROUTE_ID,
ROUTING_INSTRUCTIONS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
/* H Integration: datamodel changes wrudge */
SERVICE_LEVEL,
MODE_OF_TRANSPORT,
FREIGHT_TERMS_CODE,
CONSOLIDATION_ALLOWED,
LOAD_TENDER_STATUS,
ROUTE_LANE_ID,
LANE_ID,
SCHEDULE_ID,
BOOKING_NUMBER,
/* I WSH-FTE Load Tender Integration */
LOAD_TENDER_NUMBER,
VESSEL,
VOYAGE_NUMBER,
PORT_OF_LOADING,
PORT_OF_DISCHARGE,
WF_NAME,
WF_PROCESS_NAME,
WF_ITEM_KEY,
CARRIER_CONTACT_ID,
SHIPPER_WAIT_TIME,
WAIT_TIME_UOM,
LOAD_TENDERED_TIME,
CARRIER_RESPONSE,
/* J Inbound Logistics: new columns */
SHIPMENTS_TYPE_FLAG,
/* J TP Release : ttrichy */
IGNORE_FOR_PLANNING,
TP_PLAN_NAME,
TP_TRIP_NUMBER,
SEAL_CODE,
OPERATOR,
/* R12 attributes */
CARRIER_REFERENCE_NUMBER,
RANK_ID,
CONSIGNEE_CARRIER_AC_NO,
ROUTING_RULE_ID,
APPEND_FLAG
FROM wsh_trips
WHERE rowid = p_rowid
FOR UPDATE OF trip_id NOWAIT;
FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
AND ( (Recinfo.Last_Update_Date = p_trip_info.Last_Update_Date)
OR ( (Recinfo.Last_Update_Date IS NULL)
AND (p_trip_info.Last_Update_Date IS NULL)))
AND ( (Recinfo.Last_Updated_By = p_trip_info.Last_Updated_By)
OR ( (Recinfo.Last_Updated_By IS NULL)
AND (p_trip_info.Last_Updated_By IS NULL)))
AND ( (Recinfo.Last_Update_Login = p_trip_info.Last_Update_Login)
OR ( (Recinfo.Last_Update_Login IS NULL)
AND (p_trip_info.Last_Update_Login IS NULL)))
AND ( (Recinfo.Program_Application_Id = p_trip_info.Program_Application_Id)
OR ( (Recinfo.Program_Application_Id IS NULL)
AND (p_trip_info.Program_Application_Id IS NULL)))
AND ( (Recinfo.Program_Id = p_trip_info.Program_Id)
OR ( (Recinfo.Program_Id IS NULL)
AND (p_trip_info.Program_Id IS NULL)))
AND ( (Recinfo.Program_Update_Date = p_trip_info.Program_Update_Date)
OR ( (Recinfo.Program_Update_Date IS NULL)
AND (p_trip_info.Program_Update_Date IS NULL)))
AND ( (Recinfo.Request_Id = p_trip_info.Request_Id)
OR ( (Recinfo.Request_Id IS NULL)
AND (p_trip_info.Request_Id IS NULL)))
AND ( (Recinfo.Attribute_Category = p_trip_info.Attribute_Category)
OR ( (Recinfo.Attribute_Category IS NULL)
AND (p_trip_info.Attribute_Category IS NULL)))
AND ( (Recinfo.Attribute1 = p_trip_info.Attribute1)
OR ( (Recinfo.Attribute1 IS NULL)
AND (p_trip_info.Attribute1 IS NULL)))
AND ( (Recinfo.Attribute2 = p_trip_info.Attribute2)
OR ( (Recinfo.Attribute2 IS NULL)
AND (p_trip_info.Attribute2 IS NULL)))
AND ( (Recinfo.Attribute3 = p_trip_info.Attribute3)
OR ( (Recinfo.Attribute3 IS NULL)
AND (p_trip_info.Attribute3 IS NULL)))
AND ( (Recinfo.Attribute4 = p_trip_info.Attribute4)
OR ( (Recinfo.Attribute4 IS NULL)
AND (p_trip_info.Attribute4 IS NULL)))
AND ( (Recinfo.Attribute5 = p_trip_info.Attribute5)
OR ( (Recinfo.Attribute5 IS NULL)
AND (p_trip_info.Attribute5 IS NULL)))
AND ( (Recinfo.Attribute6 = p_trip_info.Attribute6)
OR ( (Recinfo.Attribute6 IS NULL)
AND (p_trip_info.Attribute6 IS NULL)))
AND ( (Recinfo.Attribute7 = p_trip_info.Attribute7)
OR ( (Recinfo.Attribute7 IS NULL)
AND (p_trip_info.Attribute7 IS NULL)))
AND ( (Recinfo.Attribute8 = p_trip_info.Attribute8)
OR ( (Recinfo.Attribute8 IS NULL)
AND (p_trip_info.Attribute8 IS NULL)))
AND ( (Recinfo.Attribute9 = p_trip_info.Attribute9)
OR ( (Recinfo.Attribute9 IS NULL)
AND (p_trip_info.Attribute9 IS NULL)))
AND ( (Recinfo.Attribute10 = p_trip_info.Attribute10)
OR ( (Recinfo.Attribute10 IS NULL)
AND (p_trip_info.Attribute10 IS NULL)))
AND ( (Recinfo.Attribute11 = p_trip_info.Attribute11)
OR ( (Recinfo.Attribute11 IS NULL)
AND (p_trip_info.Attribute11 IS NULL)))
AND ( (Recinfo.Attribute12 = p_trip_info.Attribute12)
OR ( (Recinfo.Attribute12 IS NULL)
AND (p_trip_info.Attribute12 IS NULL)))
AND ( (Recinfo.Attribute13 = p_trip_info.Attribute13)
OR ( (Recinfo.Attribute13 IS NULL)
AND (p_trip_info.Attribute13 IS NULL)))
AND ( (Recinfo.Attribute14 = p_trip_info.Attribute14)
OR ( (Recinfo.Attribute14 IS NULL)
AND (p_trip_info.Attribute14 IS NULL)))
AND ( (Recinfo.Attribute15 = p_trip_info.Attribute15)
OR ( (Recinfo.Attribute15 IS NULL)
AND (p_trip_info.Attribute15 IS NULL)))
/* H Integration: datamodel changes wrudge */
AND ( (Recinfo.service_level = p_trip_info.service_level)
OR ( (Recinfo.service_level IS NULL)
AND (p_trip_info.service_level IS NULL)))
AND ( (Recinfo.mode_of_transport = p_trip_info.mode_of_transport)
OR ( (Recinfo.mode_of_transport IS NULL)
AND (p_trip_info.mode_of_transport IS NULL)))
AND ( (Recinfo.freight_terms_code = p_trip_info.freight_terms_code)
OR ( (Recinfo.freight_terms_code IS NULL)
AND (p_trip_info.freight_terms_code IS NULL)))
AND ( (Recinfo.consolidation_allowed = p_trip_info.consolidation_allowed)
OR ( (Recinfo.consolidation_allowed IS NULL)
AND (p_trip_info.consolidation_allowed IS NULL)))
AND ( (Recinfo.load_tender_status = p_trip_info.load_tender_status)
OR ( (Recinfo.load_tender_status IS NULL)
AND (p_trip_info.load_tender_status IS NULL)))
AND ( (Recinfo.route_lane_id = p_trip_info.route_lane_id)
OR ( (Recinfo.route_lane_id IS NULL)
AND (p_trip_info.route_lane_id IS NULL)))
AND ( (Recinfo.lane_id = p_trip_info.lane_id)
OR ( (Recinfo.lane_id IS NULL)
AND (p_trip_info.lane_id IS NULL)))
AND ( (Recinfo.schedule_id = p_trip_info.schedule_id)
OR ( (Recinfo.schedule_id IS NULL)
AND (p_trip_info.schedule_id IS NULL)))
AND ( (Recinfo.booking_number = p_trip_info.booking_number)
OR ( (Recinfo.booking_number IS NULL)
AND (p_trip_info.booking_number IS NULL)))
AND ( (nvl(Recinfo.shipments_type_flag, 'O') = nvl(p_trip_info.shipments_type_flag,'O') )
OR ( (Recinfo.shipments_type_flag IS NULL)
AND (p_trip_info.shipments_type_flag IS NULL)))
/* J TP Release : ttrichy */
-- OTM R12, glog project, for l_ignore_flag
AND (nvl(Recinfo.IGNORE_FOR_PLANNING, l_ignore_flag) = nvl(p_trip_info.ignore_for_planning,l_ignore_flag))
AND ( (Recinfo.TP_PLAN_NAME = p_trip_info.TP_PLAN_NAME)
OR ( (Recinfo.TP_PLAN_NAME IS NULL)
AND (p_trip_info.TP_PLAN_NAME IS NULL)))
AND ( (Recinfo.TP_TRIP_NUMBER = p_trip_info.TP_TRIP_NUMBER )
OR ( (Recinfo.TP_TRIP_NUMBER IS NULL)
AND (p_trip_info.TP_TRIP_NUMBER IS NULL)))
AND ( (Recinfo.seal_code = p_trip_info.seal_code )
OR ( (Recinfo.seal_code IS NULL)
AND (p_trip_info.seal_code IS NULL)))
AND ( (Recinfo.operator = p_trip_info.operator )
OR ( (Recinfo.operator IS NULL)
AND (p_trip_info.operator IS NULL)))
AND ( (Recinfo.carrier_reference_number = p_trip_info.carrier_reference_number )
OR ( (Recinfo.carrier_reference_number IS NULL)
AND (p_trip_info.carrier_reference_number IS NULL)))
AND ( (Recinfo.consignee_carrier_ac_no = p_trip_info.consignee_carrier_ac_no )
OR ( (Recinfo.consignee_carrier_ac_no IS NULL)
AND (p_trip_info.consignee_carrier_ac_no IS NULL)))
-- do not check these columns because they are not in WSH UI
-- ROUTING_RULE_ID
-- APPEND_FLAG
-- RANK_ID
) THEN
--
-- Debug Statements
--
IF l_debug_on THEN
WSH_DEBUG_SV.pop(l_module_name);
SELECT
TRIP_ID,
NAME,
PLANNED_FLAG,
ARRIVE_AFTER_TRIP_ID,
STATUS_CODE,
VEHICLE_ITEM_ID,
VEHICLE_ORGANIZATION_ID,
VEHICLE_NUMBER,
VEHICLE_NUM_PREFIX,
CARRIER_ID,
SHIP_METHOD_CODE,
ROUTE_ID,
ROUTING_INSTRUCTIONS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
/* H Integration: datamodel changes wrudge */
SERVICE_LEVEL,
MODE_OF_TRANSPORT,
FREIGHT_TERMS_CODE,
CONSOLIDATION_ALLOWED,
LOAD_TENDER_STATUS,
ROUTE_LANE_ID,
LANE_ID,
SCHEDULE_ID,
BOOKING_NUMBER,
/* I Harmonization: Nondatabase Columns Added rvishnuv */
ROWID,
NULL,
NULL,
NULL,
NULL,
/* I WSH-FTE Load Tender Integration */
LOAD_TENDER_NUMBER,
VESSEL,
VOYAGE_NUMBER,
PORT_OF_LOADING,
PORT_OF_DISCHARGE,
WF_NAME,
WF_PROCESS_NAME,
WF_ITEM_KEY,
CARRIER_CONTACT_ID,
SHIPPER_WAIT_TIME,
WAIT_TIME_UOM,
LOAD_TENDERED_TIME,
CARRIER_RESPONSE,
/* J Inbound Logistics: new columns */
SHIPMENTS_TYPE_FLAG,
/* J TP Release : ttrichy */
--OTM R12,glog proj
NVL(ignore_for_planning, p_ignore_flag),
TP_PLAN_NAME,
TP_TRIP_NUMBER,
SEAL_CODE,
OPERATOR,
/* R12 attributes */
CARRIER_REFERENCE_NUMBER,
RANK_ID,
CONSIGNEE_CARRIER_AC_NO,
ROUTING_RULE_ID,
APPEND_FLAG
FROM wsh_trips
WHERE trip_id = p_trip_id;
SELECT name
FROM wsh_trips
WHERE trip_id = p_trip_id;
SELECT trip_id
FROM wsh_trips
WHERE trip_id = p_trip_id
FOR UPDATE NOWAIT;