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.WSH_INTERFACE dependencies on WSH_DELIVERY_DETAILS

Line 428: from wsh_delivery_Details dd,

424: s.stop_id,
425: s.actual_departure_date,
426: nd.name,
427: dd.shipped_quantity
428: from wsh_delivery_Details dd,
429: wsh_trip_stops s,
430: wsh_delivery_legs dl,
431: wsh_delivery_assignments_v da,
432: wsh_new_deliveries nd

Line 822: FROM mtl_customer_items mci, wsh_delivery_details dd, oe_order_lines_all ool

818: IS
819: CURSOR C_container
820: IS
821: SELECT mci.master_container_item_id, mci.detail_container_item_id
822: FROM mtl_customer_items mci, wsh_delivery_details dd, oe_order_lines_all ool
823: WHERE dd.delivery_detail_id = p_delivery_detail_id AND
824: dd.source_line_id = ool.line_id AND
825: mci.customer_item_id(+) = ool.ordered_item_id AND
826: ool.item_identifier_type = 'CUST';

Line 863: UPDATE wsh_delivery_details

859: IF (C_Container%NOTFOUND) THEN
860: CLOSE C_Container;
861: RAISE no_container;
862: ELSE
863: UPDATE wsh_delivery_details
864: SET master_container_item_id = l_master_container_item_id,
865: detail_container_item_id = l_detail_container_item_id
866: WHERE delivery_detail_id = p_delivery_detail_id;
867: CLOSE C_Container;

Line 905: p_old_delivery_detail_info IN WSH_DELIVERY_DETAILS%ROWTYPE

901: END Default_Container;
902:
903:
904: PROCEDURE Populate_Detail_Info(
905: p_old_delivery_detail_info IN WSH_DELIVERY_DETAILS%ROWTYPE
906: , x_new_delivery_detail_info OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
907: , x_return_status OUT NOCOPY VARCHAR2
908: )
909: IS

Line 1104: FROM wsh_delivery_details

1100: released_status,
1101: source_code,
1102: container_flag,
1103: source_line_id -- Column added for Bug 5741373
1104: FROM wsh_delivery_details
1105: WHERE delivery_detail_id = c_detail_id;
1106:
1107: l_detail_rec c_details%ROWTYPE;
1108:

Line 1200: FROM wsh_delivery_details

1196: -- if delivery line is packed, log exception for it
1197:
1198: SELECT container_name
1199: INTO l_container_name
1200: FROM wsh_delivery_details
1201: WHERE delivery_detail_id = l_assign_rec.parent_delivery_detail_id;
1202:
1203: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_PACKING');
1204: l_msg := FND_MESSAGE.GET;

Line 1312: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

