APPS.WMS_SHIPPING_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 103: IF l_debug = 1 THEN debug('Deleting mtl_material_transactions_temp '); END IF;

99: INTO l_organization_id
100: FROM wsh_delivery_details
101: WHERE delivery_detail_id = l_delivery_detail_id;
102: END IF;
103: IF l_debug = 1 THEN debug('Deleting mtl_material_transactions_temp '); END IF;
104:
105: /* MRANA :
106: -- {{- Delete all pending staging move transactions in MMTT/WDT, for }}
107: -- {{ all the staged LPNs belonging to the given delivery }} */

Line 128: DELETE FROM mtl_material_transactions_temp

124: IF l_debug = 1 THEN
125: debug('could not fine Staging move WDTs ' || l_delivery_detail_id);
126: END IF;
127: END IF;
128: DELETE FROM mtl_material_transactions_temp
129: WHERE wms_task_type = 7
130: AND organization_id = l_organization_id
131: AND content_lpn_id IN
132: ( SELECT wlpn.outermost_lpn_id