APPS.INV_RECEIVING_TRANSACTION dependencies on WMS_LPN_HISTORIES

Line 116: FROM wms_lpn_histories wlh

112: , wlh.quantity
113: , wlh.uom_code
114: , wlh.organization_id
115: , wlh.source_name
116: FROM wms_lpn_histories wlh
117: WHERE wlh.source_header_id = p_group_id;
118:
119: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
120: BEGIN

Line 930: DELETE FROM wms_lpn_histories

926: IF (l_debug = 1) THEN
927: print_debug('Delete records from WLPN with context 6, operation_mode of -99999 and group_id', 4);
928: END IF;
929:
930: DELETE FROM wms_lpn_histories
931: WHERE source_header_id = p_group_id
932: AND lpn_context = 6
933: AND operation_mode = -99999;
934: