APPS.WMS_SHIPPING_INTERFACE_GRP dependencies on WMS_WSH_WDD_GTEMP

Line 147: delete wms_wsh_wdd_gtemp;

143: BEGIN
144: x_return_status := g_ret_status_success;
145:
146: IF g_debug_on = 1 THEN print_debug('starting to copy the PL/SQL records to the temp table'); end if;
147: delete wms_wsh_wdd_gtemp;
148:
149: FOR i IN 1..p_delivery_detail_tbl.COUNT
150: LOOP
151: if p_delivery_detail_tbl(i).move_order_line_id is null then

Line 158: insert into wms_wsh_wdd_gtemp

154: ||p_delivery_detail_tbl(i).delivery_detail_id);
155: END IF;
156: RAISE g_exc_unexpected_error;
157: END IF;
158: insert into wms_wsh_wdd_gtemp
159: (delivery_detail_id,move_order_line_id)
160: values
161: ( p_delivery_detail_tbl(i).delivery_detail_id,p_delivery_detail_tbl(i).move_order_line_id);
162:

Line 178: , wms_wsh_wdd_gtemp wwwg

174: WHERE exists (
175: SELECT line_id
176: FROM mtl_txn_request_lines mtrl
177: , mtl_material_transactions_temp mmtt
178: , wms_wsh_wdd_gtemp wwwg
179: , mtl_txn_request_headers mtrh
180: WHERE mmtt.move_order_line_id =
181: wwwg.move_order_line_id
182: AND mtrl.line_id = mmtt.move_order_line_id

Line 216: From mtl_material_transactions_temp mmtt1,WMS_WSH_WDD_GTEMP wwwg

212: where -- first case, line is loaded into same lpn or has the same carton
213: mmtt.transfer_lpn_id is not null and -- the line is loaded
214: mmtt.transfer_lpn_id in -- loaded into a LPN which is included in the inputted lines
215: (Select nvl(transfer_lpn_id,cartonization_id)
216: From mtl_material_transactions_temp mmtt1,WMS_WSH_WDD_GTEMP wwwg
217: Where mmtt1.move_order_line_id = wwwg.move_order_line_id
218: and nvl(mmtt1.transfer_lpn_id,mmtt1.cartonization_id) is not null)
219: and not exists( select 1
220: from WMS_WSH_WDD_GTEMP www

Line 220: from WMS_WSH_WDD_GTEMP www

216: From mtl_material_transactions_temp mmtt1,WMS_WSH_WDD_GTEMP wwwg
217: Where mmtt1.move_order_line_id = wwwg.move_order_line_id
218: and nvl(mmtt1.transfer_lpn_id,mmtt1.cartonization_id) is not null)
219: and not exists( select 1
220: from WMS_WSH_WDD_GTEMP www
221: where www.move_order_line_id = mmtt.move_order_line_id)
222: and mmtt.parent_line_id is null -- excluding the bulk tasks
223: and mmtt.move_order_line_id is not null
224: );

Line 248: From mtl_material_transactions_temp mmtt1,WMS_WSH_WDD_GTEMP wwwg

244: from mtl_material_transactions_temp mmtt
245: where mmtt.transfer_lpn_id is null
246: and mmtt.cartonization_id in
247: (Select nvl(transfer_lpn_id,cartonization_id)
248: From mtl_material_transactions_temp mmtt1,WMS_WSH_WDD_GTEMP wwwg
249: Where mmtt1.move_order_line_id = wwwg.move_order_line_id
250: and nvl(mmtt1.transfer_lpn_id,mmtt1.cartonization_id) is not null)
251: and not exists( select 1
252: from WMS_WSH_WDD_GTEMP www

Line 252: from WMS_WSH_WDD_GTEMP www

248: From mtl_material_transactions_temp mmtt1,WMS_WSH_WDD_GTEMP wwwg
249: Where mmtt1.move_order_line_id = wwwg.move_order_line_id
250: and nvl(mmtt1.transfer_lpn_id,mmtt1.cartonization_id) is not null)
251: and not exists( select 1
252: from WMS_WSH_WDD_GTEMP www
253: where www.move_order_line_id = mmtt.move_order_line_id)
254: and mmtt.parent_line_id is null -- excluding the bulk tasks
255: and mmtt.move_order_line_id is not null
256: );