1308:
1309: -- HW OPMCONV - Removed branching
1310:
1311: IF l_debug_on THEN
1312: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1313: END IF;
1314:
1315: -- HW OPMCONV - Added Qty2
1316: WSH_DELIVERY_DETAILS_ACTIONS.Unreserve_delivery_detail(

Line 1316: WSH_DELIVERY_DETAILS_ACTIONS.Unreserve_delivery_detail(

1312: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1313: END IF;
1314:
1315: -- HW OPMCONV - Added Qty2
1316: WSH_DELIVERY_DETAILS_ACTIONS.Unreserve_delivery_detail(
1317: p_delivery_detail_id => p_details_id(i),
1318: p_quantity_to_unreserve => NVL(l_detail_rec.picked_quantity, l_detail_rec.requested_quantity),
1319: p_quantity2_to_unreserve => NVL(l_detail_rec.picked_quantity2, l_detail_rec.requested_quantity2),
1320: p_unreserve_mode => 'UNRESERVE',

Line 1341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);

1337: ELSE
1338: -- J: W/V Changes
1339: IF (l_assign_rec.parent_delivery_detail_id IS NOT NULL) THEN
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
1342: END IF;
1343:
1344: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(
1345: p_detail_id => p_details_id(i),

Line 1344: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(

1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
1342: END IF;
1343:
1344: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(
1345: p_detail_id => p_details_id(i),
1346: p_validate_flag => 'N',
1347: x_return_status => l_return_status);
1348:

Line 1361: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

1357: END IF;
1358:
1359: IF (l_assign_rec.delivery_id IS NOT NULL) THEN
1360: IF l_debug_on THEN
1361: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1362: END IF;
1363:
1364: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(
1365: p_detail_id => p_details_id(i),

Line 1364: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(

1360: IF l_debug_on THEN
1361: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1362: END IF;
1363:
1364: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(
1365: p_detail_id => p_details_id(i),
1366: p_validate_flag => 'N',
1367: x_return_status => l_return_status);
1368:

Line 1381: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to CANCEL',WSH_DEBUG_SV.C_PROC_LEVEL);

1377: END IF;
1378:
1379: IF (p_cancel_delete_flag = 'C') THEN
1380: IF l_debug_on THEN
1381: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to CANCEL',WSH_DEBUG_SV.C_PROC_LEVEL);
1382: END IF;
1383:
1384: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
1385: p_delivery_detail_id => p_details_id(i),

Line 1384: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(

1380: IF l_debug_on THEN
1381: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to CANCEL',WSH_DEBUG_SV.C_PROC_LEVEL);
1382: END IF;
1383:
1384: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
1385: p_delivery_detail_id => p_details_id(i),
1386: p_cancel_flag => 'Y',
1387: x_return_status => l_return_status );
1388:

Line 1391: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);

1387: x_return_status => l_return_status );
1388:
1389: ELSE -- delete details
1390: IF l_debug_on THEN
1391: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
1392: END IF;
1393:
1394: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
1395: p_delivery_detail_id => p_details_id(i),

Line 1394: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(

1390: IF l_debug_on THEN
1391: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
1392: END IF;
1393:
1394: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
1395: p_delivery_detail_id => p_details_id(i),
1396: p_cancel_flag => 'N',
1397: x_return_status => l_return_status );
1398:

Line 1476: UPDATE wsh_delivery_details

1472: /* H integration: 940/945 cancel lines wrudge */
1473: IF l_cancel_dds.count > 0 THEN
1474: -- UPDATE is copied/modified from Backorder API
1475: FORALL i IN 1..l_cancel_dds.count
1476: UPDATE wsh_delivery_details
1477: SET move_order_line_id = NULL ,
1478: released_status = 'D',
1479: cycle_count_quantity = NULL,
1480: cycle_count_quantity2 = NULL,

Line 1500: -- Update of wsh_delivery_details where requested_quantity/released_status

1496: -- delivery assignment records are not modified for source_code WSH.
1497: --
1498: -- Use l_cancel_dds to pass as table of delivery detail ids
1499: -- DBI Project
1500: -- Update of wsh_delivery_details where requested_quantity/released_status
1501: -- are changed, call DBI API after the update.
1502: -- DBI API will check if DBI is installed
1503: IF l_debug_on THEN
1504: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_cancel_dds.count);

Line 1925: from wsh_delivery_Details

1921: --
1922:
1923: CURSOR c_details IS
1924: select detail_container_item_id , inventory_item_id , organization_id
1925: from wsh_delivery_Details
1926: where move_order_line_id = p_move_order_line_id
1927: and nvl(line_direction, 'O') IN ('O', 'IO')
1928: and rownum = 1 ;
1929:

Line 2065: FROM wsh_delivery_details wdd

2061: CURSOR c_source_line_to_lock(x_source_line_id NUMBER,
2062: x_neg_source_line_id NUMBER,
2063: x_source_code VARCHAR2) IS
2064: SELECT wdd.delivery_detail_id
2065: FROM wsh_delivery_details wdd
2066: WHERE wdd.source_line_id IN (x_source_line_id, x_neg_source_line_id)
2067: AND wdd.source_code = x_source_code
2068: AND wdd.container_flag = 'N'
2069: AND wdd.released_status <> 'D';

Line 2113: -- lock records in WSH_DELIVERY_DETAILS and wsh_delivery_assignments_v (if not Pick Confirm)

2109: --
2110: <>
2111: FOR l_counter IN p_changed_attributes.FIRST .. p_changed_attributes.LAST LOOP
2112:
2113: -- lock records in WSH_DELIVERY_DETAILS and wsh_delivery_assignments_v (if not Pick Confirm)
2114: -- unless we are importing source lines.
2115: -- We also look up delivery's status (if not Pick Confirm)
2116: IF p_changed_attributes(l_counter).action_flag <> 'I' THEN
2117:

Line 2234: from wsh_delivery_details

2230: -- has a line that is alredy pending interface.
2231:
2232: cursor c_check_ship_set(c_ship_set IN NUMBER, c_source_header_id IN NUMBER) is
2233: select ship_set_id
2234: from wsh_delivery_details
2235: where source_header_id = c_source_header_id
2236: and ship_set_id = c_ship_set
2237: and source_code = p_source_code
2238: and oe_interfaced_flag = 'P'

Line 2289: FROM wsh_delivery_details wdd,

2285: l_det_status_code,
2286: l_ship_set_id,
2287: l_source_header_id,
2288: l_dummy_id
2289: FROM wsh_delivery_details wdd,
2290: wsh_delivery_assignments_v wda
2291: WHERE wdd.delivery_detail_id = p_delivery_detail_id
2292: AND wdd.delivery_detail_id = wda.delivery_detail_id
2293: AND wdd.container_flag = 'N'

Line 2709: FROM wsh_delivery_details wdd,

2705: wdd.volume_uom_code,
2706: wda.delivery_id,
2707: wda.parent_delivery_detail_id,
2708: wdd.released_status
2709: FROM wsh_delivery_details wdd,
2710: wsh_delivery_assignments_v wda
2711: WHERE wdd.delivery_detail_id = v_delivery_detail_id
2712: AND wdd.delivery_detail_id = wda.delivery_detail_id;
2713: -- cannot add wda.delivery_id is not null because this is a generic

Line 2730: FROM wsh_delivery_details wdd,

2726: wdd.volume_uom_code,
2727: wda.delivery_id,
2728: wda.parent_delivery_detail_id,
2729: wdd.released_status
2730: FROM wsh_delivery_details wdd,
2731: wsh_delivery_assignments_v wda
2732: WHERE wdd.source_line_id = v_source_line_id
2733: AND wdd.delivery_detail_id = wda.delivery_detail_id
2734: AND nvl(wdd.line_direction, 'O') IN ('O', 'IO');

Line 2739: l_source_line_id wsh_delivery_details.source_line_id%TYPE;

2735: i NUMBER;
2736: l_dd_rec wsh_interface.delivery_detail_rec;
2737: l_dd_tab wsh_interface.deliverydetailtab;
2738: l_dd_ids wsh_util_core.id_tab_type;
2739: l_source_line_id wsh_delivery_details.source_line_id%TYPE;
2740: --
2741: l_debug_on BOOLEAN;
2742: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DETAILS_SNAPSHOT';
2743: --