DBA Data[Home] [Help]

APPS.GML_OPM_OM_CONV_MIG_PKG dependencies on WSH_NEW_DELIVERIES

Line 210: wsh_new_deliveries wnd,

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
214: and wda.delivery_id = wnd.delivery_id

Line 330: -- 3 update wsh_new_deliveries (trips do NOT store orgs) with the new org (all because of GMD's requirements);

326: GMI_RESERVATION_UTIL.PrintLn(' From Whse is mapped as a subinventory new organization_id is '|| l_organization_id);
327: -- From Whse is mapped as a subinventory, so need to
328: -- 1 update the SO line with new org (open_order_line_rec.ship_from_org_id) ;
329: -- 2 update any delivery details with new org;
330: -- 3 update wsh_new_deliveries (trips do NOT store orgs) with the new org (all because of GMD's requirements);
331: -- 4 use this new org id for the reservation to be created;
332: -- 5 update any mo lines with new org id -- 5731584
333:
334: /* need to update the SO line with new org (open_order_line_rec.ship_from_org_id) */

Line 400: update wsh_new_deliveries

396: FOR wsh1 in c_wsh_deliveres (open_order_line_rec.line_id)
397: LOOP
398: GMI_RESERVATION_UTIL.PrintLn(' before update to wsh_delivery_details for organization_id '|| l_organization_id);
399:
400: update wsh_new_deliveries
401: set organization_id = l_organization_id
402: where delivery_id = wsh1.delivery_id;
403:
404: END LOOP; -- FOR wsh1 in c_wsh_delivery_details(open_order_line_rec.line_id)