APPS.WMS_TASK_DISPATCH_GEN dependencies on WMS_WSH_WDD_GTEMP

Line 10709: FROM wms_wsh_wdd_gtemp WHERE lpn_id = lpnid_in_msn;

10705: SELECT serial_number
10706: , organization_id
10707: , inventory_item_id
10708: , transaction_temp_id, lpn_id
10709: FROM wms_wsh_wdd_gtemp WHERE lpn_id = lpnid_in_msn;
10710:
10711: -- DHERRING additional cursor to find all nested LPNs
10712: CURSOR child_lpns_csr IS
10713: SELECT lpn_id

Line 11755: DELETE wms_wsh_wdd_gtemp;

11751:
11752: -- VARAJAGO for bug 5222498, inserting the serial_number's group_mark_id into the temp table
11753: -- DHERRING added to change to include nested LPN solution.
11754:
11755: DELETE wms_wsh_wdd_gtemp;
11756: IF l_tran_type_id = 2 AND l_tran_action_id = 2 AND l_tran_source_type_id = 13
11757: AND l_lpn_context = 11 THEN -- only for the staging xfer transaction
11758:
11759: FOR rec_child_lpns_csr IN child_lpns_csr LOOP

Line 11766: INSERT INTO wms_wsh_wdd_gtemp

11762: mydebug('pick_drop: l_lpn_id : ' || rec_child_lpns_csr.lpn_id );
11763: mydebug('pick_drop: p_from_lpn_id : ' || p_from_lpn_id );
11764: END IF;
11765:
11766: INSERT INTO wms_wsh_wdd_gtemp
11767: (SERIAL_NUMBER
11768: , organization_id
11769: , INVENTORY_ITEM_ID
11770: , transaction_temp_id