[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT dl.delivery_id, dl.planned_flag, dl.status_code, dl.ignore_for_planning, dl.name delivery_name,
dl.organization_id organization_id, -- LPN CONV. rv
nvl(dl.shipment_direction,'O') shipment_direction -- LPN CONV. rv
FROM wsh_trips t, wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl
WHERE t.trip_id = p_tripid AND
st.trip_id = t.trip_id AND
dg.pick_up_stop_id = st.stop_id AND
dl.delivery_id = dg.delivery_id;
SELECT dl.name delivery_name, t.name trip_name
FROM wsh_trips t, wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl
WHERE t.trip_id <> p_tripid AND
st.trip_id = t.trip_id AND
dg.pick_up_stop_id = st.stop_id AND
dl.delivery_id = dg.delivery_id AND
dl.delivery_id=p_delid AND
(nvl(t.ignore_for_planning,'N')<>p_ignoreplan);
SELECT t.trip_id, t.name trip_name
FROM wsh_trips t, wsh_trip_stops st, wsh_delivery_legs dg
WHERE t.trip_id <> p_tripid AND
st.trip_id = t.trip_id AND
dg.pick_up_stop_id = st.stop_id AND
dg.delivery_id=p_delid;
SELECT dl.name delivery_name, t.name trip_name
FROM wsh_trips t, wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl
WHERE st.trip_id = t.trip_id AND
dg.pick_up_stop_id = st.stop_id AND
dl.delivery_id = dg.delivery_id AND
dl.delivery_id=p_delid AND
( nvl(t.ignore_for_planning, 'N')<>p_ignoreplan);
SELECT wnd.name delivery_name
FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
WHERE wda.delivery_id = wnd.delivery_id AND
wda.delivery_id IS NOT NULL AND
wda.delivery_detail_id=p_detailid AND
(nvl(wnd.ignore_for_planning, 'N')<>p_ignoreplan);
SELECT dd.delivery_detail_id, dd.ignore_for_planning, dd.source_code, dd.container_flag,
nvl(dd.line_direction,'O') line_direction, organization_id -- LPN CONV. rv
FROM wsh_delivery_details dd,
wsh_delivery_assignments_v da
WHERE da.delivery_id = p_delid AND
da.delivery_id IS NOT NULL AND
da.delivery_detail_id = dd.delivery_detail_id;
select organization_id, source_code, container_flag
from wsh_delivery_details
where delivery_detail_id=p_detid;
select organization_id, name delivery_name, delivery_type
from wsh_new_deliveries
where delivery_id=p_delid;
select container_flag, container_name,
organization_id,
nvl(line_direction,'O') line_direction -- LPN CONV. rv
from wsh_delivery_details
where delivery_detail_id=p_detailid
and container_flag='Y';
SELECT delivery_detail_id
FROM wsh_delivery_assignments_v
START WITH delivery_detail_id =p_detailid
CONNECT BY prior delivery_detail_id = parent_delivery_detail_id
and rownum < 10;
SELECT 'Y'
FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND
wda.parent_delivery_detail_id IS NOT NULL AND
wdd.delivery_detail_id=p_detailid AND
nvl(wdd.ignore_for_planning,'N')<>p_ignoreplan;
l_tms_update VARCHAR2(1);
l_tp_plan_name_update VARCHAR2(1);
l_tmp_del_ids.delete;
l_tmp_detail_ids.delete;
l_sync_tmp_wms_recTbl.operation_type_tbl(l_cnt_wms_counter) := 'UPDATE';
l_sync_tmp_inv_recTbl.operation_type_tbl(l_cnt_inv_counter) := 'UPDATE';
SAVEPOINT before_update;
l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.delete;
l_sync_tmp_wms_recTbl.operation_type_tbl.delete;
rollback to before_update;
l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.delete;
l_sync_tmp_inv_recTbl.operation_type_tbl.delete;
rollback to before_update;
UPDATE wsh_delivery_details
SET ignore_for_planning = l_ignoreplan,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE delivery_detail_id=l_tmp_detail_ids(i);
rollback to before_update;
FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
UPDATE wsh_new_deliveries
SET ignore_for_planning = l_ignoreplan,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE delivery_id=l_tmp_del_ids(i);
rollback to before_update;
FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
l_tp_plan_name_update := 'Y';
l_tp_plan_name_update := 'N';
WSH_DEBUG_SV.log(l_module_name,'Tp Plan Name Update',l_tp_plan_name_update);
IF l_tp_plan_name_update = 'Y' THEN
UPDATE wsh_trips
SET ignore_for_planning = l_ignoreplan,
tp_plan_name = NULL, -- OTM R12, glog proj
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID,
last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
WHERE trip_id=p_in_ids(i);
ELSE -- l_tp_plan_name_update is null or N, do not update tp_plan_name
UPDATE wsh_trips
SET ignore_for_planning = l_ignoreplan,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID,
last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
WHERE trip_id=p_in_ids(i);
rollback to before_update;
FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
l_tmp_detail_ids.delete;
l_sync_tmp_wms_recTbl.operation_type_tbl(l_cnt_wms_counter) := 'UPDATE';
l_sync_tmp_inv_recTbl.operation_type_tbl(l_cnt_inv_counter) := 'UPDATE';
SAVEPOINT before_update;
l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.delete;
l_sync_tmp_wms_recTbl.operation_type_tbl.delete;
ROLLBACK to before_update;
l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.delete;
l_sync_tmp_inv_recTbl.operation_type_tbl.delete;
ROLLBACK to before_update;
IF NVL(WSH_DELIVERIES_GRP.G_ACTION,'UPDATE') <> 'CONFIRM' THEN
IF l_tmp_detail_ids is not null and l_tmp_detail_ids.COUNT>0 THEN
FORALL i in l_tmp_detail_ids.FIRST..l_tmp_detail_ids.LAST
UPDATE wsh_delivery_details
SET ignore_for_planning = l_ignoreplan,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE delivery_detail_id=l_tmp_detail_ids(i);
ROLLBACK to before_update;
FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
l_delivery_info_tab.DELETE;
l_tms_update := 'Y';
ROLLBACK to before_update;
ROLLBACK to before_update;
IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))
AND l_is_delivery_empty = 'N') THEN
l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
l_tms_update := 'N';
WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
l_tms_update := 'N';
WSH_DEBUG_SV.log(l_module_name,'l_tms_update',l_tms_update);
l_del_trip_tab.delete;
ROLLBACK to before_update;
ROLLBACK to before_update;
UPDATE wsh_new_deliveries
SET ignore_for_planning = l_ignoreplan,
-- OTM R12, glog proj, based on the l_tms_update flag set above
tms_interface_flag = DECODE(l_tms_update,
'Y', l_new_interface_flag_tab(1),
tms_interface_flag),
tms_version_number = DECODE(l_tms_update,
'Y', l_new_version_number_tab(1),
tms_version_number),
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID,
last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
WHERE delivery_id=p_in_ids(i);
ROLLBACK to before_update;
FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
ROLLBACK to before_update;
SAVEPOINT before_update;
l_tmp_detail_ids.delete;
UPDATE wsh_delivery_details
SET ignore_for_planning=l_ignoreplan,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE delivery_detail_id=l_tmp_detail_ids(i)
RETURNING container_flag, organization_id, line_direction bulk collect into l_cont_flag_tbl, l_orgn_id_tbl, l_line_dir_tbl; -- LPN CONV. rv
rollback to before_update;
FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
l_sync_tmp_wms_recTbl.operation_type_tbl(l_cnt_wms_counter) := 'UPDATE';
l_sync_tmp_inv_recTbl.operation_type_tbl(l_cnt_inv_counter) := 'UPDATE';
l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.delete;
l_sync_tmp_wms_recTbl.operation_type_tbl.delete;
l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.delete;
l_sync_tmp_inv_recTbl.operation_type_tbl.delete;
UPDATE wsh_delivery_details
SET ignore_for_planning = l_ignoreplan,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE delivery_detail_id=p_in_ids(i);
rollback to before_update;
FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
SELECT dg.delivery_id
FROM wsh_trips t,
wsh_trip_stops st,
wsh_delivery_legs dg
WHERE t.trip_id = c_trip_id AND
st.trip_id = t.trip_id AND
dg.pick_up_stop_id = st.stop_id;
SELECT t.trip_id
FROM wsh_trips t,
wsh_trip_stops st,
wsh_delivery_legs dg
WHERE t.trip_id <> c_trip_id AND
st.trip_id = t.trip_id AND
dg.pick_up_stop_id = st.stop_id AND
dg.delivery_id=c_delid AND
NVL(t.planned_flag, 'N') = 'N';
SELECT dg.delivery_id
FROM wsh_trips t,
wsh_trip_stops st,
wsh_delivery_legs dg,
wsh_new_deliveries dl
WHERE t.trip_id = c_tripid AND
st.trip_id = t.trip_id AND
dg.pick_up_stop_id = st.stop_id AND
dg.delivery_id=dl.delivery_id AND
dl.delivery_id<>c_delid AND
dl.planned_flag IN ('Y','N') AND
rownum=1;
SELECT distinct st.trip_id, t.planned_flag
FROM wsh_trip_stops st,
wsh_delivery_legs dg,
wsh_trips t
WHERE dg.pick_up_stop_id = st.stop_id AND
dg.delivery_id=c_delid AND
st.trip_id = t.trip_id;
UPDATE wsh_new_deliveries
SET planned_flag = c_routing_firm_flag,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE delivery_id = del_cur.delivery_id;
FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
UPDATE wsh_trips
SET planned_flag = l_plannedflag,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE trip_id = l_trips_cur.trip_id;
FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
UPDATE wsh_trips
SET planned_flag = c_routing_firm_flag ,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE trip_id = p_entity_id;
UPDATE wsh_trips
SET planned_flag = l_plannedflag,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE trip_id = l_trips_cur.trip_id;
FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
UPDATE wsh_new_deliveries
SET planned_flag = c_routing_firm_flag,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE delivery_id = p_entity_id;
SELECT dg.delivery_id
FROM wsh_trip_stops st,
wsh_delivery_legs dg,
wsh_new_deliveries nd
WHERE st.trip_id = p_entity_id AND
dg.pick_up_stop_id = st.stop_id AND
nd.delivery_id=dg.delivery_id AND
nd.planned_flag='F';
SELECT t.trip_id
FROM wsh_trips t,
wsh_trip_stops st,
wsh_delivery_legs dg
WHERE t.trip_id <> p_entity_id AND
st.trip_id = t.trip_id AND
dg.pick_up_stop_id = st.stop_id AND
dg.delivery_id=p_delid
and t.planned_flag='F';
SELECT t.trip_id
FROM wsh_trips t,
wsh_trip_stops st,
wsh_delivery_legs dg
WHERE st.trip_id = t.trip_id AND
dg.pick_up_stop_id = st.stop_id AND
dg.delivery_id=p_entity_id
and t.planned_flag='F';
select planned_flag
from wsh_trips
where trip_id=p_entity_id;
UPDATE wsh_trips
SET planned_flag = l_action,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE trip_id = p_entity_id;
UPDATE wsh_new_deliveries
SET planned_flag = decode(l_action, 'Y', planned_flag, 'Y'),
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE delivery_id = del_cur.delivery_id;
FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
UPDATE wsh_trips
SET planned_flag = 'Y',
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE trip_id = l_trips_cur.trip_id;
FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
UPDATE wsh_new_deliveries
SET planned_flag = l_action,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE delivery_id = p_entity_id;
UPDATE wsh_trips
SET planned_flag = 'Y',
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE trip_id = cur_deltrip.trip_id;
FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
x_updated_flag OUT NOCOPY VARCHAR2,
x_delivery_id OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2);
SELECT ship_from_org_id,inventory_item_id
FROM OE_ORDER_LINES_ALL
WHERE line_id = p_source_line_id;
SELECT organization_id,inventory_item_id,delivery_detail_id,split_from_delivery_detail_id,creation_date
FROM WSH_DELIVERY_DETAILS
WHERE source_line_id = p_source_line_id
AND source_code = p_source_code;
SELECT min(creation_date)
FROM WSH_DELIVERY_DETAILS
WHERE source_line_id = p_source_line_id
AND source_code = p_source_code;
SELECT ATP_FLAG
FROM MTL_SYSTEM_ITEMS
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = p_org_id;
* If DLVY p_entity_ids are to be deliveryIds (This will also update underlying containers if any)
* If LPN p_entity_ids are to be ContainerId(delivery_detail_ids with container flag 'Y')
* If DLVB p_entity_ids are to be delivery_detail_ids. From the delivery_detail_ids delivery_ids,container_ids
* are derived.
* If the delivery_detail_id is assigned to delivery_id the corresponding delivery_id is added to delivery_list.
* If the delivery_detail_id is packed in container the corresponding container_id(delivery_detail_id)
* is added to container_list
* If the delivery_detail_id itself is container then it is added to container_list
* Atlast the tp dates are calculated for sorted delivery_list and container_list.
*/
PROCEDURE calculate_cont_del_tpdates(p_entity IN VARCHAR2,
p_entity_ids IN wsh_util_core.id_tab_type,
x_return_status OUT NOCOPY VARCHAR2) IS
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'calculate_cont_del_tpdates';
SELECT wda.parent_delivery_detail_id,wda.delivery_id,container_flag
FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
WHERE wda.delivery_detail_id = wdd.delivery_detail_id
AND wda.delivery_detail_id = p_delivery_detail_id;
SELECT earliest_pickup_date,
earliest_dropoff_date,
latest_pickup_date,
latest_dropoff_date,
initial_pickup_date,
ultimate_dropoff_date,
ignore_for_planning --OTM R12
FROM WSH_NEW_DELIVERIES
WHERE delivery_id = p_delivery_id
FOR UPDATE NOWAIT;
SELECT wdd.delivery_detail_id,wda.delivery_id
FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
WHERE wda.delivery_detail_id = wdd.delivery_detail_id
AND wdd.container_flag = 'Y'
-- AND wda.parent_delivery_detail_id IS NULL
AND wda.delivery_id = p_delivery_id;
SELECT max(wdd.earliest_pickup_date),max(wdd.earliest_dropoff_date),
min(wdd.latest_pickup_date),min(wdd.latest_dropoff_date),
min(wdd.date_scheduled), min(wdd.date_requested), max(wdd.date_scheduled)
FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
WHERE wda.delivery_detail_id = wdd.delivery_detail_id
AND wda.parent_delivery_detail_id IS NULL
AND wda.delivery_id = p_delivery_id;
SELECT max(date_scheduled) , min(date_scheduled),min(date_requested),max(date_requested)
FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
WHERE wda.delivery_detail_id = wdd.delivery_detail_id
AND delivery_id =p_delivery_id;
SELECT shipment_direction
FROM wsh_new_deliveries
WHERE delivery_id =p_delivery_id
AND shipment_direction IN ('I','D');
l_tms_update VARCHAR2(1);
l_tms_update := 'N';
l_delivery_info_tab.DELETE;
WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
l_tms_update := 'N';
l_tms_update := 'Y';
l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
l_tms_update := 'N';
WSH_DEBUG_SV.log(l_module_name,'l_tms_update flag', l_tms_update);
UPDATE WSH_NEW_DELIVERIES
SET earliest_pickup_date = l_earliest_mpickup_date,
earliest_dropoff_date = l_earliest_mdropoff_date,
latest_pickup_date = l_latest_mpickup_date,
latest_dropoff_date = l_latest_mdropoff_date,
initial_pickup_date = l_initial_mpickup_date,
ultimate_dropoff_date = l_ultimate_mdropoff_date,
--OTM R12, glog proj
TMS_INTERFACE_FLAG = DECODE(l_tms_update,
'Y', l_new_interface_flag_tab(1),
NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
TMS_VERSION_NUMBER = DECODE(l_tms_update,
'Y', l_tms_version_number,
NVL(tms_version_number, 1)),
--
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID,
last_update_login = FND_GLOBAL.LOGIN_ID
WHERE delivery_id = l_delivery_id;
IF (l_gc3_is_installed = 'Y' AND l_tms_update = 'Y') THEN--{
WSH_XC_UTIL.log_otm_exception(
p_delivery_info_tab => l_delivery_info_tab,
p_new_interface_flag_tab => l_new_interface_flag_tab,
x_return_status => l_return_status);
WSH_DEBUG_SV.log(l_module_name,'Cannot lock delivery for update',l_delivery_id);
l_updated_flag VARCHAR2(1);
SELECT parent_delivery_detail_id
FROM wsh_delivery_assignments_v
START WITH delivery_detail_id = p_delivery_detail_id
CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
SELECT Container_flag
FROM wsh_delivery_details
WHERE delivery_detail_id = p_delivery_detail_id;
x_updated_flag=> l_updated_flag,
x_delivery_id => l_delivery_id,
x_return_status=> x_return_status);
IF ( l_updated_flag = 'Y' ) THEN
-- Outer Containers
OPEN Outer_LPNS(l_lpndetail_ids(i));
x_updated_flag=> l_updated_flag,
x_return_status=> x_return_status);
IF (l_updated_flag = 'N') THEN
EXIT;
x_updated_flag OUT NOCOPY VARCHAR2,
x_delivery_id OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2) IS
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'calculate_lpn_tpdates';
SELECT max(earliest_pickup_date),max(earliest_dropoff_date),min(latest_pickup_date),min(latest_dropoff_date)
FROM wsh_delivery_assignments_v wda,wsh_delivery_details wdd
WHERE wda.delivery_detail_id = wdd.delivery_detail_id
AND parent_delivery_detail_id = c_delivery_detail_id;
UPDATE WSH_DELIVERY_DETAILS
SET earliest_pickup_date = l_earliest_mpickup_date,
earliest_dropoff_date = l_earliest_mdropoff_date,
latest_pickup_date = l_latest_mpickup_date,
latest_dropoff_date = l_latest_mdropoff_date,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.USER_ID
WHERE delivery_detail_id = p_delivery_detail_id
AND ( nvl(earliest_pickup_date, sysdate) <> nvl(l_earliest_mpickup_date, sysdate)
OR nvl(earliest_dropoff_date, sysdate) <> nvl(earliest_dropoff_date, sysdate)
OR nvl(latest_pickup_date, sysdate) <> nvl(latest_pickup_date, sysdate)
OR nvl(latest_dropoff_date, sysdate) <> nvl(latest_dropoff_date, sysdate) );
x_updated_flag := 'Y';
x_updated_flag := 'N';
l_sync_tmp_rec.operation_type := 'UPDATE';
SELECT ship_from_location_id
FROM wsh_delivery_details wdd
WHERE delivery_detail_id = p_delivery_detail_id;
SELECT wdd.ship_from_location_id
FROM wsh_delivery_details wdd ,wsh_delivery_assignments_v wda
WHERE wdd.delivery_detail_id = wda.delivery_detail_id
AND delivery_id = p_delivery_id
AND ROWNUM = 1;
SELECT wdd.ignore_for_planning,a.ship_from_location_id
FROM wsh_delivery_details wdd ,
(SELECT source_code,source_header_id,ship_set_id,ship_from_location_id
FROM wsh_delivery_details
WHERE delivery_detail_id = c_delivery_detail_id) a
WHERE
wdd.delivery_detail_id <> c_delivery_detail_id AND
nvl(wdd.ignore_for_planning,'N') <> p_ignore_for_planning AND
wdd.ship_set_id = a.ship_set_id AND
wdd.source_header_id = a.source_header_id AND
wdd.source_code= a.source_code AND
rownum <= 1;