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

Line 22: FROM wsh_delivery_details wdd,

18: unshipped_count NUMBER;
19:
20: CURSOR specified_ship_set IS
21: SELECT wdd.ship_set_id
22: FROM wsh_delivery_details wdd,
23: wsh_delivery_assignments wda
24: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
25: AND EXISTS (SELECT 'x'
26: FROM wsh_delivery_details wdd2

Line 26: FROM wsh_delivery_details wdd2

22: FROM wsh_delivery_details wdd,
23: wsh_delivery_assignments wda
24: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
25: AND EXISTS (SELECT 'x'
26: FROM wsh_delivery_details wdd2
27: WHERE wdd2.delivery_detail_id = wdd.delivery_detail_id
28: AND wdd2.ship_set_id is not null
29: AND wdd2.shipped_quantity is not null)
30: AND wda.delivery_id = p_delivery_id;

Line 40: FROM wsh_delivery_details wdd,

36: FETCH specified_ship_set INTO l_ship_set_id;
37: EXIT WHEN specified_ship_set%NOTFOUND;
38: SELECT count(*)
39: INTO unshipped_count
40: FROM wsh_delivery_details wdd,
41: wsh_delivery_assignments wda,
42: wsh_new_deliveries wnd
43: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
44: AND wda.delivery_id = wnd.delivery_id

Line 82: from wsh_delivery_details wdd,

78: select 1
79: into exist_unspecified
80: from dual
81: where exists (select 1
82: from wsh_delivery_details wdd,
83: wsh_delivery_assignments wda
84: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
85: AND wdd.shipped_quantity is null
86: AND wda.delivery_id = p_delivery_id

Line 111: ---FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,

107: dd.serial_number, del.waybill, Nvl(msik.serial_number_control_code, 1),
108: dd.subinventory, Nvl(dd.locator_id,0),dd.tracking_number,
109: nvl(dd.transaction_temp_id,0),
110: dd.picked_quantity, dd.requested_quantity_uom2, NVL(dd.lot_number, ' '), NVL(dd.picked_quantity2,0)
111: ---FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,
112: FROM wsh_new_deliveries del, wsh_delivery_details dd,
113: wsh_delivery_assignments da, mtl_system_items_kfv msik
114: WHERE da.delivery_id = del.delivery_id
115: AND da.delivery_detail_id = dd.delivery_detail_id

Line 112: FROM wsh_new_deliveries del, wsh_delivery_details dd,

108: dd.subinventory, Nvl(dd.locator_id,0),dd.tracking_number,
109: nvl(dd.transaction_temp_id,0),
110: dd.picked_quantity, dd.requested_quantity_uom2, NVL(dd.lot_number, ' '), NVL(dd.picked_quantity2,0)
111: ---FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,
112: FROM wsh_new_deliveries del, wsh_delivery_details dd,
113: wsh_delivery_assignments da, mtl_system_items_kfv msik
114: WHERE da.delivery_id = del.delivery_id
115: AND da.delivery_detail_id = dd.delivery_detail_id
116: AND ( dd.inventory_item_id = p_inventory_item_id or p_inventory_item_id = -1 )

Line 147: ---from wsh_delivery_details_ob_grp_v dd

143: dd.requested_quantity,
144: dd.picked_quantity,
145: NVL(dd.requested_quantity2,0),
146: NVL(dd.picked_quantity2, 0)
147: ---from wsh_delivery_details_ob_grp_v dd
148: from wsh_delivery_details dd
149: WHERE dd.delivery_detail_id = p_delivery_detail_id;
150:
151: cursor lpn_csr(p_delivery_detail_id in NUMBER) is

Line 148: from wsh_delivery_details dd

144: dd.picked_quantity,
145: NVL(dd.requested_quantity2,0),
146: NVL(dd.picked_quantity2, 0)
147: ---from wsh_delivery_details_ob_grp_v dd
148: from wsh_delivery_details dd
149: WHERE dd.delivery_detail_id = p_delivery_detail_id;
150:
151: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
152: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id

Line 153: ---from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments wda, wsh_delivery_details_ob_grp_v wdd2

149: WHERE dd.delivery_detail_id = p_delivery_detail_id;
150:
151: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
152: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
153: ---from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments wda, wsh_delivery_details_ob_grp_v wdd2
154: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_details wdd2
155: , wsh_delivery_assignments wda2
156: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
157: and wda.delivery_detail_id = wdd2.delivery_detail_id

Line 154: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_details wdd2

150:
151: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
152: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
153: ---from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments wda, wsh_delivery_details_ob_grp_v wdd2
154: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_details wdd2
155: , wsh_delivery_assignments wda2
156: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
157: and wda.delivery_detail_id = wdd2.delivery_detail_id
158: and wdd2.delivery_detail_id = p_delivery_detail_id

Line 176: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

172: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
173: l_overpicked_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
174: l_dummy_table wsh_util_core.id_tab_type;
175: l_out_rows wsh_util_core.id_tab_type;
176: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
177: l_dummy_num_var NUMBER := NULL;
178: l_table_index NUMBER := 1;
179:
180: l_picked_quantity NUMBER;

Line 253: ---FROM wsh_delivery_details_ob_grp_v wdd

249: EXIT WHEN lpn_csr%NOTFOUND;
250:
251: SELECT lpn_id
252: INTO l_lpn_id
253: ---FROM wsh_delivery_details_ob_grp_v wdd
254: FROM wsh_delivery_details wdd
255: WHERE delivery_detail_id = l_parent_delivery_detail_id;
256:
257: --update LPN(s) context to Resides in Inventory

Line 254: FROM wsh_delivery_details wdd

250:
251: SELECT lpn_id
252: INTO l_lpn_id
253: ---FROM wsh_delivery_details_ob_grp_v wdd
254: FROM wsh_delivery_details wdd
255: WHERE delivery_detail_id = l_parent_delivery_detail_id;
256:
257: --update LPN(s) context to Resides in Inventory
258: FOR l_par_lpn_id IN nested_parent_lpn_cursor(l_lpn_id) LOOP

Line 276: WSH_DELIVERY_DETAILS_PUB.split_line

272: CLOSE lpn_csr;
273:
274: ELSE --corresponding if: p_shipped_quantity = 0
275:
276: WSH_DELIVERY_DETAILS_PUB.split_line
277: (p_api_version => 1.0,
278: p_init_msg_list => fnd_api.g_false,
279: p_commit => p_commit_flag,
280: x_return_status => l_return_status,

Line 297: wsh_delivery_details_pub.update_shipping_attributes

293: l_delivery_details_id_table(1);
294: l_detail_attributes(1).shipped_quantity := p_shipped_quantity;
295: l_detail_attributes(1).shipped_quantity2 := p_shipped_quantity2;
296:
297: wsh_delivery_details_pub.update_shipping_attributes
298: (p_api_version_number => 1.0,
299: p_init_msg_list => fnd_api.g_false,
300: p_commit => p_commit_flag,
301: x_return_status => l_return_status,

Line 361: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

357: p_missing_quantity2 IN NUMBER,
358: x_return_status OUT NOCOPY VARCHAR2,
359: x_msg_data OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER) IS
361: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
362: l_details VARCHAR2(2000);
363: BEGIN
364: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
365: l_detail_attributes(1).cycle_count_quantity2 := p_missing_quantity2;

Line 368: wsh_delivery_details_pub.update_shipping_attributes

364: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
365: l_detail_attributes(1).cycle_count_quantity2 := p_missing_quantity2;
366: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
367:
368: wsh_delivery_details_pub.update_shipping_attributes
369: (p_api_version_number => 1.0,
370: p_init_msg_list => FND_API.G_TRUE,
371: p_commit => FND_API.G_FALSE,
372: x_return_status => x_return_status,

Line 402: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

398: p_trackingNumber IN VARCHAR2,
399: x_return_status OUT NOCOPY VARCHAR2,
400: x_msg_data OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER ) IS
402: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
403:
404:
405: l_details VARCHAR2(2000);
406:

Line 412: FROM WSH_DELIVERY_DETAILS_OB_GRP_V

408: CURSOR c_weight_vol_info IS
409: SELECT unit_weight,
410: unit_volume
411: --- nvl(wv_frozen_flag ,'N') wv_frozen_flag
412: FROM WSH_DELIVERY_DETAILS_OB_GRP_V
413: WHERE delivery_detail_id = p_delivery_line_id;
414:
415: l_weight_vol_info c_weight_vol_info%ROWTYPE;
416:

Line 433: /** Eddie : Do we need the following ?? wv_frozen_flag is not in WSH_DELIVERY_DETAILS_OB_GRP_V

429: IF p_quantity2 IS NOT NULL then
430: l_detail_attributes(1).shipped_quantity2 := p_quantity2;
431: END IF;
432:
433: /** Eddie : Do we need the following ?? wv_frozen_flag is not in WSH_DELIVERY_DETAILS_OB_GRP_V
434: OPEN c_weight_vol_info;
435:
436: FETCH c_weight_vol_info INTO l_weight_vol_info;
437:

Line 463: wsh_delivery_details_pub.update_shipping_attributes

459: END IF;
460:
461: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
462:
463: wsh_delivery_details_pub.update_shipping_attributes
464: (p_api_version_number => 1.0,
465: p_init_msg_list => FND_API.G_TRUE,
466: p_commit => FND_API.G_FALSE,
467: x_return_status => x_return_status,

Line 713: FROM wsh_new_deliveries wnd, wsh_delivery_assignments wda,wsh_delivery_details wdd

709: SELECT distinct wnd.name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
710:
711: wnd.waybill,
712: Get_Shipmethod_Meaning(wnd.ship_method_code)
713: FROM wsh_new_deliveries wnd, wsh_delivery_assignments wda,wsh_delivery_details wdd
714:
715: WHERE wda.delivery_Detail_id = wdd.delivery_Detail_id
716: AND wda.delivery_id = wnd.delivery_id
717: and ( wdd.released_status = 'Y' or wdd.released_status = 'X')

Line 750: FROM mtl_system_items_kfv msik, wsh_delivery_details dd, wsh_delivery_assignments da,

746: OPEN x_items FOR
747: SELECT DISTINCT msik.concatenated_segments concatenated_segments
748: , msik.inventory_item_id
749: , msik.description
750: FROM mtl_system_items_kfv msik, wsh_delivery_details dd, wsh_delivery_assignments da,
751: wsh_new_deliveries nd
752: WHERE msik.concatenated_segments LIKE (p_concatenated_segments)
753: AND msik.organization_id = p_organization_id
754: AND msik.inventory_item_id = dd.inventory_item_id

Line 770: wsh_delivery_details dd,

766: SELECT DISTINCT msik.concatenated_segments concatenated_segments
767: , msik.inventory_item_id
768: , msik.description
769: FROM mtl_system_items_kfv msik,
770: wsh_delivery_details dd,
771: wsh_delivery_assignments da,
772: wsh_new_deliveries nd,
773: mtl_cross_references mcr
774: WHERE msik.organization_id = p_organization_id