APPS.WMS_TASK_DISPATCH_GEN dependencies on WMS_WSH_WDD_GTEMP

Line 10680: FROM wms_wsh_wdd_gtemp WHERE lpn_id = lpnid_in_msn;

10676: SELECT serial_number
10677: , organization_id
10678: , inventory_item_id
10679: , transaction_temp_id, lpn_id
10680: FROM wms_wsh_wdd_gtemp WHERE lpn_id = lpnid_in_msn;
10681:
10682: -- DHERRING additional cursor to find all nested LPNs
10683: CURSOR child_lpns_csr IS
10684: SELECT lpn_id

Line 11606: DELETE wms_wsh_wdd_gtemp;

11602:
11603: -- VARAJAGO for bug 5222498, inserting the serial_number's group_mark_id into the temp table
11604: -- DHERRING added to change to include nested LPN solution.
11605:
11606: DELETE wms_wsh_wdd_gtemp;
11607: IF l_tran_type_id = 2 AND l_tran_action_id = 2 AND l_tran_source_type_id = 13
11608: AND l_lpn_context = 11 THEN -- only for the staging xfer transaction
11609:
11610: FOR rec_child_lpns_csr IN child_lpns_csr LOOP

Line 11617: INSERT INTO wms_wsh_wdd_gtemp

11613: mydebug('pick_drop: l_lpn_id : ' || rec_child_lpns_csr.lpn_id );
11614: mydebug('pick_drop: p_from_lpn_id : ' || p_from_lpn_id );
11615: END IF;
11616:
11617: INSERT INTO wms_wsh_wdd_gtemp
11618: (SERIAL_NUMBER
11619: , organization_id
11620: , INVENTORY_ITEM_ID
11621: , transaction_temp_id