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_OPM_OM_CONV_MIG_PKG dependencies on WSH_DELIVERY_DETAILS

Line 41: l_wdd_rec wsh_delivery_details%rowtype;

37: l_msg_data VARCHAR2(2000);
38: l_return_status VARCHAR2(1);
39: l_IC$DEFAULT_LOCT VARCHAR2(255)DEFAULT NVL(FND_PROFILE.VALUE('IC$DEFAULT_LOCT'),' ') ;
40:
41: l_wdd_rec wsh_delivery_details%rowtype;
42: l_mo_line_rec ic_txn_request_lines%rowtype;
43: l_order_line oe_order_lines_all%rowtype;
44: l_ic_mo_header_rec ic_txn_request_headers%rowtype;
45: l_mtl_mo_header_rec INV_Move_Order_PUB.Trohdr_Rec_Type := INV_Move_Order_PUB.G_MISS_TROHDR_REC;

Line 133: FROM wsh_delivery_details wdd,

129: wdd.organization_id,
130: to_char(NULL) schedule_status_code,
131: 'WDD' source,
132: 0 qty
133: FROM wsh_delivery_details wdd,
134: mtl_parameters mtl
135: WHERE wdd.organization_id = mtl.organization_id
136: AND mtl.process_enabled_flag = 'Y'
137: AND wdd.released_status in ('B','R','S', 'X'); -- 5475003 need to include status X for non inv items

Line 189: FROM wsh_delivery_details

185: AND line_status = 7; -- 7 is open , 5 is closed , 9 is cancelled
186:
187: CURSOR get_delivery_details(p_mo_line_id IN NUMBER, p_line_id IN NUMBER) IS
188: SELECT delivery_detail_id
189: FROM wsh_delivery_details
190: WHERE move_order_line_id = p_mo_line_id
191: AND source_line_id = p_line_id;
192:
193: CURSOR get_move_order_header(p_line_id IN NUMBER) IS

Line 209: from wsh_delivery_details wdd,

205:
206: --5574631
207: CURSOR c_wsh_deliveres (p_line_id in number) is
208: select distinct wda.delivery_id
209: from wsh_delivery_details wdd,
210: wsh_new_deliveries wnd,
211: wsh_delivery_assignments wda
212: where wdd.source_line_id = p_line_id
213: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 392: update wsh_delivery_details

388: raise FND_API.G_EXC_ERROR;
389: END IF; -- IF (l_failure_count1 > 0) THEN
390:
391: /* possibly multiple delivery details are updated */
392: update wsh_delivery_details
393: set organization_id = l_organization_id
394: where source_line_id = open_order_line_rec.line_id;
395:
396:

Line 397: GMI_RESERVATION_UTIL.PrintLn(' after update to wsh_delivery_details for organization_id '|| l_organization_id);

393: set organization_id = l_organization_id
394: where source_line_id = open_order_line_rec.line_id;
395:
396:
397: GMI_RESERVATION_UTIL.PrintLn(' after update to wsh_delivery_details for organization_id '|| l_organization_id);
398: /* update the deliveries to reflect the new organization */
399:
400: FOR wsh1 in c_wsh_deliveres (open_order_line_rec.line_id)
401: LOOP

Line 402: GMI_RESERVATION_UTIL.PrintLn(' before update to wsh_delivery_details for organization_id '|| l_organization_id);

398: /* update the deliveries to reflect the new organization */
399:
400: FOR wsh1 in c_wsh_deliveres (open_order_line_rec.line_id)
401: LOOP
402: GMI_RESERVATION_UTIL.PrintLn(' before update to wsh_delivery_details for organization_id '|| l_organization_id);
403:
404: update wsh_new_deliveries
405: set organization_id = l_organization_id
406: where delivery_id = wsh1.delivery_id;

Line 408: END LOOP; -- FOR wsh1 in c_wsh_delivery_details(open_order_line_rec.line_id)

404: update wsh_new_deliveries
405: set organization_id = l_organization_id
406: where delivery_id = wsh1.delivery_id;
407:
408: END LOOP; -- FOR wsh1 in c_wsh_delivery_details(open_order_line_rec.line_id)
409:
410:
411: l_insert_rsv_rec.organization_id := l_organization_id;
412:

Line 880: -- need to get delivery_detail_id from wsh_delivery_details for this old ic MO in order to populate field txn_source_line_detail_id -- 5601081

876: CLOSE get_sales_order_id;
877: GMI_RESERVATION_UTIL.PrintLn('l_sales_order_id : '|| l_sales_order_id);
878:
879: begin
880: -- need to get delivery_detail_id from wsh_delivery_details for this old ic MO in order to populate field txn_source_line_detail_id -- 5601081
881: OPEN get_delivery_details(move_order_line_rec.line_id,open_order_line_rec.line_id);
882: FETCH get_delivery_details INTO l_delivery_detail_id;
883: CLOSE get_delivery_details;
884: EXCEPTION

Line 1026: /* UPDATE the WSH_DELIVERY_DETAILS with this new move order info */

1022: /* do not create discrete move order as this item is non inventory item. */
1023: NULL;
1024: END IF; -- IF l_opm_noninv_ind = 0 THEN -- 5475003 rework 10/19
1025:
1026: /* UPDATE the WSH_DELIVERY_DETAILS with this new move order info */
1027: GMI_RESERVATION_UTIL.PrintLn(' before update of wsh_delivery_detail for move order line id');
1028:
1029: -- need to incororate this into fix for non inv items and MOs
1030:

Line 1040: UPDATE wsh_delivery_details

1036: GMI_RESERVATION_UTIL.PrintLn(' in loop to update wsh_delivery_detail l_opm_noninv_ind '||to_char(l_opm_noninv_ind ));
1037:
1038: -- if non_inv item need to set dd to staged 5475003
1039: IF l_opm_noninv_ind = 1 THEN -- 5475003 rework - if here then this is non inventory item (as per OPM)
1040: UPDATE wsh_delivery_details
1041: SET released_status = 'Y', -- 5475003
1042: picked_quantity = move_order_line_rec.quantity, -- 5475003
1043: picked_quantity2 = move_order_line_rec.secondary_quantity -- 5475003
1044: WHERE delivery_detail_id = delivery_detail_rec.delivery_detail_id;

Line 1047: UPDATE wsh_delivery_details

1043: picked_quantity2 = move_order_line_rec.secondary_quantity -- 5475003
1044: WHERE delivery_detail_id = delivery_detail_rec.delivery_detail_id;
1045:
1046: ELSE
1047: UPDATE wsh_delivery_details
1048: SET move_order_line_id = l_mo_line_id
1049: WHERE delivery_detail_id = delivery_detail_rec.delivery_detail_id;
1050:
1051: END IF; -- IF l_opm_noninv_ind = 1 THEN -- 5475003